By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,071 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Missing element in array?!

P: n/a
I have the following query I run to pull some data from the db. The
sql (when run on the db) returns 2 elements. However, if I var dump my
variable ($aidlook) then the first element in the array does not show
up.

$getaid = mysql_query("SELECT a_uid FROM `answers` WHERE `qid` =
$qid", $db);
$aidlook = mysql_fetch_array($getaid,MYSQL_NUM);

Doing a var dump returns: array(1) { [0]= string(1) "4" }

I should be getting 2 elements (4 and 5).

I am totally baffled. code as follows:

*********************
if (!is_array($aidlook)) $aidlook = array($aidlook); // Check for the
existence of the array in case of null returns

if (!in_array($userid,$aidlook)) // Look for our element which in
this case is "5"
{
if ($qstatus === 1) // Do a status check
{
}

answer_box($qid,$answ); // additional function being run

} else
{
echo "Your Text Here";

}
}
../JLK

May 20 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
>I have the following query I run to pull some data from the db. The
>sql (when run on the db) returns 2 elements. However, if I var dump my
variable ($aidlook) then the first element in the array does not show
up.

$getaid = mysql_query("SELECT a_uid FROM `answers` WHERE `qid` =
$qid", $db);
$aidlook = mysql_fetch_array($getaid,MYSQL_NUM);

Doing a var dump returns: array(1) { [0]= string(1) "4" }

I should be getting 2 elements (4 and 5).
mysql_fetch_array returns the results from ONE ROW. Since you are
only selecting one column in your query, you should have only one
element in the array. If you want the results from more than one
row, loop calling mysql_fetch_array. Note that if you try doing
this and then merging the arrays, you're going to merge a whole
lot of arrays with a "0" index and likely you will end up with an
array with a single "0" index.

>I am totally baffled. code as follows:

*********************
if (!is_array($aidlook)) $aidlook = array($aidlook); // Check for the
existence of the array in case of null returns

if (!in_array($userid,$aidlook)) // Look for our element which in
this case is "5"
{
if ($qstatus === 1) // Do a status check
{
}

answer_box($qid,$answ); // additional function being run

} else
{
echo "Your Text Here";

}
}
./JLK

May 20 '07 #2

P: n/a
mysql_fetch_array returns the results from ONE ROW. Since you are
only selecting one column in your query, you should have only one
element in the array. If you want the results from more than one
row, loop calling mysql_fetch_array. Note that if you try doing
this and then merging the arrays, you're going to merge a whole
lot of arrays with a "0" index and likely you will end up with an
array with a single "0" index.
That I did not know..... Thank you.

../JLK

May 20 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.