Weird Insert

I have a table named users

and incase this table is ever renamed, i use the define() function:

define("USERS_TABLE", "users");

Now here is my sql query:

mysql_query("INSERT INTO " . USERS_TABLE . " (username, date) VALUES ('$username', '$date')");

This does not work. If i change " . USERS_TABLE . "

to:

users

it works fine. Weird thing is i do this with other queries for different tables and it works fine. ANy ideas?

I have never used the define() function before so I don't know if that is your problem or not.

Here is another way of doing the same thing.

Make an include file where you can store all of your site or global variables.

Include File
<?php
/ library.inc /
$USER_TABLE="users";
?>

Main Program File
<?php

require("library.inc");

mysql_query("INSERT INTO $USER_TABLE username, date) VALUES '$username', '$date')");

I do this for common HTML functions, database info, etc for all of my php pages. It is a great way to allow for user customizations as well.

Good Luck.

The define function is used because it creates a constant which can only be set once. THis is basically a variable.

I just cannot understand why it will not work on INSERT but it will work with SELECT....