sql query
Posted: Fri Dec 27, 2002 1:37 am
I am having problems with the query below.
I did not understand why it did not work for me.
Please can anyone assist me???
Merry Xmas.
This is the error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource.
This error referred to the line -> while ( $myrow = mysql_fetch_array ($results )) { <-
I did not understand why it did not work for me.
Please can anyone assist me???
Merry Xmas.
Code: Select all
$sql = "SELECT received FROM $dbsql ORDER BY id LIMIT 1" ;
$results = mysql_query ( $sql );
while ( $myrow = mysql_fetch_array ($results )) {
$date = $myrow ["received" ];
echo $date ;
}Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource.
This error referred to the line -> while ( $myrow = mysql_fetch_array ($results )) { <-