Re: Does MySQL support tables with numbers in them?

Check the MySQL docs to make certain, but this might solve the problem if $a = "55555" is a string rather than a number. Also, is the syntax correct for the CREATE TABLE statement? Do you need to indicate the size of the int's, deciaml places for money? (I'm not looking it up, and I'm no authority on create table statements, they're usually done once, then not tampered with for ages. <g>) HTH - Miles Thompson Dave wrote: > Can I create a table that has a number as part of its name: > > $a = 555555; > > $sql="CREATE TABLE " . $a . "_person_num (person_num int primary key, > quantity int, cost MONEY)"; > > The above sql returns an error. Is there a way around this? > > Thanks, > Dave > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net