writing to mysql

thefisherman

Hello,

I can't seem to write to a mysql-table with php.
The next line of code should do the work, yet does not.

$write_statement = "INSERT INTO cartdata (cid, cdesc) VALUES ($cartidnum, $cartdesc)";

After ofcourse succesfully connecting to this database.

first field = int, second = varchar. variables are for instance 1,"computer"

Though when i manually enter some data into the table, the script will read everything and display it correctly.

Thankx in advance

FiSh

xblue

you need to put the second variable in singlequotes. any non-numeric value needs to be quoted, or mysql will mistake it as a column name. in addition, it may be a good idea to output the mysql error (if any).

$cartidnum=1;
$cartdesc="computer";
$write_statement = "INSERT INTO cartdata (cid, cdesc) VALUES ($cartidnum, $cartdesc)"; 
mysql_query($write_statement) or die(mysql_error());

thefisherman

Thanx,

That worked well.

Maybe you can help me out with something else...

I was thinking the other day (and today as well🙂):

What if ten users are browsing the site at the same time?
How do i write the different product that different users select to a table, knowing what belongs to who?
In other words; how do i keep track of who is doing what?

I know sessions could be an option, but i have no idea how this works. Any suggestions?

Thanx

fisH