[RESOLVED] MySQL results array not same as query in DB

[Earnan]

I am running a query in a MySQL database, and the results I am getting in my array do not match the results from running the exact same SQL in MySQL.

Code:

   $CESQL = "SELECT 
  PosID,
  PeopleID
  FROM tblPerforming";
$CErslt = mysql_query($CESQL) or die("Error: ".mysql_error());
$CEArray = mysql_fetch_assoc($CErslt);
print_r($CEArray);

Note: I have tried mysql_fetch_array as well, it prints only the first record (just with a key as well).

Prints the following:
Array ( [PosID] => 24 [PeopleID] => 58 )

Run the output SQL (found from: echo $CESQL😉 in MySQL and the results are (in CSV format):
"24","58"
"13","23"
"13","11"
"12","58"
"11","8"
"10","16"
"9","6"
"8","16"
"7","4"
"6","15"
"5","17"
"4","2"
"3","11"
"1","10"
"5","18"

Any ideas?
Thanks.

[ClarkF1]

Try

while ($CEArray = mysql_fetch_assoc($CErslt))
{
echo $CEArray['PosID'].",".$CEArray['PeopleID']."<br>";
}

[Earnan]

Well, that worked, I see the whole array now, but I still don't understand why print_r didn't work.

[leatherback]

Read the manual, and try to unerstand what the command actually does.

On top of my head, I think Fetch Ass will only retrieve one row from the database, and move the pointer to the next row. Remember thata resultset from a query is not a set of data, but a list of pointers to records in the database. When you want the data, yo uhave to get the records that match the pointers, which is mysql_fetch_array or mysql_fetch_assoc do.

J.