Is this possible?

[pthes]

I'd like to use a variable that contains the name of the table I want to update. Then I could insert the variable into the query statements rather than typing the table name directly.

For example,

$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn't select database");

$intable = "pagesread";

/ this is the duplicate check section /
$sql = "SELECT * FROM '$intable' WHERE datein = '$datein' ";

I've tried this but I the last line gives a parse error each time.

[sarahk]

That looks fine.

I would check that $datein is ok though

then I'd try to echo out $sql and see what you actually get.

good luck

[pthes]

Thanks for the info. Got it to work.