Where is my array?
| From: | Don Wieland | Date: | Wed, 15 Dec 2010 22:21:13 +0000 |
| Subject: | Where is my array? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-310066@lists.php.net to get a copy of this message | ||
Hello,
I originally had a line that built a static array:
$instruments = array('Leader','Singer','Piano','Synth','A-Guitar','E-Guitar','Bass','Drums','Perc','Sax','Flute','Sound/AV','Pastor','Producer');
Then I decided I wanted this dynamic and to pull it form the DB. So I thought this would bring back similar results:
$queryi = "SELECT Instrument FROM Instruments WHERE
acct_id = '".$_SESSION['ACCT']."' ORDER BY id_Sort";
echo $queryi;
$resultsi = mysql_query($queryi) or die("Error performing query");
$instruments = mysql_fetch_array ($resultsi);
Does not. What am i missing here? Thanks!
Don