what is wrong?

[Sebastian]

trying to get the latest articles from my database and it's returning: Fatal error: Call to undefined function: sql_fetch_row() in /path/to/home

i tried mysql_fetch_row and still gives me an error, any ideas?



<?php
$dbhostname= "localhost";
$dbusername= "";
$dbpassword= "";
$dbdatabase= "";
$table ="db_stories";

$db = @mysql_connect($dbhostname,$dbusername,$dbpassword );
$result = @mysql_query("SELECT sid, title, comments, counter from $table order by sid DESC limit 0,5", $db);

while(list($sid, $title, $comtotal, $counter) = sql_fetch_row($result, $db)) {

}

?>

[GSHelpBoy]

The valid function is mysql_fetch_row($result).

[Sebastian]

okay, this is the entire script and it gives me: Warning: Wrong parameter count for mysql_fetch_row() in /home/path/

what gives, am i doing something wrong?


<?php
$dbhostname= "localhost";
$dbusername= "db_user";
$dbpassword= "db_pass";
$dbdatabase= "db_name";
$table ="db_stories";


$db = @mysql_connect($dbhostname,$dbusername,$dbpassword );

$result = @mysql_query("SELECT sid, title, comments, counter from $table order by sid DESC limit 0,5", $db);
while(list($sid, $title, $comments, $counter) = mysql_fetch_row($result, $db)); {

}

?>

[GSHelpBoy]

The only parameter needed in the function mysql_fetch_row() is the query resource, so get rid of ', $db'.

Also, why do you have a semicolon (;) at the end of the line with the mysql_fetch_row function?

[Sebastian]

lol. i just noticed that semicolon, i removed it. thanks, it's working now, such a simple mistake can cause it not to work.