current community

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite 
$query2 = "SELECT * FROM `Listing` WHERE listingid = '{$myID}'";
if(!($result2 = @ mysql_query($query2,$connection)))
    echo "query failed<br>";

$result_array = array();
while($row2 = mysql_fetch_assoc($result2))
{
    $result_array[] = $row2;
}
foreach ($result_array  as $key => $val) {
    echo "$key = $val\n";
}

Listing (Table) has 7 fields.
I get a bunch of "0 = Array"

How do I store mysql query results into php array and display them? I want to have it as array first so i can sort them.

share|improve this question
 
what is wrong with mysql_fetch_array (better use mysqli_fetch_array)? –  John Nov 25 '12 at 0:20
 
@John You can start reading here. –  ChocoDeveloper Nov 25 '12 at 0:22
 
this is how i was taught and has been using –  ealeon Nov 25 '12 at 0:22
 
@ealeon Well it's bad. I also learned it like you, about 6 years ago. Time to evolve. –  ChocoDeveloper Nov 25 '12 at 0:23
 
what part of code is old?? –  ealeon Nov 25 '12 at 0:23
show 1 more comment

1 Answer

up vote 0 down vote accepted

You are actually storing them. The code you have listed is storing them in array of arrays to see them you can modify the for with:

foreach ($result_array  as $key => $val) {
    echo "$key = " .  print_r($val, true) . "\n";
}

$val is actually an array containing all the fields of a row.

share|improve this answer
 
ah okay. now it works. thank you –  ealeon Nov 25 '12 at 0:22
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.