error
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 '', 0, 0, 4)' at line 1
tady je celý kod mohl by jsi ho neak upravit hookyns ?
<?php
require_once('auth.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Koupit Itemky</title>
<link href="loginmodule.css" rel="stylesheet" type="text/css" />
</head>
<body>
<h1>Koupit Itemky </h1>
<font color="#009900">Vítám vás na Systému Který Hacknul Daemu.cz !!! Tímto systémem si mužete pridat itemy a další ruzné veci.<br />Do zacátku jsem ti dal 150 Kreditu To ti vystací tak na obycejný itemek +10<br />
<font color="red">Pokud si chces koupit neco cenejšího stací jen poslat sms za 10, 20, 50, 79 nebo 99 kc !!! viz Koupit Kredit.</font></font><br /><br />
<a href="vyber.php">Koupit Itemy</a> | <a href="objednavky.php">Moje Objednávky</a> | <a href="koupit.php">Koupit Kredit</a> | <a href="logout.php">Odhlásit</a>
<br />
<br />
<table><form action="#" method="POST">
<tr><td>Jméno Postavy</td><td><input type="text" name="charr" /></td><tr>
<tr><td>Predmet</td><td><select name="vyh">
<option>-----Zbrane-----</option>
<option>FlameBerge +13 +FO - Cena 1500 GP</option>
<option>RuneBlade +13 +FO - Cena 1500 GP</option>
<option>-----Sety-----</option>
<option>TitanSet +13 +FO - Cena 2100 GP</option>
<option>MoonLight +13 +FO - Cena 900 GP</option>
<option>-----Ostatní-----</option>
<option>Gold Fena - Cena 200 GP</option>
<option>10 Jogu - Cena 400 GP</option>
<option>10 Box of Luck - Cena 151 GP</option>
</select></td><tr>
<tr><td>Cena</td><td><input type="text" name="cena" />// Cenu Opište podle toho co je za Itemem ( Jenom Císla !!! )</td><tr>
<tr><td>Veci Umístit Do</td><td><select name="do">
<option>Baglu</option>
<option>Bedny</option>
</select></td></tr>
<tr><td><td><input type="submit" value="Odeslat" /></td></td></tr>
</table></form>
<?php
if (isset($_POST['charr'], $_POST['do'])){
$charr = $_POST['charr'];
$vyh = $_POST['vyh'];
$do = $_POST['do'];
$cena = $_POST['cena'];
function mysql_tabulka($host, $uzivatel, $heslo, $databaza, $tabulka){
$pripoj = mysql_connect($host, $uzivatel, $heslo);
$vyber_db = mysql_select_db($databaza, $pripoj);
if($_POST['do'] == "Baglu"){
mysql_query ("INSERT INTO `".$tabulka."` (`char`, `vyh`, `cena`, `vloz`, `stav`, `member_id`) VALUES ('".$_POST['charr']."', '".$_POST['vyh']."', '".$_POST['cena']."', ', 0, 0, ".$_SESSION['SESS_MEMBER_ID'].")") or die ( "Error:". mysql_error() );
echo "za 24h to tam máš";
}
if($_POST['do'] == "Bedny"){
mysql_query ("INSERT INTO `".$tabulka."` (`char`, `vyh`, `cena`, `vloz`, `stav`, `member_id`) VALUES ('".$_POST['charr']."', '".$_POST['vyh']."', '".$_POST['cena']."', ', 1, 0, ".$_SESSION['SESS_MEMBER_ID'].")") or die ( "Error:". mysql_error() );
echo "za 24h to tam máš";
}
}
mysql_tabulka("localhost", "root", "", "test", "objednavky"); }
?>
</body>
</html>