getting a number of rows that match a username...

[buddysal]

i need to know how to use mysql_fetch_row() or a mysql_num_row() function to get a number of referrals for his/her username...

or is it another type of function i need? not exactly sure how to do this...

[cgraz]

here's an example:

$query = mysql_query("SELECT * FROM your_table");
$count = mysql_num_rows($query);

echo "There were " . $count . " results found";

So basically, the function you are looking for is mysql_num_rows()

Cgraz

[buddysal]

so it would be like this for a full script....

$dbHost = "localhost";
$dbUser = "buddysal_admin";
$dbPass = "3585835";
$dbDatabase = "buddysal_rtr";

$db = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die ("Error connecting to database.");

mysql_select_db("$dbDatabase", $db) or die ("Couldn't select the database.");

$query = mysql_query("SELECT * FROM USERS");
$count = mysql_num_rows($query);

echo "Total Referrals: " . $count . " .";

something like that?

[buddysal]

ok thats telling me the total amount of rows... wether its under their username or not... i need it to show rows with their username in the SP field only

[cgraz]

$query = mysql_query("SELECT * FROM USERS WHERE username='john_a47'");

Where john_a47 is the username.

Cgraz

[buddysal]

thank you... it worked 😃 althought i had to change the

$query = mysql_query("SELECT * FROM USERS WHERE username='john_a47'");

to

$query = mysql_query("SELECT * FROM USERS WHERE SP='$username'");

thanks for helping me 😉