Insert inconsistent

rowla

Hi,

I have code (below) that takes a blog entry and headline and uses INSERT to add it to the MySQL db. It works, but only like 1 time for every 10 times I try it.

Why would it only be working sometimes?

//add entry to db

	$current = date("l dS F, Y");
	//connect to database "db_name"
	$dbcnx = @mysql_connect("localhost", "db_name", "passwd");
	mysql_select_db("db_name", $dbcnx);
	//insert new record
	$adder="INSERT INTO entries VALUES
	('0','$header','$entry','$current','$usera')";
	// run the SQL query!

$result = mysql_query($adder);
exit;

I would really appreciate any insight into this!

Tom

Sxooter

More than likely you've got character's in your blog entries that need to be escaped (like ' ). See this function:

http://www.php.net/manual/en/function.mysql-escape-string.php

csn

Is there any difference between mysql_escape_string() and addslashes()?

And pg_escape_string() (http://www.php.net/manual/en/function.pg-escape-string.php) - the docs recommend using that instead of addslashes(), but don't state why.

I just saw mysql_real_escape_string() - any idea what difference taking the character set into account would make?

Sxooter

I think it's just ensuring that if your database has one or two odd characters that add_slashes wouldn't escape that the dbname_escape_string functions are guaranteed to work with whatever version of the database you compiled against.