Error i sql setning
Hvad er der galt med min kode. den virker ikke efter jeg har sat min sql setning på.<?
Db::Conn("open");
$SQL = "SELECT * FROM db_users";
$loadin = mysql_query($SQL) or die("There is an Error in the database");
while ($Get = mysql_fetch_object($loadin)){
if($_POST['username'] != "" and $_POST['password'] != "" and $_POST['passwordtest'] != "" and $_POST['name'] != "" and $_POST['password'] == $_POST['passwordtest'] and $_POST['username'] != $Get->username){
session_start();
include("func.php");
Db::Conn(open);
$do = $_POST['do'];
if($do == "insert db_users"){
$username = $_POST['username'];
$password = md5($_POST['password']);
$name = $_POST['name'];
$start_time = date('g:i a');
$start_day = date('d');
$start_month = date('M');
$start_year = date('Y');
mysql_query("INSERT INTO db_users ( username , password , name , start_time , start_day , start_month , start_year ) VALUES ('$username' , '$password' , '$name' , '$start_time' , '$start_day' , '$start_month' , '$start_year' )") or die (Java::Alert("MySQL Error: ".mysql_error()));
Java::GoToURL("index.php");
}elseif($do == ""){
}
Db::Conn(close);
}else{ ?>
<table>
<tr>
<td>
</td>
</tr>
</table>
<table bgcolor="#FFFF00" align="center" style="border: 1px gray solid;">
<tr>
<td align="center">
Warning
</td>
</tr>
<? if($_POST['username'] == ""){ ?>
<tr>
<td>
The <strong>"Username:"</strong> field is empty?
</td>
</tr>
<? } ?>
<? if($_POST['password'] == ""){ ?>
<tr>
<td>
The <strong>"Password:"</strong> field is empty?
</td>
</tr>
<? } ?>
<? if($_POST['passwordtest'] == ""){ ?>
<tr>
<td>
The <strong>"Retype Password:"</strong> is empty?
</td>
</tr>
<? } ?>
<? if($_POST['password'] != $_POST['passwordtest']){ ?>
<tr>
<td>
The <strong>"Password:"</strong> and the <strong>"Retype Password:"</strong> do not match?
</td>
</tr>
<? } ?>
<? if($_POST['name'] == ""){ ?>
<tr>
<td>
The <strong>"Full Name:"</strong> field is empty?
</td>
</tr>
<? } ?>
<? if($_POST['username'] == $Get->username){ ?>
<tr>
<td>
The <strong>"Username:"</strong> is all ready taken?
</td>
</tr>
<? } ?>
<? if($_POST['username'] == $Get->username){ ?>
<tr>
<td>
The <strong>"Username:"</strong> allready exsist?
</td>
</tr>
<? } ?>
</table>
<table align="center">
<tr>
<td>
<a href="java script:history.go(-1)">Go Back</a>
</td>
</tr>
</table>
<? }}?>
