resource id # 53 error in mysql

Question

Possible Duplicate:
How do i “echo” a “Resource id #6” from a MySql response in PHP?

Hey guys, I got an error when I try to run my code in PHP. It displays resource id #53 in my screen. All I want is to count only the total of one of my field but I'm stuck with this error. Here's my code below:

$last_points = mysql_insert_id();
//echo $last_points , display like 12... no error
$fkid = $last_points;   // no error....
$sql = "SELECT COUNT(*) FROM downline WHERE fkmember = {$fkid}";
$execute = mysql_query($sql) or die (mysql_error());
echo $execute; //display error why?

Help me guys please. I think it's my query.

score 2 · Answer 1 · answered Sep 27 '12 at 06:09

2

First off, resource id #53 is not an error. You are displaying a resource, not the output of the query.

To show the output, use:

$last_points = mysql_insert_id();
//echo $last_points , display like 12... no error
$fkid = $last_points;   // no error....
$sql = "SELECT COUNT(*) FROM downline WHERE fkmember = {$fkid}";
$execute = mysql_query($sql) or die (mysql_error());
print_r(mysql_fetch_array($execute)); //display error why?

Secondly, the mysql_* functions are deprecated. You should look into learning and utilising the mysqli or PDO libraries accordingly.

answered Sep 27 '12 at 06:09

Daniel Li

14,976
6
43
60

i got Array ( [0] => 0 [COUNT(*)] => 0 ) means no data right? – rochellecanale Sep 27 '12 at 06:28
It means there were no results `WHERE fkmember = {$fkid}` – Daniel Li Sep 27 '12 at 06:29
i looked up it in my table there are 23 records. how can i get the records total? – rochellecanale Sep 27 '12 at 06:41

score 0 · Answer 2 · answered Sep 27 '12 at 06:11

0

Instead of trying to echo a resultset(as received because of mysql_query) do this:

print_r( mysql_fetch_array($execute) );

answered Sep 27 '12 at 06:11

hjpotter92

78,589
36
144
183

iLaYa ツ · Answer 3 · 2012-09-27T06:40:43.807

0

By codeigniter way

In Model:

function getCount($fkid)
        {
            $Qry = "SELECT * FROM downline WHERE fkmember = $fkid};
            $query = $this->db->query($Qry);
            return $query->num_rows();
        }

In controller:

echo $Count = $this->modelname->getCount($id);

edited Sep 27 '12 at 06:40

answered Sep 27 '12 at 06:15

iLaYa ツ

3,941
3
32
48

score 0 · Answer 4 · answered Sep 27 '12 at 06:17

0

$execute is an array so you need to print it among echoing it

print_r($execute);

answered Sep 27 '12 at 06:17

GautamD31

28,552
10
64
85

resource id # 53 error in mysql

4 Answers4