Jump to content


This topic is now archived and is closed to further replies.


[SOLVED] PHP/MySQL Resources

Recommended Posts

Ridiculously stupid question, I know - but I just cant' quite wrap my head around this one.


I need to know how many open jobs an employee has, simple enough.


$sql = "SELECT COUNT(*) FROM cases WHERE open = '1' AND initiatedBy = '$_SESSION[employeeID]'";
$result = mysql_query($sql);
$openCases = mysql_num_rows($result);
echo $openCases;


However, this returns 1 (the correct answer is 9...)


Why does echoing $result give me a Resource ID #? Shouldn't echoing $result show me what the query returned?


I'm using CocoaMySQL as well, and when I do a custom query using $sql It returns fine


I've also tried mysql_affected_rows.


What am I not seeing here?


Share this post

Link to post
Share on other sites

Count(*) only returns how many records, not a record.  Can you please show me the fields in your database?  Is there perhaps a field similar to "open_jobs"?

Share this post

Link to post
Share on other sites

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.