Jump to content

Archived

This topic is now archived and is closed to further replies.

Eugene

weird error

Recommended Posts

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]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 'desc, cat, banurl, id) VALUES('ggg', 'ggg', 'gfd@gfd.com',[/quote]

Code that triggers that is here:

[code]
if(validate_email($email)){

                mysql_query("
                INSERT INTO top
                (username, password, email, url, title, desc, cat, banurl, id)
                VALUES('$username', '$password', '$email', '$url', '$title', '$desc', '$catergory', '$banner', '$sql')
                ")
                or die(mysql_error());
                echo "Congratulations, you are now a registered member";
            }
[/code]

The Variables are here:

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]

$username = $_POST['username'];
$password = $_POST['password'];
$confirm = $_POST['confpass'];
$email = $_POST['email'];
$url = $_POST['url'];
$title = $_POST['title'];
$desc = $_POST['description'];
$catergory = $_POST['cat'];
$banner = $_POST['banurl'];
$submit = $_POST['submit'];[/quote]

Share this post


Link to post
Share on other sites
The word "desc" is a reserved word, surround it with back ticks ( [!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--][b]`[/b][!--colorc--][/span][!--/colorc--] )

[code]<?php
mysql_query("
                INSERT INTO top
                (`username`, `password`, `email`, `url`, `title`, `desc`, `cat`, `banurl`, `id`)
                VALUES('$username', '$password', '$email', '$url', '$title', '$desc', '$catergory', '$banner', '$sql')
                ")
                or die(mysql_error());
?>[/code]

Ken

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.