# mysql\_fetch\_array - Where's my data?

**URL:** <https://forum.kirupa.com/t/mysql-fetch-array-wheres-my-data/261242>\
**Category:** programming\
**Created:** [May 24, 2008, 7:17pm UTC](https://forum.kirupa.com/t/mysql-fetch-array-wheres-my-data/261242 "2008-05-24T19:17:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nburlington](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/nburlington/32/1365_2.png) [@nburlington](https://forum.kirupa.com/u/nburlington)\
**Post date:** [May 24, 2008, 7:17pm UTC](https://forum.kirupa.com/t/mysql-fetch-array-wheres-my-data/261242/1 "2008-05-24T19:17:02Z")

</div>

When I sendAndLoad this in Flash, the php isn’t returning my values. The code below returns Q7 for the $line value. I’ve tried $line[1], $line[0][1], $line[‘Q7’] and I can’t get my data. I’ve check the data in my phpmyadmin and the values are there. What am I doing wrong?

```auto

$query = "SELECT 'Q7' FROM Votes";

$results = @mysql_query($query);

echo "<?xml version=\"1.0\"?>
";

while($line = mysql_fetch_array($results,MYSQL_BOTH)){
echo "<results line='".$line[0]."' />
";
}

```

---

<div class="post-metadata">

**Author:** ![sstalder](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@sstalder](https://forum.kirupa.com/u/sstalder)\
**Post date:** [May 24, 2008, 11:49pm UTC](https://forum.kirupa.com/t/mysql-fetch-array-wheres-my-data/261242/2 "2008-05-24T23:49:17Z")

</div>

$query = “SELECT Q7 FROM Votes”;

$results = mysql\_query($query) or die(mysql\_error());

echo “\<?xml version=“1.0”?\>  
”;

while($line = mysql\_fetch\_array($results)){  
echo “\<results line=’”.$line[0]."’ /\>  
";  
}

Let me know if that produces any errors.

---

<div class="post-metadata">

**Author:** ![nburlington](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/nburlington/32/1365_2.png) [@nburlington](https://forum.kirupa.com/u/nburlington)\
**Post date:** [May 25, 2008, 1:57pm UTC](https://forum.kirupa.com/t/mysql-fetch-array-wheres-my-data/261242/3 "2008-05-25T13:57:41Z")

</div>

I’m not getting errors. I’m still getting the ‘Q7’ value returned instead of the data in the row.

---

<div class="post-metadata">

**Author:** ![kdd](https://avatars.discourse-cdn.com/v4/letter/k/ecb155/32.png) [@kdd](https://forum.kirupa.com/u/kdd)\
**Post date:** [May 25, 2008, 10:31pm UTC](https://forum.kirupa.com/t/mysql-fetch-array-wheres-my-data/261242/4 "2008-05-25T22:31:10Z")

</div>

Do you have a column named Q7? If you do something like “SELECT 0 FROM tblName” then if you have 100 rows returned, you’ll get 0 in all rows returned.

sstalder is correct, as he removed quotes from Q7 (if you have a column named Q7). Otherwise, you’ll get errors.