Re: Converting from Postgres to MySQL - PHP question

[Barry Galbraith]

pg_result is now called pg_fetch_result().
mysqli_fetch_array() fetchs a whole row into an array object.
You then access each field either by index or by name

$con = mysqli_connect('host','user','password',database') or die("Failed to connect");
$sql = "SELECT field1, field2 from mytable";

$result = mysqli_query($con, $sql) or die(mysqli_error($con));
while $row = mysqli_fetch_array($result){

  $field1 = $row['field1'];
  $field2 = $row['field2'];
}

Good luck,
Barry.