Problem with &quot;INSERT INTO&quot;

Problem with "INSERT INTO"

daveyc

Hi Guys,

I'm trying to write a little script that adds inserted data into my MySQL database, but i'm having trouble with the syntax of the insert into code.

I have a few variables, which are sent to this script from a form, but when i try to run the script it get an unexpected T_variable.

Any ideas?? Here is my code.

$sql = 'INSERT INTO `shows` (`id`, `unixtime`, `showday`, `showstart`, `showend`, `showtitle`, `showpresenter`, `presenterprofile`, `presenterpicture`) VALUES (NULL, \'0000-00-00\', '$day', '$start', '$end', '$title', '$presenter', '$profile', '$picture');';

Thanks for your help

Davey

NogDog

Use double quotes around the entire string, and single quotes within it for the value quoting:

 $sql = "INSERT INTO `shows` (`id`, `unixtime`, `showday`, `showstart`, `showend`, `showtitle`, `showpresenter`, `presenterprofile`, `presenterpicture`) 
VALUES (NULL, '0000-00-00', '$day', '$start', '$end', '$title', '$presenter', '$profile', '$picture')";

daveyc

Thank you so much!

It works! I just couldn't realise what was going wrong.

On another side of the whole thing, is there any way to overwrite a record with this new one if $day, $start $end are the same as what is being submitted to the form?

Thanks for any help

Dave

NogDog

You could use REPLACE instead of INSERT, but you'd need to define a unique index on those three columns via ALTER TABLE (or by using phpMyAdmin or similar GUI database tool).

daveyc

I may have not correctly explained.

What im looking to do is when the user submits info, it checks the database to see if a record already exists with the same day, start time and end time.. If there is, it prompts the user and says "The following record(s) already exist. Do you wish to over write?"

Then, i suppose after that i could use the REPLACE query. I'm just not sure how i could go about checking to see if a record already exists.

Sorry about my last explanation, I think I started the festivities a little too early.

Happy Holiday's everybody.

Dave