Is this possible?

kashmirekat

This is what I want to do, thus far it is not working so I am thinking it's not possible.

In my database, I have the following:

 $sql = "INSERT INTO ($_SESSION['username']) VALUES('$id','$category','$image','$content')";

Where the username is the table to which my content will be stored. I have echoed the username from my submit code (information is posted from a form and entered into the db), and it shows up correctly as the username. It works when I just enter the username straight up where the '($_SESSION['username'])' is; however, I wanted to it make it general so I did not have to make several pages for the several different databases relating to the users.

So is it possible or not? Thank you and have a nice day!

stolzyboy

you may have to insert into all four fields if you have not null specified on them, do you get an error when you use or die

$result = mysql_query($sql) or die(mysql_error());

also maybe set

$_SESSION['username']

equal to a variable temporarily to not worry about quotes

$qwerty = $_SESSION['username'];

then insert $qwerty instead

stolzyboy

oh, and btw, it is possible, you just need to get the code worked out correctly, good luck

kashmirekat

It works now. I had tried substituting the $qwerty in the db code before, but I kept getting a parse T_VARIABLE error and I got that when I tried it again, but I forgot the semicolon after $qwerty=$_SESSION['username'].

Thank you so much for your help!
Have a nice day!