Numbered results

SureFire

I have a table containing tutorials people have submitted to my site. One of the rows is called "author" I want a command that looks in this row for all tutorials by the same author, and displays the number of tutorials that user has submitted.

I tried

$query = "SELECT authors FROM tutorials";
$result=mysql_query($query);
$num=mysql_numrows($result);

But I just get an error.

I just started this php thing yesterday, and am already impressed with what can be accomplished with it so far, but obviously I don't know what the heck I'm doing yet.🙂

ultraslacker

It's helpful to give the error message, but my guess is it's undefined function.

use mysql_num_rows()

SureFire

Thanks for the reply! I should have done a better job of explaining my situtation.

If I wanted the number of johns submissions, how would I do that? I posted wrong above, I meant

$query = "SELECT john FROM authors FROM articles";
$result=mysql_query($query);
$num=mysql_numrows($result);

echo " $num ";

the error I get is:

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/internet/www/www/new.php on line 10

SureFire

I tried using num_rows instead but got the same message.

ultraslacker

You can also use COUNT in the sql query and get the result that way (skipping mysql_num_rows()).

Are you making a connection to the mysql database? You code shows no such connection.

SureFire

GOT IT!!!

by browsing I found this code

$query = "SELECT author FROM articles WHERE author='rocky'";

the WHERE command is what I was looking for.

I appreciate your help ultra

SureFire

Thanks for the COUNT advice ultra, and yes, I was connecting, I only posted the pertinent part of my code.