Failed to query correctly.
| From: | Denny | Date: | Tue, 04 Dec 2001 07:18:35 +0000 |
| Subject: | Failed to query correctly. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14797@lists.php.net to get a copy of this message | ||
Hi,
I got this problem when i tried to do a sql query and print the ouput. But the script below always
failed to return the first row of the records. But i do a manual query, i got the results i wanted.
Thanks,
Denny
$query="SELECT * from $tbl ";
$result=mysql_query($query);
while ($line = mysql_fetch_row($result)) {
while(list($col_name, $col_value) = each($line)) {
print "\t\t<td><p align=center>$col_value</p></td>\n";
}
}