Jump to content

Archived

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

bdmovies

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

 

<?php
$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.