Yes, if your $conn is valid in the first place, and your SQL is valid.

I think 'table' is a reserved word, so as-is, it won't work.

Add some error-checking code to see what MySQL is saying about your
connection and SQL.

WARNING [EMAIL PROTECTED] address is an endangered species -- Use
Wanna help me out?  Like Music?  Buy a CD:
Volunteer a little time:
----- Original Message -----
From: Chris Cocuzzo <[EMAIL PROTECTED]>
Newsgroups: php.general
Sent: Thursday, August 02, 2001 12:27 AM
Subject: [PHP]Getting rows in a db...

> hey-
> if I do this:
> $query = "SELECT user FROM table WHERE cat='band'";
> $result = mysql_query($query,$conn);
> $rows = mysql_num_rows($result);
> will I get something back from the $rows variable, or am I using the
> mysql_num_rows() function incorrectly. What I'm trying to do is get the
> number of rows returned as a result of that specific sql statement and
> query.
> thanks
> chris

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to