NEED a PHP/MySQL GURU

[mastero4]

I need some serious help. I have been posting in multiple forums with no real help. I need to access a single row of a database table in MySQL quering from PHP. This single field will be from the string in the URL such as www.whatever.com/verify.php?id=1 will display the information from row 1 only and www.whatever.com/verify.php?id=2 will display the information from row 2 only.

I have tried everything I can think of and tried to work with what others have told me, and I am still getting parsing errors. Now my errors occur in the while line.

Here is my code that I have been working with:

<?php
$user = "mastero4_verify";
$pass = "*******";
$db = "mastero4_verify";
$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link )
die( "Couldn't connect to MySQL" );
mysql_select_db( $db, $link )
or die( "Couldn't open $db: ".mysql_error() );
$result = mysql_query( "SELECT url FROM table WHERE id = $id" );
print "<table border=0>\n";
while ( $a_row = mysql_fetch_row( $result ) ) {
print "<tr><td>Matrix ID&nbsp;&nbsp;</td><td>".$a_row['id']."</td></tr>\n";
print "<tr><td>Matrix Name&nbsp;&nbsp;</td><td>".$a_row['name']."</td></tr>\n";
print "<tr><td>Main URL&nbsp;&nbsp;</td><td>".$a_row['url']."</td></tr>\n";
print "<tr><td>Date Joined&nbsp;&nbsp;</td><td>".$a_row['date']."</td></tr>\n";
print "<tr><td>Unresolved Investigations&nbsp;&nbsp; </td><td>".$a_row['unresolved']."</td></tr>\n";
print "<tr><td>Resolved Investigations&nbsp;&nbsp; </td><td>".$a_row['resolved']."</td></tr>\n";
print "<tr><td>Date of Last Investigation&nbsp;&nbsp; </td><td>".$a_row['datelast']."</td></tr>\n";
}
print "</table>\n";
mysql_close( $link );
?>

Thanks in advance.

[Anon]

use mysql_fetch_assoc($result) instead of mysql_fetch_row($result).

[mastero4]

I am still getting the same error. It says for exact words:

Warning: Supplied argument is not a valid MySQL result resource in /home/mastero4/public_html/verify2.php on line 129

where line 129 is:

while ( $a_row = mysql_fetch_assoc( $result ) ) {

[mastero4]

Problem fixed... thank you all!!!

During the talking with others, I changed the table name in the query. I feel like a fool, it is those little things.