Re: syntax error
| From: | Ted Wood | Date: | Mon, 21 Jul 2008 11:28:42 +0000 |
| Subject: | Re: syntax error | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-277138@lists.php.net to get a copy of this message | ||
Not a syntax error. It's not successfully connecting to the database. Check your settings.
~Ted
On 21-Jul-08, at 4:24 AM, Ronald Wiplinger wrote:
On a system with php4 and mysql 4.x I had these lines:
require("../db-config"); // includes $dbhost, $buname, $dbpass
$db = mysql_connect($dbhost, $dbuname, $dbpass);
mysql_select_db($dbname,$db);
$sql = "SELECT * FROM CATEGORY WHERE .....";
$result = mysql_query($sql,$db);
$num=mysql_num_rows($result);
while ($myrow = mysql_fetch_array($result)) {
....
Moving the *.php to a php5 and mysql 5.x site I get these errors:
PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL
result resource in ...
PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in ...
Looking at the manual, I cannot see what I am doing wrong.
bye
R.