jiri

Hi everyone,

I run w/o problem:

$query = 'SELECT * FROM customers_table WHERE customer_id=\''.$customer_id.'\' ';

I need to replace the tablename called "customers_table" above with a variable, e.g.

$table = 'customers_table';
$query = 'SELECT * FROM $table WHERE customer_id=\''.$customer_id.'\' ';

It report's error.

I have tried also this way:

define("CUSTOMERS_TABLE", "customers_table");

$query = 'SELECT * FROM CUSTOMERS_TABLE WHERE customer_id=\''.$customer_id.'\' ';

It report's error, but if I write CUSTOMERS_TABLE in lowercase, all is OK.

The purpose is to have more entries into program and onetime I use
define("CUSTOMERS_TABLE", "customers_table");

nextime will be

define("CUSTOMERS_TABLE", "peters_table");

and next time

define("CUSTOMERS_TABLE", "alices_table");

and so far...

Can you help how to write $query = ... correctly?

Intripita-MH

Try that.

__________________
Intripita :: web hosting | development | conferencing

Business-Grade Web Hosting, Professional Conferencing, Effective Web Development by Intripita