Display more than one Result from DB

[Sitehelp]

Hi! Any ideas why this:

mysql_select_db($database_MARTIN, $MARTIN);
$query_CallsAssignedCount = "SELECT StaffID, count(CallID) FROM callinfo WHERE callinfo.StaffID = '$row_Leader1[StaffID]' GROUP BY StaffID ORDER BY CallID ASC";
$CallsAssignedCount = mysql_query($query_CallsAssignedCount, $MARTIN) or die(mysql_error());
$row_CallsAssignedCount = mysql_fetch_assoc($CallsAssignedCount);
$totalRows_CallsAssignedCount = mysql_num_rows($CallsAssignedCount);

only displays one result and not all StaffIDs? Its meant to list all StaffIDs and the number of calls closed by that staff member. '$row_Leader1[StaffID]' is the coloumn that lists all the client IDs on another form. This lists all StaffIDs fine, however, this SQL command (above)only displays ONE StaffIDs result. Cheers!

 

[sleipnir214]

Don't cross-post. It's annoying and rude.

Anyway, the problem is not with MySQL, but rather with your PHP code.

I have answered your question in thread434-790638

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[swampBoogie]

The SQL query does not make any sense. It should result in a semantic error as you can not get a predictable result.

Assume that you have the following data

staffid callid
--------------
______1 ______1
______1 ______2
______2 ______2
______2 ______1


Which value for callid should be used when ordering?