Problems displaying the data from MySql

raffielim

Hi... i want to display all the data inside our mysql database... and i am having problems with it... coz it only displays the last data entry in the database... can you guys please take a look at my code and help me if there is something wrong with it.
Thanks Wonderful People!

<?php require_once('Connections/connection.php'); ?>
<?php
mysql_select_db($database_connection, $connection);
$query_show = "SELECT * FROM dealers";
$show = mysql_query($query_show, $connection) or die(mysql_error());
$row_show = mysql_fetch_assoc($show);
$totalRows_show = mysql_num_rows($show);

<? require("connections/config2.php");
require("connections/inc_dbfunctions.php");

if ($totalRows_show > 0 ) {
while ($data = mysql_fetch_array($show)) {
$rid = $data["id"];
$rpass = $data["pass"];
$rname = $data ["name"];
$raddress = $data ["address"];
$rphone = $data ["phone"];
$remail = $data ["email"];

echo "
<html>
<head>
<meta http-equiv='Content-Language' content='en-us'>
<meta http-equiv='Content-Type' content='text/html; charset=windows-1252'>
<meta name='GENERATOR' content='Microsoft FrontPage 4.0'>
<meta name='ProgId' content='FrontPage.Editor.Document'>
<title>New Page 1</title>
</head>

<body>

<table border='1' width='500'>
<tr>
  <td width='95'>ID:</td>
  <td width='389'>$rid</td>
</tr>
<tr>
  <td width='95'>Password:</td>
  <td width='389'>$rpass</td>
</tr>
<tr>
  <td width='95'>Name:</td>
  <td width='389'>$rname</td>
</tr>
<tr>
  <td width='95'>Address:</td>
  <td width='389'>$raddress</td>
</tr>
<tr>
  <td width='95'>Phone:</td>
  <td width='389'>$rphone</td>
</tr>
<tr>
  <td width='95'>Email:</td>
  <td width='389'>$remail</td>
</tr>  </table>  </body>  </html>";

}}
mysql_free_result($show); ?>

Pig

$sql = "SELECT * FROM dealers"; 
$result = mysql_query($sql);
if( mysql_num_rows($result) == 0 ) echo("No records");
else
{
     echo("<table border='1' width='500'>");
     while( $row = mysql_fetch_array($result) )
     {
          echo("
             <tr> 
               <td width='95'>ID:</td> 
               <td width='389'>" . row[$rid] . "</td> 
               </tr>
               ...etc
          ");
     }
     echo("</table>");
}

raffielim

hi... i can now see the whole data from my site now... the only problem i have now is that... i cannot view the first data that was inputed... the number ( 0 ) data... i can read the 1, 2, 3, 4, 5... and so on... but the first inpuputed data dpesn't show... can you help me? here is the code... thanks

<? require("connections/config2.php");
require("connections/inc_dbfunctions.php");

<body>

<table border='1' width='500'>
<tr>
  <td width='95'>ID:</td>
  <td width='389'>$rid</td>
</tr>
<tr>
  <td width='95'>Password:</td>
  <td width='389'>$rpass</td>
</tr>
<tr>
  <td width='95'>Name:</td>
  <td width='389'>$rname</td>
</tr>
<tr>
  <td width='95'>Address:</td>
  <td width='389'>$raddress</td>
</tr>
<tr>
  <td width='95'>Phone:</td>
  <td width='389'>$rphone</td>
</tr>
<tr>
  <td width='95'>Email:</td>
  <td width='389'>$remail</td>
</tr>  </table>  </body>  </html>";

}}
mysql_free_result($show); ?>

mourisj

I am not sure at 100%, but I think the reason why you only get your last record is this:

Somewhere you have a line:

$row_show = mysql_fetch_assoc($show);

After this, the result pointer is placed after the first record.

Later you have the code:

while ($data = mysql_fetch_array($show)) {

As the pointer is at the second line, the first one cannot be displayed anymore.

Solutions:

Either you omit the mysql_fetch_assoc() and use the mysql_fetch_array() to display the results
Or you use that first array to display the results and omit the mysql_fetch_array() .
Or you reset the pointer to the first position : mysql_data_seek($show, 0)

However, your table will display in this way:

ID: 1
Password: passwd1
Name: name1
(etc)
ID: 2
Password: passwd2
Name: name2
(etc)
ID: 3
Password: passwd3
Name: name3
(etc)

Maybe you want to have a multicolumn table to display the data:

ID   Password   Name ...
  1   passwd1    name1    ...
  2   passwd2    name2    ...

You have to change your code do do this:

code=php
else
{
echo("<table border='1' width='500'>");
echo("<tr><th>ID</th><th>Password></th><th>Name</th> etc</tr>");
while( $row = mysql_fetch_array($result) )
{
echo("
<tr>
<td width='389'>" . row[$rid] . "</td>
<td width='389'>" . row[$rpass] . "</td>
<td width='389'>" . row[$rname] . "</td>
(etc)
</tr>
...etc
");
}
echo("</table>");
}[/code]