|
|
Posted by Gordon Burditt on 05/20/07 23:16
>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
>
Navigation:
[Reply to this message]
|