trouble accessing mysql

[doozerdc]

I have created a form which successfully writes to a database but I'm getting this error message when I try to print out the database:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /../../../guest_list.php on line 43
Sorry, no records were found!

Line 43 of the code reads:

if ($row = mysql_fetch_array($result)) {

The php code of the page is this:

<?php 

mysql_connect (localhost, username, password);

mysql_select_db (db_name);

$result = mysql_query ("SELECT 'LastName', 'FirstName', '_Guest', 'Accommodation', FROM 'guest'");


if ($row = mysql_fetch_array($result)) {

do {
  print ("<tr>");
  print ("<td>");
  print $row["LastName"];
  print ("</td>");
  print ("<td>");
  print $row["FirstName"];
  print ("</td>");
  print ("<td>");
  print $row["_Guest"];
  print ("</td>");
  print ("<td>");
  print $row["Accommodation"];
  print ("</td>");
  print ("</tr>");
} while($row = mysql_fetch_array($result));} 

else {print "Sorry, no records were found!";}


?>

I can't figure out what I need to change in order for it to write the table of results

[csn]

My guess is that your connection or db selection is failing. You really should error check those.

[doozerdc]

I have tested the connection and get no errors.

[csn]

You don't need quotes around the field and table names.

If it still doesn't work, try mysql_error().

[csn]

The last comma right before FROM would cause an error.

[doozerdc]

Thanks so much for the help. It was indeed that comma before the "FROM" which was causing the error.

Another question: how do I add CSS styles to the td's in the table?

*I apologize for these basic quesitons but I'm new to PHP.