----- Original Message -----
From: "Daniel Israel"
On Oct 12, 2008, at 6:31 PM, <listgroups08> wrote:
----------------------------
<snip>
----------------------------
Try:
SELECT COUNT(*) FROM Assignments, Classes, Instructors, Departments
WHERE Assignments.ClassID = Classes.ClassID AND
Classes.DepartmentID = Departments.DepartmentID AND
Classes.InstructorID = Instructors.InstructorID
What gets returned is one row with one field (You have to read
that... calling mysql_num_rows() will return 1)
-D. Israel
------------------------------------
Thanks Daniel,
I just used -
$query = str_replace('*', 'COUNT(*)', $query)
before I added the LIMIT and ORDER BY instructions and it works perfectly.
Robert.
