PHP MySQL Problem

Manat

PHP Warning, supplied argument is not a valied mysql result resource.

What does the above mean, it was in my server logs?

The below code is not working and causing the above error:
Please can you help me out with my snippet.

<?php
$contest="roundTable";
$result = mysql_query("SELECT * FROM contests WHERE ContestName = $contest",$db);

printf("Contestant ID: %s \n", mysql_result($result,0,"Contestant_ID"));
printf("Age: %s \n", mysql_result($result,0,"Age"));
printf("First Name: %s \n", mysql_result($result,0,"Fname"));

Does anyone know why my code doesn't work?

Can anyone show me how I could do this:

Contestand ID First Name Last Name
$contestant_ID $fname $lname
$contestant_ID $fname $lname
$contestant_ID $fname $lname
$contestant_ID $fname $lname
$contestant_ID $fname $lname

So it would list all the entries that conforms to the SQL criteria.

Any help would be much appreciated!

[deleted]

<?php
$contest="roundTable";
$result = mysql_query("SELECT * FROM contests WHERE ContestName = '$contest'",$db);

while ($row = mysql_fetch_array($result))

{

printf("Contestant ID: %s \n", $row[Contestant_ID]);
printf("Age: %s \n", $row[Age]);
printf("First Name: %s \n", $row[Fname]);

Manual ref: http://www.php.net/manual/en/function.printf.php

Traduim

This error means your query has bad syntax. Prompt a mysql_error() to fix the bug.