Newbie w/ a Mysql/PHP question

[Anon]

I need to get the number of rows from a particular table and store it as an integer into a php variable, and I currently have:

$result = mysql_query("select count(*) from User");
echo $result;

as the code to do that but for the displayed result I get this instead of an integer:

Resource id #2

I need to do this so I can construct a loop that checks to see is a record being added is already in the database. Any suggestions? Please email me at [e-mail], aby help will GREATLY be appreciated thanks!

Laura Young

[Anon]

Hi Laura,

Sorry for not sending this to your email address, but I figure others may need to know this as well. Besides, you'll prolly be notified of this response anyways.

So, the first thing you may want to do is download a copy of the PHP manual. It has a list of all the MySQL related functions, among others. The one you are looking for inparticular is mysql_num_rows(). You could add something like this to your code to see if it indeed working.

echo mysql_num_rows($result);

Notice that $result is passed as an argument.

Now based on what your query is, why use _num_rows()? The result of the query should give you the same answer. If you need the result of the query, use mysql_result(). To see that it works, do ...

echo mysql_result($result, count(*));

And you can pass it to variable by doing something like...

$records = mysql_result($result, count(*));

Let me know how this all works out.

morpheus()