Това ми е кода, но ми дава грешка
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 'rrrrrrrr' , 'man.gif' , 'rrrrrrrr , 'rrrrrrrr')' at line 2
Демек от Аватар.. до регистриран на..
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 'rrrrrrrr' , 'man.gif' , 'rrrrrrrr , 'rrrrrrrr')' at line 2
Демек от Аватар.. до регистриран на..
Код:
<?
include ("config.php");
if(isset($_POST['submit'])){
$username = addslashes($_POST['username']);
$password = addslashes($_POST['password']);
$email = addslashes($_POST['email']);
$name = addslashes($_POST['name']);
$regip = addslashes($_POST['regip']);
$opisanie = addslashes($_POST['opisanie']);
$avatar = addslashes($_POST['avatar']);
$sex = addslashes($_POST['sex']);
$country = addslashes($_POST['country']);
$regdate = addslashes($_POST['regdate']);
$sql = mysql_query("INSERT INTO $table_name (`username` , `password` , `email` , `name` , `regip` , `opisanie` , `avatar` , `sex` , `country` , `regdate`)
VALUES ('$username' , '$password' , '$email' , '$name' , '$regip' , '$opisanie , '$avatar' , '$sex' , '$country , '$regdate')") or die(mysql_error());
if($sql){
echo "Успешно се регистрирахте :)";
}
} else {
?>
<center><form method="post" action="">
Потребител:<br />
<input name="username" type="text" class="txt" id="username" "size="30" value="" /><br />
Парола:<br />
<input name="password" type="text" class="password" id="password" "size="30" value="" /><br />
Е-мейл:<br />
<input name="email" type="text" class="txt" id="email" "size="30" value="" /><br />
Име:<br />
<input name="name" type="text" class="txt" id="name" "size="30" value="" /><br />
ИП:<br />
<input name="regip" type="text" class="txt" id="regip" "size="30" value="" /><br />
Oписание:<br/>
<textarea name="opisanie" cols="40" rows="10"></textarea><br />
Аватар:<br />
<input name="avatar" type="text" class="txt" id="avatar" "size="30" value="" /><br />
Пол:<br/>
<select name="sex">
<option value="man.gif">Мъж</option>
<option value="girl.gif">Жена</option>
</select>
<br />
Държава:<br />
<input name="country" type="text" class="txt" id="country" "size="30" value="" /><br />
Регистриран на:<br />
<input name="regdate" type="text" class="txt" id="regdate" "size="30" value="" /><br />
<input name="submit" type="submit" id="button" value="Регистрирай ме !" />
</form></center>
<?
}
?>
";