expected ALL but reads only first

[egami]

I've never been much for object programming..


but try this..

Code: Select all

<?php 
<?php 

$connect = mysql_connect('host','user','pass');
$db = mysql_select_db('MyDatabase');

$table = "change_me";

$query = "SELECT * FROM $table";
$result = mysql_query($query);

if (mysql_num_rows($result) > 0) 
{
  while ($row = mysql_fetch_assoc($result))
  {
    echo '<pre>'; print_r($row); echo '</pre>';
  }
} else { 
  echo mysql_error();
}
  

[MeroD]

if($result = $mysqli->query($query)){
while($row = $mysqli->fetch_object($result)){
echo $row->column;
}
}