Whats The Correct Way To Write This... !? please pretty simple code

[jigsawsoul]

changeing the js query to egesdsg worked prefect..  :'(

[TeddyKiller]

Ok, so the problem lies here

$js = '\$(\'#' . $id . '\').tipsy({gravity: \'n\'});';

Echo it.

$js = '\$(\'#' . $id . '\').tipsy({gravity: \'n\'});';
exit($js);

If that comes out with a value. You could do this.

$query_t = "INSERT INTO `uses` (`js`) VALUES ('$js')";
exit($query_t);

 

Whats the results?

[jigsawsoul]

result =

INSERT INTO `uses` (`js`) VALUES ('\$('#36').tipsy({gravity: 'n'});')

[jigsawsoul]

$js = '\$(\'#' . $id . '\').tipsy({gravity: \'n\'});';
$query_t = "INSERT INTO `uses` (`js`) VALUES ('$js') WHERE `id` = '$id'";
exit($query_t);

 

result

INSERT INTO `uses` (`js`) VALUES ('\$('#39').tipsy({gravity: 'n'});') WHERE `id` = '39'

 

[TeddyKiller]

INSERT INTO `uses` (`js`) VALUES ('\$('#36').tipsy({gravity: 'n'});')

 

Now the problem is.. you are using single quotes, within single quotes. Causing it to close.

So you could try..

$js = mysql_real_escape_string('\$(\'#' . $id . '\').tipsy({gravity: \'n\'});');

[jigsawsoul]

what would be the correct way to write this sorry 

[TeddyKiller]

Editted last post with a possbile fix

[PFMaBiSmAd]

Use mysql_real_escape_string() on the $js variable before you put it into the query statement so that any special sql characters in it (like the single-quotes) don't break the sql syntax. Your $js = line of code in the first post in this thread was probably okay.

[jigsawsoul]

@PFMaBiSmAd

 

Error

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 'WHERE `id` = '43'' at line 1

 

<?php session_start(); 

$message .= $_SESSION["message"];

include('_resources/opendb.php');

$_SESSION['message'] = "";

if (empty($_POST['use']))
            $_SESSION['message'] .= "<font color=red><li>You must submit in an idea.<br /></li></font>";

    if (!empty($_SESSION['message'])) {

$_SESSION['message'] .= "<br />";
            header("Location: add.php");
            exit();
     }

$use = mysql_real_escape_string(ucwords($_POST['use']));

$query = "INSERT INTO `uses` (`uses`) VALUES('$use')";

if (mysql_query($query)) {

$id = mysql_insert_id();

} else {

$_SESSION['message'] = "<font color=red><li>Couldnt Add 1</li><br /></font>";
header('Location: add.php');

}


$js = "$('#$id').tipsy({gravity: 'n'});";

$js = mysql_real_escape_string($js);

$query_t = "INSERT INTO `uses` (`js`) VALUES ('$js') WHERE `id` = '$id'";

if (mysql_query($query_t)) {
	$_SESSION['message'] = "<font color=green><li>Your idea was added below</li><br /></font>";
	header('Location: index.php');
}

else {
	exit(print(mysql_error()));
	$_SESSION['message'] = "<font color=red><li>Couldnt Add 2</li><br /></font>";
	header('Location: add.php');
}

include('_resources/closedb.php');

?>

[TeddyKiller]

You cannot do an insert query where someones data is.

I'm assuming you mean update?

$query_t = "UPDATE `uses` SET `js`= '$js' WHERE `id` = '$id'";