Display SQL Query results

[slj90]

I have a SQL code that works when I run it through phpmyadmin but I can't get PHP to display the results on a page.

 

Here is my attempt:

 

<?php


require 'connect.php';

$query = "SELECT * FROM table003 WHERE status='pending' ORDER BY id ASC LIMIT 1";
$result = mysql_query($query);

$row = mysql_fetch_row($result);

echo $row[1]; 
echo $row[2];

?>

 

It displays nothing.

 

Thanks

 

 

---

 

Update:

I got it working now and edited the code in this forum.