MySQL

passing variables threw query

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2005

Posts: 44

Reputation: namit is an unknown quantity at this point

Solved Threads: 0

namit

Offline

Light Poster

passing variables threw query

Dec 29th, 2005

Hey all

What is with this query

$query = mysql_query("UPDATE `namitposts` SET `title` = '$topic' , `date` = '$date' ', `postee` = '$postee', `post` = '$post_text' , `ip` = '$ip' WHERE `id` = '$del'") . mysql_error();

Its not passing the variables am getting this error message

Notice: Query 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 'postee--', `post` = 'post
--asdfsafasf' , `ip` = '83.70.242 SQL: 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 'postee--', `post` = 'post
--asdfsafasf' , `ip` = '83.70.242 in /home/namit/public_html/admin/index.php on line 162

•

Join Date: Jun 2005

Posts: 107

Reputation: madmital is an unknown quantity at this point

Solved Threads: 3

madmital

Offline

Junior Poster

Re: passing variables threw query

Jan 7th, 2006

•

Originally Posted by namit

$query = mysql_query("UPDATE `namitposts` SET `title` = '$topic' , `date` = '$date' ', `postee` = '$postee', `post` = '$post_text' , `ip` = '$ip' WHERE `id` = '$del'") . mysql_error();

Needs to be:
$query = mysql_query("UPDATE namitposts SET title = '" . $topic . "', date = '" . $date . "', postee........

Web Developer
When something seems too good to be true...it usually is

•

Join Date: Oct 2005

Posts: 44

Reputation: Ooble is an unknown quantity at this point

Solved Threads: 6

Ooble

Offline

Light Poster

Re: passing variables threw query

Jan 8th, 2006

No... the code is fine... double quotes in PHP tell it to parse the string for variable names and replace as necessary.

Why are you concatenating the mysql_query return value with the mysql_error return value?

Try this:
[php]$sql = "UPDATE `namitposts` SET `title` = '$topic' , `date` = '$date' ', `postee` = '$postee', `post` = '$post_text' , `ip` = '$ip' WHERE `id` = '$del'";
if ($query = mysql_query($sql))
{
// do stuff
}
else
{
echo '<pre>' . $sql . "\n" . mysql_error() . '</pre>';
}[/php]
If it fails, scan the SQL for any errors.

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
while(sleeping)
    cat_wails();
wake_up();
for(i=0;i<9;i++)
    shoot_cat();
rejoice();
goto(bed);
while(sleeping)
    cat_wails();
wake_up();
for(i=0;i<9;i++)
    shoot_cat();
rejoice();
goto(bed);