In message <[EMAIL PROTECTED]>, gentlemike2 <[EMAIL PROTECTED]
rpgplayers.com> writes
>$getresps = mysql_query("SELECT * from ('".$tableid[$i]."') where uid
>= ('".$pid."')") or die (mysql_error());
>
>I get a syntax error near ''pollq1') where uid = ('1')' at line 1
>
>I have used this syntax before with a standard variable (not array),
>or I have used -- (".$table.") -- before and had it work.
>
>What am I missing? What am I doing wrong?
The $getresps line won't work for me, because of the single quotes
around the tablename.
$getresps = mysql_query("SELECT * from (".$tableid[$i].") where uid
>= ('".$pid."')") or die (mysql_error());
works for me, although I wouldn't use the brackets - never seen it
written like that before!
--
Pete Clark
Sunny Andalucia
http://www.hotcosta.com/comm_1.htm