MySQL while loop not working

[PHPiSean]

I am a noob at php, looking to become great. My php loop only seems to draw 1 row from the database when listing it out. Here is the loop

<?php

require('header.php');

mysql_select_db('center');

$sql = "select username, password from users";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);

$user = $row['username'];
$pass = $row['password'];

echo "<table border='1'>";

while($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>$user</td>";
echo "<td>$pass</td>";
echo "</tr>";
}

echo "</table>";

?>

[Pikachu2000]

There are only 2 records in the table, right? (Ask me how I know that)

[gergy008]

I am a noob at php, looking to become great. My php loop only seems to draw 1 row from the database when listing it out. Here is the loop

<?php

require('header.php');

mysql_select_db('center');

$sql = "select username, password from users";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);

$user = $row['username'];
$pass = $row['password'];

echo "<table border='1'>";

while($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>$user</td>";
echo "<td>$pass</td>";
echo "</tr>";
}

echo "</table>";

?>

 

I don't know if this will help but your setting variables before you cave made the array with mysql_fetch_array.

 

Try using this:

 

<?php

require('header.php');

mysql_select_db('center');

$sql = "select username, password from users";
$result = mysql_query($sql);

echo "<table border='1'>";

while($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>$row['username']</td>";
echo "<td>$pass['password']</td>";      //Remeber this is a loop so every time it passes through each row it gets a new username and password, Opposed to you echoing the first line before.
echo "</tr>";
}

echo "</table>";

?>

[petroz]

There are only 2 records in the table, right? (Ask me how I know that)

 

LOL!!! How do you know???

[PHPiSean]

There are only 2 records in the table, right? (Ask me how I know that)

 

Umm... how?

[PHPiSean]

There are only 2 records in the table, right? (Ask me how I know that)

 

Because I'm always posting about problems?

[Pikachu2000]

There are only 2 records in the table, right? (Ask me how I know that)

 

Because I'm always posting about problems?

 

LOL, no nothing like that. That code will always echo one less record than it returns, and it will always echo only the first record. See my comments in the code . . .

 

$sql = "select username, password from users";
$result = mysql_query($sql);
$row = mysql_fetch_array($result); // <--- This takes the first record and moves the data pointer to the second record
$user = $row['username']; // <--- Move inside the while() loop
$pass = $row['password']; // <--- Move inside the while() loop
echo "<table border='1'>";
while($row = mysql_fetch_array($result)) { // <--- When you call mysql_fetch_array() again, the data pointer is already pointing to the second record
   echo "<tr>";
   echo "<td>$user</td>"; // <--- echos the value from the first record, assigned above
   echo "<td>$pass</td>";  // <--- echos the value from the first record, assigned above
   echo "</tr>";
}
echo "</table>";

[PHPiSean]

There are only 2 records in the table, right? (Ask me how I know that)

 

Because I'm always posting about problems?

 

LOL, no nothing like that. That code will always echo one less record than it returns, and it will always echo only the first record. See my comments in the code . . .

 

$sql = "select username, password from users";
$result = mysql_query($sql);
$row = mysql_fetch_array($result); // <--- This takes the first record and moves the data pointer to the second record
$user = $row['username']; // <--- Move inside the while() loop
$pass = $row['password']; // <--- Move inside the while() loop
echo "<table border='1'>";
while($row = mysql_fetch_array($result)) { // <--- When you call mysql_fetch_array() again, the data pointer is already pointing to the second record
   echo "<tr>";
   echo "<td>$user</td>"; // <--- echos the value from the first record, assigned above
   echo "<td>$pass</td>";  // <--- echos the value from the first record, assigned above
   echo "</tr>";
}
echo "</table>";

 

Thanks, problem solved

[petroz]

Here is what your looking for...

 

<?php

require('header.php');

mysql_select_db('center');

$sql = "select username, password from users";
$result = mysql_query($sql);
//$row = mysql_fetch_array($result);

//$user = $row['username'];
//$pass = $row['password'];

echo "<table border='1'>";

while($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>$row['username']</td>";
echo "<td>$row['password']</td>";
echo "</tr>";
}

echo "</table>";

?>

 

[undertaker333]

i wasted alot of time on it but i dont know wat i m missing.... loop is giving me only one output

 

<?php

$comments= "";

$sql= "SELECT * FROM comment";

$result = mysql_query($sql);

while($row = mysql_fetch_array($result))

  { $serials= $row['serial'];

$names= $row['name'];

$emails= $row['email'];

$msges= $row['msg'];

$date_added= $row['date'];

$comments= "$names <br /> $msges <br /> $date_added";

}

 

?>

[Psycho]

i wasted alot of time on it but i dont know wat i m missing.... loop is giving me only one output

 

<?php

$comments= "";

$sql= "SELECT * FROM comment";

$result = mysql_query($sql);

while($row = mysql_fetch_array($result))

  { $serials= $row['serial'];

$names= $row['name'];

$emails= $row['email'];

$msges= $row['msg'];

$date_added= $row['date'];

$comments= "$names <br /> $msges <br /> $date_added";

}

 

?>

 

Why are you posting in this thread that is 6 months old? Post a new thread.

[jcbones]

When in doubt, copy/paste the query string into phpMyAdmin, or equal database software.  You could also type it into the mysql console.