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

[jigsawsoul]

How would i write this, as the var has ' ' ' so its not working right

 

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

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

[jamesxg1]

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

 

James.

[jigsawsoul]

Using the above code give me these errors;

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/jigsaws2/public_html/tape/add2.php on line 33

Parse error: syntax error, unexpected T_STRING in /home/jigsaws2/public_html/tape/add2.php on line 33

 

 

<?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($_POST['use']);

$use = ucwords($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\'});';
$query = "INSERT INTO `uses` (`js`) VALUES ('$js') WHERE `id` = '$id'";

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

include('_resources/closedb.php'); ?>

[jamesxg1]

Try this.

 

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

 

James.

[jigsawsoul]

Na just jumps straight to else saying Couldnt Add 2.. 

 

anyone

[jamesxg1]

$js = "$('#" . $id . "').tipsy({gravity: 'n'});";
$query = "INSERT INTO `uses` (`js`) VALUES ('$js') WHERE `id` = '$id'";
if (mysql_query ($query)) {
$_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');
}

 

Post what the error is.

 

James.

[jigsawsoul]

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

[jamesxg1]

$js = "\$('#" . $id . "').tipsy({gravity: 'n'});";
$query = "INSERT INTO `uses` (`js`) VALUES ('$js') WHERE `id` = '$id'";
if (mysql_query ($query)) {
$_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');
}

 

James.

[jigsawsoul]

Error Message

 

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

[jamesxg1]

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

 

We might be wasting time with the $js var it might be something else, are all the other querys working ok ?

 

James.

[jamesxg1]

Where is $id being set?

 

James.

[jigsawsoul]

yeah the query above works fine... what else could it be

[jigsawsoul]

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

if (mysql_query ($query)) {
	$id = mysql_insert_id();

 

$id = mysql_insert_id();

[jigsawsoul]

i replaced $js with

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

 

and had the error message

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` = '23'' at line 1

 

does this help?

 

[jamesxg1]

Ok post full code I will fix it up for you.

 

James.

[jigsawsoul]

much love 

<?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($_POST['use']);

$use = ucwords($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 = '1';
$query = "INSERT INTO `uses` (`js`) VALUES ('$js') WHERE `id` = '$id'";
if (mysql_query ($query)) {
$_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'); ?>

 

[jigsawsoul]

includes the right $js

 

<?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($_POST['use']);

$use = ucwords($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\'});';
$query = "INSERT INTO `uses` (`js`) VALUES ('$js') WHERE `id` = '$id'";
if (mysql_query ($query)) {
$_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'); ?>

[jamesxg1]

Ok first problem, you have set $js to 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\'});';
$query_t = "INSERT INTO `uses` (`js`) VALUES ('$js')";
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');
?>

 

James.

[jigsawsoul]

yeah i know as i submit the code again above, the code you posted gave me same 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 '' at line 1

[TeddyKiller]

That means $use doesn't have a value. So.. $_POST['use'] musn't have a value Can't see where though.

 

Or $js

[jigsawsoul]

I've check this, and both $use and $js both have a value everytime...

[TeddyKiller]

Have you echo'd them out to see if it does have a value? Do you know the exact offending line?

[jigsawsoul]

yeah i've echo them both out and each have the value they should have.

 

what do you mean by

 

Do you know the exact offending line?

[jigsawsoul]

Everything above the exit(); is fine and works great. 

 

<?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');

}

exit();

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


$query_t = "INSERT INTO `uses` (`js`) VALUES ('$js')";
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]

It might be unrelated, but try changing the $js in the query to a rando value eg:

egesdsg

See if that works, if it does.. then the offending line is the $js.