Mysql database retrieve multiple rows

Question

I use a mysql database. When I run my query I want to be able to put each row that is returned into a new variable. I dont know how to do this.

my current code:

<?php
$result=mysql_query("SELECT * FROM table WHERE var='$var'");

$check_num_rows=mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result))
{

$solution=$row['solution'];
}
?>

The thing is that check num rows can return a row of an integer 0-infinity. If there are more solutions in the database how can I assign them all a variable. The above code works fine for 1 solution, but what if there are more? Thanks.

So you want an multidimensional array of each row? Why not just add each row to the array each loop? — Jess
– Jess, Commented Jun 28, 2011 at 2:46

zlkn · Accepted Answer · 2011-06-28 02:53:58Z

3

You can't give each variable a different name, but you can put them all in an array ... if you don't know how this works I suggest looking at a basic tutorial such as http://www.w3schools.com/php/php_arrays.asp as well as my code.

A very simple way (obviously I haven't included mysql_num_rows etc):

$solutions = array()

while($row = mysql_fetch_assoc($result)) {
  $solutions[] = $row['solution'];
}

If you have three in your result solutions will be:

$solutions[0] -> first result $solutions[1] -> second $solutions[2] -> third

answered Jun 28, 2011 at 2:53

zlkn

541 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

Nathan Romano · Accepted Answer · 2011-06-28 02:46:10Z

0

 <?php
      $result=mysql_query("SELECT * FROM table WHERE var='$var'");
      $solution = array();

      $check_num_rows=mysql_num_rows($result);

      while ($row = mysql_fetch_assoc($result))
      {
           $solution[]=$row['solution'];
      }
 ?>

answered Jun 28, 2011 at 2:46

Nathan Romano

7,1263 gold badges23 silver badges18 bronze badges

1 Comment

user780483 Over a year ago

how will i know which solution is which variable

Collectives™ on Stack Overflow

Mysql database retrieve multiple rows

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related