PHP+MYSQL Dynamic Array Iteration (Simple Question)

[victorcordova]

I have data inside a mysql database, say, a list of names.

I want to pull this data out and put it into an php array.

I am not sure what I am doing wrong but it is not working.

$db = mysql_connect("host", "sn", "pw");
mysql_select_db("table",$db);

$sql = "SELECT * FROM Name";
$result = mysql_query($sql,$db);

$nameX=array("BOB");


while ($myrow = mysql_fetch_array($result)) {
	$name= array_push($nameX,$myrow["Name"]);

}

This should be working but is not. Any suggestions?

[LordShryku]

First thing you should do is look in the Echo Lounge here. There's a sticky thread called "debugging 101".

I'll help you try to debug this one...

error_reporting(E_ALL); #set error reporting to full tilt

# alter connect statement with or die() to make sure we're connecting
$db = mysql_connect("host", "sn", "pw") or die('Cannot connect: '.mysql_error());

# make DB selection an if to make sure it works
if(mysql_select_db("table", $db)) {
   # change SQL to select only the one field we need, not *
   $sql = "SELECT FieldName FROM Name";
   $result = mysql_query($sql, $db);

   $nameX=array("BOB");

   # make sure there's rows
   if(mysql_num_rows($result) > 0) {
      while ($myrow = mysql_fetch_array($result)) {
         # don't need array push
         $nameX[] = $myrow['FieldName'];
      }

  # print array results
  print_r($nameX);
   }
   else
      die('No results returned');
}
else
   die('Could not select database');

Give that a shot...

[nephicheng]

mysql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both

I don't see why you would need to put them in another array, but if you must, you can do this.

$db = mysql_connect("host", "sn", "pw");
mysql_select_db("table",$db);

$sql = "SELECT * FROM Name";
$result = mysql_query($sql,$db);

$nameX=array("BOB");


while ($myrow = mysql_fetch_array($result)) {
     // appends the current row to the array nameX
     $nameX[] = $myrow;

}

[Weedpacket]

Originally posted by nephicheng
I don't see why you would need to put them in another array, but if you must, you can do this.

Compare the contents of the two arrays and you will.