counting results from a mysql database

[otamendi]

 

Hi, i have a mysql database and a php script that uses that.

 

I want to know how many results throw a query in order to know if they have reached a limit.

 

I.E.

     $sql = mysql_query ("select * from classifieds where user='$username'");
while ($row = mysql_fetch_array($sql))
{
}

 

I want to check lets say that only 10 classifieds per  'username' can be created.

 

If ten or more classifieds are in the database for that 'username' then show error message.

 

[s0c0]

$sql = "select * from classifieds where user='$username'";
$result = mysql_query($sql);
$numRows = mysql_num_rows($result);
while($row = mysql_fetch_array($result)
{
// your code here
}

 

the number of rows returned will be stored in the $numRows variable.

 

[teng84]

select username, count(classifieds) from classifieds group by username

 

maybe^^

[s0c0]

That won't work, you can't count a table.

 

If you wanted to do this inside the query (which is not a bad idea at all) you would do a count(username) instead of count(classified).

[teng84]

oops sorry but you know thats not my intention instead the its the fields

 

any way you know its wrong and you know wht to change right?

[otamendi]

the number of rows returned will be stored in the $numRows variable.

 

Nice, thanks a lot am going to try it!