Querying tables in php

[Guest_imported]

When i try to insert a record and select the same record
immeidiately from the table it doesn't display the first record.
When i insert the second record i'm able to select the second record.But the first record is not displayed.

Step1:Trying to insert a record using this statements
$query = "insert into cd_order values ( '".$date_added ."','".$session ."','".$cd_title ."')";
$result = mysql_query($query);

Step2:Trying to selct the same record
$result = mysql_query( "SELECT cd_title frOM cd_order where session='$session' "
$row = mysql_fetch_array($result);
$num_results = mysql_num_rows($result);

Step3:Trying to display the records in a table format which displays all the records other than the first record
for ($i=0 ;$i <= $num_results -1; $i++)
{
$row = mysql_fetch_array($result);
{
echo &quot;<TR><TD >&quot; .$row[cd_title]. &quot;</TD>\n&quot;;
}
}

Hope someone will help with the solution.

 

[steijssen]

Try to use this kind of insertion query:

$query = &quot;insert into cd_order (date_added,session,cd_title)values ( '&quot;.$date_added .&quot;','&quot;.$session .&quot;','&quot;.$cd_title .&quot;')&quot;;

Specifying the column names mostly does the trick.

Hope to have been of some useful assistance,
Stijn Teijssen

 

[steijssen]

Correction of previous post:

$query = &quot;insert into cd_order (date_added,session,cd_title)values ( '$date_added','$session','$cd_title')&quot;;

You don't need the '&quot;.$date_added.&quot;' structure