Recent content by Sitehelp

Leader1.StaffID is a field in the Dynamic table that contains the StaffIDs. A dynamic table is a table of results from your SQL query that appear in the browser. The table appears ok for everything but this query?

ok I have another query which displays all the staffIDs and the number of closed calls they have made with the SQL: SELECT StaffID, count(CallID) FROM callinfo WHERE callinfo.CallStatus = 'Closed' GROUP BY StaffID ORDER BY CallID ASC This works! It puts all the data into a dynamic table. The...

Could the following line cause this? WHERE callinfo.StaffID = '{$row_Leader1['StaffID']}' I say this because I have only called $row which I presume is one row?

Got ya! yep it returns one result! there should be more!

Ah problem was the case of: print $query_callsAssignedCount; just remembered its case sensitive and so therefore needs to be: print $query_CallsAssignedCount; Ok its now loading up code in the browser and the same in View Source, this is: SELECT StaffID, count(CallID) FROM callinfo WHERE...

will remember that one! ok I was getting a parse error so change too, but presume this is ok: exit(); when I load up the browser it returns a blank page, I presume this is not right!

ok so I copied: $query_CallsAssignedCount ; into my code after: $totalRows_CallsAssignedCount = mysql_num_rows($CallsAssignedCount); Then when I opened up the browser it gave me one result like before, is this what you asked? still learning...

by the way sorry for cross posting someone recommended trying there in the SQL forum earlier!

I have tried looping the code below but its still only returning one StaffID? 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"...

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...

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...

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...

Actually I have it now printing all the calls that are open for the first StaffID but not for the rest???? SELECT StaffID, count(CallID) FROM callinfo WHERE callinfo.CallStatus = 'Closed' GROUP BY StaffID ORDER BY CallID ASC The rest just get the same number of calls as the first for some...

Excellent that worked! I want to add an extra column to the results, I am using: SELECT count(callID) FROM callinfo WHERE callinfo.StaffID = '$row_Leader1.StaffID' Where '$row_Leader1.StaffID' is the StaffID result from the last query as its printing out in a dynamic table in Dreamweaver...

I am using PHP. What I want for the user to enter too dates in 01-01-2004 format. First they enter the Start Date then they enter an End Date. Then when they click submit a list of all CallsIDs in the DB will be listed that are between the two specified dates. Cheers