[SOLVED] MySQL INSERT INTO

[ktalebian]

Hi

For some reason, this script does nto work:

// Connection to db made, all variables are gathered

mysql_select_db("website");

mysql_query ("INSERT INTO match (name, type, date_start, date_end, board, article, link) VALUES ('$name','$type','$start','$end','$board_final','$article_final','$link_final')") or die('Cannot continue);

 

I keep getting the error (the die() error).

I first thought maybe the names are wrong, so I only used one inserting, just inserting a value into "name", but still nothing happens!

Why?

Thank you

[nathanmaxsonadil]

change

mysql_query ("INSERT INTO match (name, type, date_start, date_end, board, article, link) VALUES                ('$name','$type','$start','$end','$board_final','$article_final','$link_final')") or die('Cannot continue);

to

mysql_query ("INSERT INTO match (name, type, date_start, date_end, board, article, link) VALUES                ('{$name}','{$type}','{$start}','{$end}','{$board_final}','{$article_final}','{$link_final}')") or die('Cannot continue);

[keeB]

Actually, that wont do a thing ^^

 

Change it to this:

<?php
mysql_select_db("website");
mysql_query ("INSERT INTO match (name, type, date_start, date_end, board, article, link) VALUES                 ('$name','$type','$start','$end','$board_final','$article_final','$link_final')") or die('Cannot continue because: ' . mysql_error() );
?>

[ktalebian]

Hi

Thank you for the reply.

None of the following worked!

I started playing with the code of PHPBB3, and that type of coding works!

Any guesses why? Plus, I still do not understand that type of coding! Help!

[keeB]

If you implemented my script, it should have said the following:

 

Cannot continue because: <some error here>

 

Give us the error

[Barand]

I think you'll find that it's because "match" is a reserved SQL word

 

use `match`

 

or rename the table