Basic Question about working with Query Results

l008com

It seems that while PHP is very easy, working with MySQL can be much trickier. I have a small table, only one field, just a couple of rows. I really want to easily read this list (SELECT * FROM database) and store each row as a variable in an array in PHP, so I can sort through the list quickly over and over. For the life of me, I can't get this done. It's very annoying!! Reading results of SELECTs are killing me!

snoopy13

you just have to read out your query:

$query=mysql_query("SELECT * FROM x");

$array=mysql_fetch_array($query);

now you have all the data from the table x in the array "$array". To get them out you can then say:

echo $array[0];

for the first value, $array[1] for the second and so on..

ok?

l008com

For some reason its not giving me all the items? The first thing that got me was that you don't put an array in quotes like you do a regular variable??? But then I came up with this code but it only returns the first item from the table, which has exactly 5 items in it.

$Query = mysql_query("SELECT * FROM blacklist");

$Array = mysql_fetch_array( $Query );


for ($i = 0; $i < 5; $i++ )
	{
	echo "$i: ";
	echo $Array[$i],"\n";
	}

This simply returns:

0: microsoft.com
1:
2:
3:
4:

l008com

Apparently the suggested code stores each of the fields in a single row into an array. Is there an easier way to store the same field from multiple rows into an array?

l008com

This gets the job done, I just wish there was an easier way.

$result = mysql_query("SELECT * FROM blacklist");

$numrows = mysql_num_rows($result);

for ($i = 0; $i < $numrows; $i++)
	{
	$TempArray = mysql_fetch_row( $result );
	$Array[$i] = $TempArray[0];
	}



for ($i = 0; $i < 5; $i++ )
	{
	echo "$i: ";
	echo $Array[$i];
	echo "\n";
	}

ahundiak

$rows = array(); // Just for when no rows are returned
while($row = mysql_fetch_assoc($result)) {
  $rows[] = $row;
}
print_r($rows);

Lot's of good stuff on arrays in the manual.