adding SQL data to an PHP array

[edd12345678]

Hi everyone,

 

Hope someone can help. 

 

Does anyone know why this is nor displaying any data?

 

  $qry = mysql_query("select * from product");
$data = array();
while($row = mysql_fetch_array($qry)){

$productName[] =$row['productName'];     
// Item name
}

for($i=0;$i<mysql_num_rows($row);$i++)
{ 

 $data = $productName[$i];

} 
return $data;

 

Thanks in advance

 

Edd

[litebearer]

Nowhere in that code are you telling it to display the info

 

try...

$qry = mysql_query("select * from product");
while($row = mysql_fetch_array($qry)){
  echo $row['productName'] . "<br />;     
}

[cpd]

If your trying to put the data retrieved from the database into an array do the following.

 

$qry = mysql_query("select * from product");
$data = array();
while($row = mysql_fetch_array($qry)){
    $data[] = $row;
}

var_dump($data);

 

[edd12345678]

Thanks CPD thats what I was looking for.