Parse Error?

[crawfd]

Seem to be getting a parse error where the replaceTags line is ...can't see it.

//put results into db 
$sql =  "INSERT INTO mdresults (id, title, story) ". "VALUES ('". 
        mysql_real_escape_string($this->inText['id'])."', '". 
        mysql_real_escape_string($this->inText['title'])."', '". 
        mysql_real_escape_string($this->replaceTags($_POST['word'])."')"; 
//end inputting results 

[halojoy]

I think maybe you are missing a parentes at the right side
here: ($this->replaceTags($_POST['word'])

[crawfd]

Well i get the following error:

Warning: Failed Query: INSERT INTO mdresults (id, title, story) VALUES ('2', 'My Trip to Pennsylvania', '' [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1] in class.madlibs.php on line 293

//put results into db 
$sql =  "INSERT INTO mdresults (id, title, story) ". "VALUES ('". 
        mysql_real_escape_string($this->inText['id'])."', '". 
        mysql_real_escape_string($this->inText['title'])."', '". 
        mysql_real_escape_string($this->replaceTags($_POST['word']))."'";  

if(!mysql_query($sql, $this->dbID)) { 
    trigger_error("Failed Query: ".$sql." [".mysql_error($this->dbID)."]", E_USER_WARNING); 
    return false; 
} else { 
    return true; 
} 
//end inputting results 

[halojoy]

well,
you removed the last )
think it should be:

//put results into db
$sql =  "INSERT INTO mdresults (id, title, story) ". "VALUES ('".
        mysql_real_escape_string($this->inText['id'])."', '".
        mysql_real_escape_string($this->inText['title'])."', '".
        mysql_real_escape_string($this->replaceTags($_POST['word']))."')"; 

[Houdini]

Try not inserting the id it is probably auto_increment and it is a number and see what happens

[crawfd]

Dang,

It's inserting the id, title, but no story field. What I'm trying to do is combine the value of $this->decompPositions($POST and $this->replaceTags($POST['word']); (which in essense creates the story) in the else statement and use it as a value for insert. How do I combine these two objects into one value so that it can insert?? See comment below

function displayMadlib()
{
	$this->getStory();
	if (!isset($_POST['positions']))
	{
		if ($this->inText['story'])
		{
			$this->getTagPositions();
			$this->showForm();
		}
		else
		{
			echo 'No madlib story has been loaded.';
		}
	}
	else
	{
		if ($this->inText['story'])
		{
                                          //these are the two functions that seemingly create the adlib story. I need to take these two functions and insert it as a value in query below. I thought just inserting the replaceTags function would do it but I obviously  need the other function?
			$this->decompPositions($_POST['positions']);
			$this->replaceTags($_POST['word']);

$sql =  "INSERT INTO mdresults (id, title, story) ". "VALUES ('". 
        mysql_real_escape_string($this->inText['id'])."', '". 
        mysql_real_escape_string($this->inText['title'])."', '". 
        mysql_real_escape_string($this->replaceTags($_POST['word']))."')"; 

$result = @mysql_query($sql, $this->dbID);
//end inputting results 

[Houdini]

$sql =  "INSERT INTO mdresults ( title, story) VALUES ('".
        mysql_real_escape_string($this->inText['title'])."', '".
        mysql_real_escape_string($this->replaceTags($_POST['word']))."'"; 

and see what happens OR show the CLASS that you are using.

OR I just saw the real parse error

$sql = "INSERT INTO mdresults (id, title, story) ". "VALUES ('". //what is this
mysql_real_escape_string($this->inText['id'])."', '". //or this
mysql_real_escape_string($this->inText['title'])."', '".//or this?????
mysql_real_escape_string($this->replaceTags($_POST['word']))."'";

what is all these quotes and concatenation there is the problem.

[Weedpacket]

Houdini wrote:

what is all these quotes and concatenation there is the problem.

Indeed; using some temporary variables would make the code easier to read (which is the important thing in source code):

$title = mysql_real_escape_string($this->inText['title']);
$story = mysql_real_escape_string($this->replaceTags($_POST['word']));
$sql = "INSERT INTO mdresults ( title, story) VALUES ('$title', '$story'")";