Re: Am I missing something simple???

Found it, this line: $picresult = mysql_fetch_array($picsql); is always setting it to array 0, same as $picresult[0] but you are doing this next; echo $picresult[$i] . " - Result<br>"; you could do one of the following: $picresult[$i] = mysql_fetch_array($picsql); echo $picresult[$i] . " - Result<br>"; or $picresult = mysql_fetch_array($picsql); echo $picresult . " - Result<br>"; and it should work for you. Jay ----- Original Message ----- From: "CDitty" <mail@redhotsweeps.com> To: <php-general@lists.php.net> Sent: Tuesday, November 28, 2000 12:54 PM Subject: [PHP] Am I missing something simple??? > Hello all. > > I seem to be having a little problem with a loop statement. No matter what > I try, it only returns data on the first loop. The rest is ignored. > > for($i=0; $i < 6; $i++ ) > { > $picsql = mysql_query("select picture from scratch_odds where gameid = > '$gameid' and id = $myotherpics[$i]"); > echo "select picture from scratch_odds where gameid = '$gameid' and id = > $myotherpics[$i]<br>"; > $picresult = mysql_fetch_array($picsql); > echo $picresult[$i] . " - Result<br>"; > echo $i . " - Counter<br>"; > } > > This is a copy of what is echoed out. As you can see below, all the > variables are set. > > select picture from scratch_odds where gameid = '1' and id = 6 > http://www.redhotsweeps.com/scratchnwin/games/15/331_11_2.gif - > Result > 0 - Counter > select picture from scratch_odds where gameid = '1' and id = 1 > - Result > 1 - Counter > select picture from scratch_odds where gameid = '1' and id = 5 > - Result > 2 - Counter > select picture from scratch_odds where gameid = '1' and id = 2 > - Result > 3 - Counter > select picture from scratch_odds where gameid = '1' and id = 3 > - Result > 4 - Counter > select picture from scratch_odds where gameid = '1' and id = 4 > - Result > 5 - Counter > > Any ideas on what is wrong? > > Thanks > > Chris > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >