mySQL: Compare Key value to php variable

[Anon]

I have a piece of code that I'm trying to get to work. I am attempting to compare my Key field (ArticleKey) to a variable generated by my php script ($editItem). (The ArticleKey field is the auto_increment field which assigns a unique number to each row).

I know the below code doesn't work, but is there any way to pull just the one row of information by comparing it to the Key?
WHERE ArticleKey = $editItem

$resultID = mysql_query("SELECT ArticleKey, AuthorFirstName, AuthorLastName, ArticleTitle, ArticleBody, Subject, Origin FROM articles, WHERE ArticleKey = $editItem", $linkID);

I get a Parse error with this code.

Thanks,

Mark

[Anon]

Mark wrote:
I like to make the code a little cleaner by separating the stuff out:

$sql="SELECT ArticleKey, AuthorFirstName, AuthorLastName, ArticleTitle, ArticleBody, Subject, Origin FROM articles WHERE ArticleKey =".$editItem;

$resultID = mysql_query($sql, $linkID);

The parse error is probably a result of the comma you had after the word 'articles'. I also simply concatenated the $edititem on the end of the text the query to eliminate any other possible problems.

hope it works!

[Anon]

Craig,

Wow. Thanks for the quick and informative response. You definately did more than I asked.

Mark