wont add new entry to database

[forcer]

i have created a news system. but for somereason i cant seem to get it to add new news from a form to the database.

this is the code i am using:

mysql_query('INSERT INTO posts SET title="'.addslashes($_POST['title']).'", message="'.addslashes($_POST['message']).'", date="'.addslashes($_POST['date']));

anyone spot anything wrong with it?

[Rodders]

This doesn't necessarily fix your problem, but I find it difficult to debug your SQL statement when it contains concatenation and PHP code as well as SQL......

mysql_query('INSERT INTO posts SET title="'.addslashes($_POST['title']).'", message="'.addslashes($_POST['message']).'", date="'.addslashes($_POST['date']));

So, what I tend to do is build-up my SQL statement in a variable first.....

$sql = "INSERT INTO posts SET ";
$sql .= "title = " . addslashes($_POST['title']) . ";

// etc. etc.

mysql_query($sql);

That way, if it doesn't work you can echo out the SQL on its own and run it in phpMyadmin or equivalent to find more accurate error information.......

$sql = "INSERT INTO posts SET ";
$sql .= "title = " . addslashes($_POST['title']) . ";

// etc. etc.

echo $sql;

mysql_query($sql);

If you're still having trouble with the error then let us know what the error message reads. It may be that your syntax is wrong, it may be that you have a typo in your field names or table names.

[forcer]

i tried something similar befre got no where. there is also no typo... i'm confused

[Rodders]

I know you must be confused, otherwise you wouldn't have come looking for help!

For me it is too much effort to take your code and try it and fiddle with it to find the problem, especially since the problem could be unrelated to PHP, i.e. a typo or database problem.

So, what I suggest is that you put your SQL into a separate variable and then try running it as above. If you still have problems, include the 'echo' and post your SQL back here so I (or someone else) can check your SQL syntax.

It would also be useful to know what database you are using (MySQL? What version?) and if you could describe the structure of the table 'posts', i.e. field names, indexes, field types and lengths.

As a final thought, are you absolutely sure that your script gets as far as running this piece of code. It may be that it never tries to insert your news.....maybe an idea to post the rest of your script just in case...

[forcer]

i have inserted code manually to the table by adding a row, it works fine and outputs the news no problem.

but when i submit tyhe news it gives no errors

<?php 
mysql_query('INSERT INTO posts SET title="'.addslashes($_POST['title']).'", message="'.addslashes($_POST['message']).'", date="'.addslashes($_POST['date']));

if (isset($_POST['title'])) {
	if (trim($_POST['title']) != '') {
		header('Location: ../news.php');
		die('Done...');
	} else {
	}
}
?>

ther is the full lot😛

[Rodders]

OK, you seem to be refusing to put your SQL into a variable so that you can echo out the raw SQL without any PHP and formatting.......that makes things a little harder but I still want to try and help.....

It could be that your SQL statement doesn't have a closing ' after $_POST['date']

Can you show us the structure of your 'posts' table.....

[zapa]

simple solution...

maybe 🙂
...try.....

<?php  

mysql_query("INSERT INTO posts SET title='".addslashes($_POST['title'])."', message='".addslashes($_POST['message'])."', date='".addslashes($_POST['date']."')"); 
?> 

you did not close out the "(()");

changed ' to " and when you put in SET
use it like so...

title='seomthing'
or
title='".$name."'
or
title=\'$name\'

[forcer]

nevermind, i found one or two problems with the code, but the main reason it didnt work was because i forgot to require the database connecxtion file so it wasnt even connected to the databasae...haha what a noob