Error Message

[Anon]

Hello, I had someone set up a random image script for me- I recently switched servers and the script no longer works
I get the following error:
"Warning: Wrong parameter count for mysql_fetch_row() in /home/science/www/index.html on line 115"

Line 115 looks like:
$pic = mysql_fetch_row($result, MYSQL_ASSOC);

Why would something work perfectly on one server and not on another? Below are the version of PHP running on each.

old server-
PHP/4.0.4pl1

New server-
PHP/4.0.6 mod_gzip

Besides the random image script the photo albums work fine. Can anyone point me in the right direction? THANKS and Happy New Year

[lxghak]

$pic = mysql_fetch_row($result, MYSQL_ASSOC);

Should be:

$pic = mysql_fetch_row($result);

The second parameter is no longer required.

[[deleted]]

Correction: nolonger allowed.

Just as it has become mandatory in some other functions to always specify all parameters (the way it should be)

[Anon]

I removed the offending bit- Now I don't get the error message but it dosent work either. Here is the whole bit of code. It worked fine on the old server??
Thank You all for you help

<?php

$db = mysql_connect("localhost","science","mypassword");

mysql_select_db("sciencerockscom",$db);

$result = mysql_query("SELECT , jrandom0+rand() as random FROM pictures WHERE pic_name LIKE \"%Tobias%\" ORDER BY random LIMIT 1");# or die ("No Results");

$pic = mysql_fetch_row($result);

$picName  = $pic["pic_name"];

$urlTitle = $pic["url_title"];

$picThumb = $pic["thumb_loc"];

$tHeight  = $pic["thumb_height"];

$tWidth   = $pic["thumb_width"];

//print "<p><a href=\"/pics/photo.html/$urlTitle\"><img src=\"$picThumb\" height=\"$tHeight\" width=\"$tWidth\"></a>\n";

//print "<br>&nbsp;<a href=\"/pics/photo.html/$urlTitle\">$picName</a></p>\n";

?>

[[deleted]]

$pic = mysql_fetch_row($result);
$picName = $pic["pic_name"];

mysql_fetch_row will retreive an array, but you need an associative array. try this instead:

$pic = mysql_fetch_array($result, MYSQL_ASSOC);

[Anon]

$pic = mysql_fetch_array($result, MYSQL_ASSOC);

This was what was originally there. I got the error message- the two post above suggested I remove the MYSQL_ASSOC line- now I dont get any errors but the script doesnt run.

Thanks,
Tobias

[[deleted]]

The original line had mysql_fetch_row(), this is mysql_fetch _array()