[Resolved] SELECT statement problem

[Bailz]

I am getting the error:
Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect., SQL state 37000 in SQLExecDirect in C:\Program Files\Abyss Web Server\htdocs\iframe\order.php on line 19

My SELECT statement is:
$query = "SELECT FROM Item WHERE (Model Like '{$_GET['Model']}')";

I'm not entirely sure where the problem is but I would guess that it's to do with the '{$_GET['Model']}'

Cheers,
Bailz.

[weekender]

try

$query = "SELECT * FROM Item WHERE (Model Like '{$_GET['Model']}')";

think you need to specify field names or *

adam

[Bailz]

Thanks a lot. I always miss silly things like that!

Cheers,
Bailz.

[weekender]

easily done - dont forget to mark the thread resolved