[RESOLVED] MySQL insert problem

[ade1982]

problem number 1002

I'll give the relevant parts of the code

//$id has come from the last page using amend.php?Flaming+Burger
//using urlencode

$id = mysql_real_escape_string($id);
$sql2 = mysql_query("SELECT * FROM album where albumname='$id'");

// ...

<textarea rows="6" name="message" cols="47" class="input">BLAH BLAH</textarea>

// form submits

$jabber = $_POST[message];

mysql_query("INSERT INTO album2 (albumname, remarks) VALUES ('$id', '$jabber' )");

now if I echo $jabber and $id, I get what is expected, but the insert doesn't work

If I need to give any other information, then I can do that.

Thanks again!

[timus]

Hey

Try changing ur sql, mainly ur use of speech marks

 'INSERT INTO album2 (albumname, remarks) 
VALUES ("' . $id . '", "' . $jabber . '" )' 

you could always add

 
if ($sql == false)
{
echo('Invalid query: ' . mysql_error());
}

This should display the sql error

Hope this helps

Tim

[ade1982]

Thanks Tim,

Unfortunately, that doesn't seem to have worked

edit:

I've just realised why! I've forgotten to include the database connection string 😃

edit2:

Yes, I had included it ... still stumped