Грешка в кода

[baiumbg]

Ето кода:

<?php
include('config.php');
$username=$_SESSION['username'];
mysql_connect($dbserver, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$query4="SELECT * FROM logindata WHERE username='$username'";
$query5=mysql_query($query4);
while($row=mysql_fetch_array($query5)) {
	if($row['admin']=='NO') {
		header("location: login.php?do=admin");
	}
	else{
mysql_connect ($dbserver, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
while($row=mysql_fetch_array($query1)) {
$query2="SELECT * FROM logindata";
$query3=mysql_query($query2);
echo'<table border="0" width="50%" align="left"><tr><td><b>Username</b></td><td><b>Password</b></td><td><b>Email</b></td><td><b>IP</b></td><td><b>Admin</b></td></tr>';
while($row=mysql_fetch_array($query3)){
echo'<tr><td>'.$row["username"].'</td>';
echo '<td>'.$row["password"].'</td>';
echo '<td>'.$row["email"].'</td>';
echo '<td>'.$row["IP"].'</td>';
echo '<td>'.$row["admin"].'</td>';
}
echo'</table>';
}
}
}
?>

Изкарва ми бяла страница => трябва да има грешка Някой може ли да я намери?

 

[BattleGrounds]

<?php
session_start();
include('config.php');
$username=$_SESSION['username'];
mysql_connect($dbserver, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die("DB connect".mysql_error());
$query4="SELECT * FROM `logindata` WHERE `username`='$username'";
$query5=mysql_query($query4);
while($row=mysql_fetch_array($query5)) {
if($row['admin']=='NO') {
header("location: login.php?do=admin");
}
else{
mysql_connect ($dbserver, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
while($row=mysql_fetch_array($query1)) {
$query2="SELECT * FROM `logindata`";
$query3=mysql_query($query2);
echo'<table border="0" width="50%" align="left"><tr><td><b>Username</b></td><td><b>Password</b></td><td><b>Email</b></td><td><b>IP</b></td><td><b>Admin</b></td></tr>';
while($row=mysql_fetch_array($query3)){
echo'<tr><td>'.$row["username"].'</td>';
echo '<td>'.$row["password"].'</td>';
echo '<td>'.$row["email"].'</td>';
echo '<td>'.$row["IP"].'</td>';
echo '<td>'.$row["admin"].'</td>';
}
echo'</table>';
}
}
}
?>

 

[vesku]

Защо се свързваш "хиляда" пъти към mysql...Няма никакъв смисал.

 

[nom3r1]

<?php
session_start();
include('config.php');
$username=$_SESSION['username'];
mysql_connect($dbserver, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die("DB connect".mysql_error());
$query4="SELECT * FROM `logindata` WHERE `username`='$username'";
$query5=mysql_query($query4);
while($row=mysql_fetch_array($query5)) {
if($row['admin']=='NO') {
header("location: login.php?do=admin");
}
else{
while($row=mysql_fetch_array($query1)) {
$query2="SELECT * FROM `logindata`";
$query3=mysql_query($query2);
echo'<table border="0" width="50%" align="left"><tr><td><b>Username</b></td><td><b>Password</b></td><td><b>Email</b></td><td><b>IP</b></td><td><b>Admin</b></td></tr>';
while($row=mysql_fetch_array($query3)){
echo'<tr><td>'.$row["username"].'</td>';
echo '<td>'.$row["password"].'</td>';
echo '<td>'.$row["email"].'</td>';
echo '<td>'.$row["IP"].'</td>';
echo '<td>'.$row["admin"].'</td>';
}
echo'</table>';
}
}
}
?>

:?: