[SOLVED] Basic mySQL query error: mysql_numrows()

[webmaster1]

Hi All,

 

Can anybody spot whats discrepant with the below query? It works fine without the WHERE index = '134' part. It seems to be related to the number of rows.

 

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource

 

<?php
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM test WHERE index = '134' ORDER BY date";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>

[Michdd]

It's

 

mysql_num_rows

 

not mysql_numrows

[webmaster1]

It's mysql_num_rows not mysql_numrows

 

Fixed but exact same error.

 

Perhaps its the query itself?

[PFMaBiSmAd]

It's either mysql_num_rows (current name) or mysql_numrows (old depreciated name.) Both work and an incorrect function name would not cause the error being output.

 

index is a reserved mysql keyword. Change your column name to something else or enclose it in back-ticks.

[revraz]

Using mysql_error() after your query would show you the reason.

[webmaster1]

I've changed my primary key name from index to [index] in mySQL and my code.

 

I still recieve the same error:

 

<?php
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM test WHERE [index] = '134' ORDER BY date";
mysql_error();
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();
?>

 

revraz: Was mysql_error() meant to have a semi-colon? If yes, I recieve the exact same error as above. If no, I recieve a parse error.

 

[revraz]

Not [index], `index`, or better yet, just change the name.

 

$result=mysql_query($query) or die (mysql_error());

 

 

[webmaster1]

Changed index to urn.

 

$query="SELECT * FROM test WHERE urn = '134' ORDER BY date";

 

Works perfectly!