Posted by Frankie on 10/22/00 11:52

Hello:

New user here...first post to group.

I'm getting an SQL syntax error when I try to run the following query:

$query = sprintf("SELECT itemNumber, entryDate, modifyDate, thumbnailURL,
title, price FROM '%s' WHERE itemNumber = '%s'", $_POST['selectCategory'],
$_POST['tfItemNum']);

I've tested the variables and they are populated.

Strangely, the query works with a variable in the WHERE clause, but not in
the FROM clause.

Any tips appreciated,

Frank H
Austin, TX

• Next in forum: Re: HELP: pesky SQL syntax error using PHP variables
• Prev in forum: Re: Encoding problem
• Thread view: HELP: pesky SQL syntax error using PHP variables

[Reply to this message]