$realones = $row['id'];

This line needs to be

$realones[] = $row['id'];

...then you will be filling an array instead of just overwriting the same variable repeatedly!


----- Original Message ----- From: "Dave W" <[EMAIL PROTECTED]>
To: "PHP DB" <php-db@lists.php.net>
Sent: Friday, September 22, 2006 10:35 PM
Subject: [PHP-DB] Turning result into array from columns

So I'm trying to pull id's and put them into an array. I know I need to
iterate through them, but it doesn't seem to turn into an array. Here's the
function that I'm trying:

function checkID($id) {
$q = sprintf("SELECT id FROM content");
$result = $this->query($q);

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$realones = $row['id'];

if(in_array($id,array($realones))) { return true; } else { return false; }

It's only grabbing the first row id and putting it into the array. It won't
put any of the other ones in. If I just echo $row['id'], it will show both
of them, just not put both of them into an array.

Dave W

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to