Entering new row, using PHP

I'm trying to add a row to a MySQL database using PHP. I keep getting an error though.

Here is the line of code...

insert into advisoryarticles values ("", $article_date, $article_title, $article_url, $bioid, $article_source);

The first field is an auto_incremental field, so I am trying to leave it blank and let the database choose. Is that where the problem lies?


Jabbamonkey

You don't need to leave that blank when auto_increment is specified...

Try this (I'm assuming you have the field names the same as the variable names, right?):

INSERT INTO advisoryarticles(article_date,article_title,article_url,bioid,article_source) VALUES('$article_date','$article_title','$article_url','$bioid','$article_source');

Dunno, why it's being truncated btw :confused:

Silly me. What I had would have worked....

I'm using a PHP book to learn this stuff, and the book overlooked a simple and important aspect...

PUT ALL THE ABOVE INTO A mysql_query...
mysql_query(" ",$db);

Ug...

Jabbamonkey,

If you are going to ask mysql related questions you need to post them in the mysql forum.

...