i use below code to display data from mysql row from specific id. here is id=1
mysql_connect("localhost", "dhaka", "dhaka") or die("Connection Failed");
mysql_select_db("dhaka")or die("Connection Failed");
$result = mysql_query("SELECT *FROM page WHERE id='[B]1[/B]'")
$row = mysql_fetch_array( $result );
echo "content: ".$row['dtl'];
now i included this code by using php include function in one page called " johns page.php"
so when i click the "john page" the page come with the pulling from id=1.
but if i have 30 page like " kate page" ," roberts page", "michale page"......
then i have to include the above code 30 time by editing it manusally have to change the id number.
for "kate page" i have to change manually the line
$result = mysql_query("SELECT *FROM page WHERE id='[B][/B]'")
$result = mysql_query("SELECT *FROM page WHERE id='[B]2[/B]'")
and include the code to " kate page.php"
which is horrible expreince for multiple page...
is it possible that the id number will automatically change when i click on different page?
please help me