Creating an array from a MySQL table

Question

I'm trying to create an array to use for a curl_multi_exec, but I can't seem to create the array properly.

Here is my code:

$SQL = mysql_query("SELECT url FROM urls") 
       or die(mysql_error()); //Query the shell table
while($resultSet = mysql_fetch_array($SQL)) {
  $urls[] = $resultSet;
}    
echo $urls; //Test that the array works

But when I run this script, all it does is echo "Array"

I have no idea what I'm doing wrong, I've checked around google a bit, but can't figure it out. Any insight would be appreciated.

dnagirl caught it, Col. Shrapnel. I expected it to print out the rows from the MySQL. — Rob
– Rob, Commented Apr 26, 2010 at 17:14
i know you wanted rows. what format it should be? And how PHP would know this format? — Your Common Sense
– Your Common Sense, Commented Apr 26, 2010 at 17:15
Well mostly, at the moment I just wanted it to print the full array so I can make sure the array is set correctly, but if you're looking for my ultimate goal, you can find it here: stackoverflow.com/questions/2713876/… — Rob
– Rob, Commented Apr 26, 2010 at 17:17
i have just merely asked you of what text you wanted to be printed. an example. of text. but you fail to realize the simple fact that it is text being printed when we see anything in the browser. — Your Common Sense
– Your Common Sense, Commented Apr 26, 2010 at 17:25
I simply wanted it to print (in text) the contents of the requested rows, to verify that the array worked. — Rob
– Rob, Commented Apr 26, 2010 at 17:26

dnagirl · Accepted Answer · 2010-04-26 17:11:18Z

3

print_r($urls) or var_dump($urls)

echo assumes a scalar value.

answered Apr 26, 2010 at 17:11

dnagirl

20.5k13 gold badges86 silver badges127 bronze badges

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

2 Comments

Rob Over a year ago

Aha, that was easy. Much appreciated, I'll keep this in mind for future reference. Also, could link me to something that explains this more in detail? Or explain it yourself? (Also, can't accept answer for another 11 minutes. Bah)

dnagirl Over a year ago

@Rob: best place for PHP info is the manual (no sarcasm, honest!) ca.php.net/manual/en/index.php Have a look here for echo ca.php.net/manual/en/function.echo.php, print_r ca.php.net/manual/en/function.print-r.php and var_dump ca.php.net/manual/en/function.var-dump.php

Sarfraz · Accepted Answer · 2010-04-26 17:14:23Z

0

You can use the print_r() function.

print_r($urls)

answered Apr 26, 2010 at 17:14

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

Collectives™ on Stack Overflow

Creating an array from a MySQL table

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related