jones53084 Posted October 16, 2006 Share Posted October 16, 2006 I am creating a PHP page using a MySQL database. On my page, I have the user register for the first time, and upon registration it automatically creates a table with their username. I am running into a problem when the user logs into their account. The user logs in, and it brings them to a page where they can add new information to their table or can search their table. Since every user is using a separate table, I am running into trouble when I set the table that specific user is using. I have no problem if it is a static table name, but when the table name comes from a variable set as:$table = $_REQUEST["user"];then there is a problem. Here is more of my code:$table = $_REQUEST["user"];$result = mysql_query("SELECT * FROM $table Where Name='$name'");while($row = mysql_fetch_array($result))Then later in the code:$sql = "INSERT INTO $table (name, address, city, state, zip) VALUES ('$name', '$address', '$city', '$state', '$zip')";This results in an error message:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\Test\add.php on line 54You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(name, address, city, state, zip) VALUES ('l', 'j', 'j', 'j', 'j')' at line 1The $_REQUEST[“user”] comes from a different page. This is done on the initial logon screen. After the username and password is submitted correctly it brings you to a page that asks if you wish to search or add a new record. Then if you go to the add a new record page(haven’t worked with the search page yet!) this is where the code above is located. Will using, $table = $_REQUEST["user"];, allow me to access the data from this variable a couple pages deep into my project? Is this global, so should any page have access to it? Is there something in MySQL that will not allow a variable such as the one I am calling?Thanks for any help you can provide!!!!!!!!!!! Quote Link to comment Share on other sites More sharing options...
marcus Posted October 16, 2006 Share Posted October 16, 2006 you literally made a new table for every single user? or did you make a whole new row? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.