MYSQL Query Error (Result Array)

Question

I have this result

Furni Count: Array

My code is

$query2 = mysql_query(
                "SELECT COUNT(DISTINCT id) FROM items
                 WHERE base_item='" . $weekly2['furniture_id'] . "'"
           );

$OwnerCount = mysql_fetch_array($query2);
echo "<tr><td width=\"92%\" >Owner Count: $OwnerCount<form><input type=\"submit\" value=\"Owner Last Online\"></form></td></tr>";

EDIT: I added these lines and I get the result: 6,6 $string=implode(",",$OwnerCount); echo $string; — Chong Heng Loong
– Chong Heng Loong, Commented Feb 23, 2013 at 5:30
Nevermind, I solved it, I added [0] and got the result 6 as I wanted, so my code is $string=implode(",",$OwnerCount); echo $string[0]; — Chong Heng Loong
– Chong Heng Loong, Commented Feb 23, 2013 at 5:35

terwey · Accepted Answer · 2013-02-23 03:19:35Z

3

It's because your echoing an array, try print_r($Ownercount); and you should see the array (and the keys).

Example:

echo $Ownercount[0];

Should return the first key in the array (which is probably what you want).

answered Feb 23, 2013 at 3:19

terwey

312 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chong Heng Loong Over a year ago

Echo $OwnerCount[0]; and I get nothing(Owner Count: ) Print_r($OwnerCount); and I get the result Owner Count: print_r()

Eric Martins · Accepted Answer · 2013-02-23 03:21:42Z

0

you can put an alias on the query, like this :

COUNT(DISTINCT id) as total

and then call

$Ownercount["total"];

answered Feb 23, 2013 at 3:21

Eric Martins

4604 silver badges17 bronze badges

1 Comment

Chong Heng Loong Over a year ago

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

Collectives™ on Stack Overflow

MYSQL Query Error (Result Array)

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related