Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

PHP

Austin Klenk
Austin Klenk
4,399 Points
Posted by Austin Klenk
Austin Klenk
4,399 Points

Mysql Problem

I am getting this error from my mysql server

```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 '€ “members WHERE user='1234'' at line 1

Byron Stokes
Byron Stokes
291 Points

What's the code you're trying to run?

Austin Klenk
Austin Klenk
4,399 Points
Austin Klenk
Austin Klenk
4,399 Points

id have to say this is what it is trying since im trying to signup

<?php // signup.php
include_once 'header.php';

echo <<<_END
<script>
function checkUser(user)
{
    if (user.value == '')
    {
        O('info').innerHTML = ''
        return
    }
    params  = "user=" + user.value
    request = new ajaxRequest()
    request.open("POST", "checkuser.php", true)
    request.setRequestHeader("Content-type", "application/x-www-form-urlencoded")
    request.setRequestHeader("Content-length", params.length)
    request.setRequestHeader("Connection", "close")

    request.onreadystatechange = function()
    {
        if (this.readyState == 4)
            if (this.status == 200)
                if (this.responseText != null)
                    O('info').innerHTML = this.responseText
    }
    request.send(params)
}

function ajaxRequest()
{
    try { var request = new XMLHttpRequest() }
    catch(e1) {
        try { request = new ActiveXObject("Msxml2.XMLHTTP") }
        catch(e2) {
            try { request = new ActiveXObject("Microsoft.XMLHTTP") }
            catch(e3) {
                request = false
    }   }   }
    return request
}
</script>
<div class='main'><h3>Please enter your details to sign up</h3>

_END;

$error = $user = $pass = "";
if (isset($_SESSION['user'])) destroySession();

if (isset($_POST['user']))
{
    $user = sanitizeString($_POST['user']);
    $pass = sanitizeString($_POST['pass']);

    if ($user == "" || $pass == "")
        $error = "Not all fields were entered<br /><br />";
    else
    {
        if (mysql_num_rows(queryMysql("SELECT * FROM ” “members WHERE user='$user'")))
            $error = "That username already exists<br /><br />";
        else
            {
            queryMysql("INSERT INTO members VALUES('$user', '$pass')");
            die("<h4>Account created</h4>Please Log in.<br /><br />");
        }
    }
}

echo <<<_END
<form method='post' action='signup.php'>$error
<span class='fieldname'>Username</span>
<input type='text' maxlength='16' name='user' value='$user' onBlur='checkUser(this)'/><span id='info'></span><br />

<span class='fieldname'>Password</span>
<input type='password' maxlength='16' name='pass'value='$pass' /><br />
_END;

?>

<span class='fieldname'>&nbsp;</span>
<input type='submit' value='Sign up' />
</form></div><br /></body></html>

2 Answers

Byron Stokes
Byron Stokes
291 Points

I believe your problem is this "SELECT * FROM ” “members WHERE user='$user'")

You have an extra quotation in that line. Should be something like that "SELECT * FROM `members` WHERE user='$user'")

Austin Klenk
Austin Klenk
4,399 Points
Austin Klenk
Austin Klenk
4,399 Points

Thank You so much!