Re: Re: difference between php3 and php4

This error comes when trying to fetch data from a result set but there is no such because there was a problem with the query. Try var_dump($res) and you will see - 0. 0 is not a valid number for resource of type mysql or any other resource. To prevent this every time when using a resource identificator do : if ($res){ ... }else{ echo "something went wrong;";} I think the problem is etiher the sql query is not successful or php cannot connect to the mysql. $db = mysql_connect("localhost", "", ""); the username is empty?? Regards, Andrey Hristov ----- Original Message ----- From: "Todor Stoyanov" <todor@webfactory.bg> To: <php-general@lists.php.net> Sent: Friday, February 22, 2002 6:12 PM Subject: [PHP] Re: difference between php3 and php4 > You must first get the number of record set rows. > > The warning is because you trying to fetch a non existing row. > > "Toni Baker" <tanknank@yahoo.com> wrote in message > news:20020222155919.77695.qmail@web20304.mail.yahoo.com... > > Warning: Supplied argument is not a valid MySQL result > > resource in c:\program files\apache > > group\apache\cgi-bin\emp.php3 on line 10 > > > > $db = mysql_connect("localhost", "", ""); > > mysql_select_db("employee",$db); > > $result = mysql_query("SELECT * FROM employees",$db); > > echo "<table border=0>"; > > echo "<tr>"; > > echo "<td bgcolor=#FAFOE6 colspan=2><B>Name</B></td>"; > > echo "<td bgcolor=#FAFOE6><B>Address</B></td>"; > > echo "<td bgcolor=#FAFOE6><B>Position</B></td>"; > > echo "</tr>"; > > while($row = mysql_fetch_row($result)) > > { > > $fname = $row[1]; > > $lname = $row[2]; > > $address = $row[3]; > > $position = $row[4]; > > echo "<tr bgcolor=#C6E7DE>"; > > echo "<td>$fname</td>"; > > echo "<td>$lname</td>"; > > echo "<td>$address</td>"; > > echo "<td>$position</td>"; > > echo "</tr>"; > > } > > > > This script works in php3 but not in windows php4. > > The error message above points to the mysql_fetch_row > > function. Does this function work differently in > > php4? If not, what else might cause this script to > > work in php3 and not in php4? > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Sports - Coverage of the 2002 Olympic Games > > http://sports.yahoo.com > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >