[PHP-DB] letting a table name be a constant

2004-08-23 Thread Ben Galin
Hello, Regarding this code: [PHP code] // This works $name=name; $table=mytable; $mysql_connect(localhost,,) or die(Error: .mysql_error()); $mysql_select_db(mydb) or die(Error: .mysql_error()); $mysql_query(INSERT INTO $table (`id`,`name`) VALUES ('','$name')); [/PHP code] I want to

Re: [PHP-DB] letting a table name be a constant

2004-08-23 Thread Justin Patrin
On Mon, 23 Aug 2004 17:06:40 -0700, Ben Galin [EMAIL PROTECTED] wrote: Hello, Regarding this code: [PHP code] // This works $name=name; $table=mytable; $mysql_connect(localhost,,) or die(Error: .mysql_error()); $mysql_select_db(mydb) or die(Error: .mysql_error());

Re: [PHP-DB] letting a table name be a constant

2004-08-23 Thread John Holmes
Ben Galin wrote: I want to define() TABLE as a constant instead of using the variable $table [PHP code] // This runs without an error but does *not* insert a new row $name=name; define(TABLE, mytable); $mysql_connect(localhost,,) or die(Error: .mysql_error()); $mysql_select_db(mydb) or

Re: [PHP-DB] letting a table name be a constant

2004-08-23 Thread Ben Galin
On Aug 23, 2004, at 8:12 PM, John Holmes wrote: You can't have a constant in a string. You'd do it like this: mysql_query(INSERT INTO . TABLE . (`id`,`name`) VALUES ('','$name')); Thanks, John and Justin. Wasn't thinking about that. The other error you have, and I don't know how you think this

Re: [PHP-DB] letting a table name be a constant

2004-08-23 Thread Jason Wong
On Tuesday 24 August 2004 08:18, Ben Galin wrote: You're right. It doesn't run. I retyped instead of copy-and-paste'd; that's a typo. Please, when you post code make sure they're verbatim by using copy paste. That way people can focus on your actual problem rather than on your typos. --