[RESOLVED] Please Help

[fus10n]

Im trying to make a registration form but i keep getting the following error: Parse error: syntax error, unexpected '>' in /home2/yourclas/public_html/register.php on line 13 here is the code:

<?php
include 'mysql-connect.php';
$username = $_POST['username'];
$password = $_POST['password'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$age = $_POST['age'];
$ip = $_SERVER['REMOTE_ADDR'];

$result = mysql_num_rows(mysql_query("SELECT * FROM test WHERE username='$username'"));
if($result == 1)
        {
        echo ‘<h1>ERROR!</h1>The username you have chosen already exists!’;
        }
else
        {
        mysql_query("INSERT INTO test (username, password, firstname, lastname, age, ip) 
VALUES ('$username', '$password', '$firstname', '$lastname', '$age', '$ip')");

    echo '
  <p>Congratulations! You have successfully registered! </p>
  <p>Click <a href="login.php">here</a> to login.</p>‘;
?>

[bradgrafelman]

When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze. In addition, there is a stickied thread in the Coding forum named Parse Error: syntax error; please keep all parse error related problems in that thread rather than starting a new one. (Hence why this thread is now locked.)

As for your problem, note how the color coding on line #13 isn't right; you've got "curly quotes" instead of normal quotes.

Finally, your code is vulnerable to SQL injection attacks and/or just plain SQL errors; user-supplied data should never be placed directly into a SQL query string. Instead, you must first sanitize it with a function such as [man]mysql_real_escape_string/man (for string data).