mysql query problems...

Anon

I have a mysql table with some IDs to results from another table. I can successfully display them using this code:

$info_query = mysql_query("SELECT FROM table1 WHERE (row1 = '$var')");
while ($info = mysql_fetch_array($info_query)) {
$ID = $info['content2'];
$list_query = mysql_query("SELECT FROM table2 WHERE ID = '$ID'");
$list = mysql_fetch_array($list_query);
echo $list['content'];
}

Yet when I try to do a LIMIT on the results, it says it is not valid.

I tried this to limit the results to 15:

$info_query = mysql_query("SELECT FROM table1 WHERE (row1 = '$var') LIMIT 0, 15");
while ($info = mysql_fetch_array($info_query)) {
$ID = $info['content2'];
$list_query = mysql_query("SELECT FROM table2 WHERE ID = '$ID'");
$list = mysql_fetch_array($list_query);
echo $list['content'];
}

This gives an error. Can somebody help???

glowball

I can't run that query with the parentheses around the WHERE clause, will it work if you remove them?

rulian

well, i dont know about the error in your code, but I never use () on my where and it never gives me a problem, it could be that but I'm just a newbie

rulian

Oops, when I opened this nobody had said it yup, ohh well, guess 2 cant be wront

jcornett

What version of MySQL are you using?

The only time you need to use parentheses around your sql statements is if you are doing checking on the results as in:

SELECT * from table where ((foo='1' OR foo='2') AND (foo2='9' OR foo2='10'))

So this would return any result where foo equals 1 or 2, AND any result where foo2 equals 9 or 10. The parentheses are best avoided if not necessary as they slow down your queries.

John