CODEWITHSUNDEEP
phpmysqlarraysselect
Austin908
Austin908

Reputation:

How to store row/column of mysql data in array

I want to be able to store (not echo) some data that has been selected from a mysql database in a php array. So far, I have only been able to echo the information, I just want to be able to store it in an array for later use. Here is my code:

$query = "SELECT interests FROM signup WHERE username = '$username'";
$result = mysql_query($query) or die ("no query");
while($row = mysql_fetch_array($result))
{
echo $row['interests'];
echo "<br />";
}

Upvotes: 7

Views: 63303

Answers (2)

Matt Lowden
Matt Lowden

Reputation: 2616

You could use

$query = "SELECT interests FROM signup WHERE username = '".mysql_real_escape_string($username)."'";
$result = mysql_query($query) or die ("no query");

$result_array = array();
while($row = mysql_fetch_assoc($result))
{
    $result_array[] = $row;
}

This will basically store all of the data to the $result_array array.

I've used mysql_fetch_assoc rather than mysql_fetch_array so that the values are mapped to their keys.

I've also included mysql_real_escape_string for protection.

Upvotes: 20

coreyward
coreyward

Reputation: 80041

You can "store" it by not accessing it from the result set until you need it, but if you really want to just take it and put it in a variable…

$query = "SELECT interests FROM signup WHERE username = '$username'";
$result = mysql_query($query) or die ("no query");

$interests = array();
while(false !== ($row = mysql_fetch_assoc($result))) {
  $interests[] = $row;
}

Upvotes: 2

Related Questions