Какво е грешно?

M

miro_94

Registered
Код: 
<?php include("conn.php"); ?>
<?php
$sql = "SELECT * FROM `users` WHERE id='$row[id]'";
$result = mysql_query($sql);
if($result){
echo "";
}
else{
echo "ERROR:" . mysql_error();;
}
$sql1 = "SELECT * FROM `users` WHERE username='$row[username]'";
$result1 = mysql_query($sql1);
if($result1){
echo "";
}
else{
echo "ERROR:" . mysql_error();;
}
$sql2 = "SELECT * FROM `users` WHERE password='$row[password]'";
$result2 = mysql_query($sql2);
if($result2){
echo "";
}
else{
echo "ERROR:" . mysql_error();;
}
?>
<!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=windows-1251" />
<link type="text/css" rel="stylesheet" href="style/style.css" />
<title><?php echo $title; ?></title>
</head>

<body>
<div align="center" class="logo">
</div>
<div align="center" class="menu">
<a href="#">Home</a> | <a href="#">Second</a> | <a href="#">Thirth</a> | <a href="#">Forth</a> | <a href="#">Contact</a>
</div><br />
<form name="members" id="members">
<table width="400" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#F1F3F8">
  <tr>
    <td width="25" align="center">№</td>
    <td width="191" align="center">USER</td>
    <td width="151" align="center">PASS</td>
  </tr>
  <tr>
    <td><?php echo $row['id']; ?></td>
    <td><?php echo $row['username']; ?></td>
    <td><?php echo $row['password']; ?></td>
  </tr>
</table>
</form>
</body>
</html>
 
Правих малко догадки какво трябва да прави кода... трябва да ти извежда потребителите с номера им, името и паролата, нали ?
Ако е така, ето код:
Код: 
<?php include("conn.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=windows-1251" />
<link type="text/css" rel="stylesheet" href="style/style.css" />
<title><?php echo $title; ?></title>
</head>

<body>
<div align="center" class="logo">
</div>
<div align="center" class="menu">
<a href="#">Home</a> | <a href="#">Second</a> | <a href="#">Thirth</a> | <a href="#">Forth</a> | <a href="#">Contact</a>
</div><br />
<form name="members" id="members">
<table width="400" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#F1F3F8">
  <tr>
    <td width="25" align="center">№</td>
    <td width="191" align="center">USER</td>
    <td width="151" align="center">PASS</td>
  </tr>
  <?php
$sql = "SELECT * FROM `users` order by id";
$result = mysql_query($sql);
while ( $row = mysql_fetch_array( $result )){ 

echo "  <tr>
    <td>".$row[id]."</td>
    <td>".$row[username]."</td>
    <td>".$row[password]."</td>
  </tr>";

}


?>

</table>
</form>
</body>
</html>
 
И аз така си помислих ама НЕ разбрах какви са тия $row[id], $row[username] от де ги взе? :shock: Иначе лесно се прави такова чудо :) Щрак един селект да ти ги изкара, Щрак едно mysql_fetch_row() и си готов :)
 
luudman каза:
И аз така си помислих ама НЕ разбрах какви са тия $row[id], $row[username] от де ги взе? :shock: Иначе лесно се прави такова чудо :) Щрак един селект да ти ги изкара, Щрак едно mysql_fetch_row() и си готов :)
Увеличете...
mysql_fetch_row ? :idea:
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе