Whats wrong with this coding?

Joel_Harley

<?php
// Database Name
$conf["sites_database_name"] = "xxx";
// Databse Login

$conf["sites_database_login"] = "xxx";
// Databse password
$conf["sites_database_password"] = "xxx";
//Databse Path
$conf["path"]="xxx";

$host = $conf["path"];
$user = $conf["sites_database_login"];
$password = $conf["sites_database_password"];
$dbname = $conf["sites_database_name"];

// Connecting to SQL 
$conn = @mysql_connect($host, $user, $password)
	or die ("Sorry could not connect"); 

// Select the database 

$rs = @mysql_select_db($dbname, $conn )
	or die("Could not sellect Database");

// Create the SQL Query

$sql = "select * from vehicles";

// Execute the Query 
$rs = mysql_query($sql, $conn )
	or die("Could not Exexute Query");

// HTML Page for DB Details 

//$list = "<table border=\"1\" cellpadding=\"2\">";
//$list .="<tr><th>Vehicle Name</th></tr>";

// looping through each row of the users database table 
while( $row = mysql_fetch_array($rs))
{
	//$list .="<tr>";
	$list =$row["Name"];
	$list .="</br>";
	//$list .="</tr>";
}
//$list .="</table>"; 

// Write out the list 

echo($list); 

while( $row = mysql_fetch_array($rs))
{
	//$list .="<tr>";
	//$list .=$row["Name"];
	$list .="</br>";
	$list .=$row["entered_service"];
	$list .="</br>";
	//$list .="</tr>";
}
//$list .="</table>"; 

// Write out the list 

echo($list);

Joel_Harley

All its displaying is the [name] twice...

Installer

1 - You add the Name data to $list, then echo $list. You never reset $list to an empty string, so the next time you echo it, it still contains the Name data.

2 - Your first while loop loops through the result array; the pointer is then at the end of the data array. Since you don't reset the data pointer the second while loop finds nothing to add (it starts at the end of the data).

3 - The line "$list = $row['Name'];" resets $list to the latest value of name, so at the end of the loop $list will contain only the last Name found.

Try this:

$list = '';
while ($row = mysql_fetch_array($rs)) {
    $list .= $row['Name'];
    $list .= '</br>';
}
echo($list);

// Reset to empty string:
$list = '';
// Reset data pointer:
mysql_data_seek($rs, 0);

while ($row = mysql_fetch_array($rs)) {
    $list .= '</br>';
    $list .= $row['entered_service'];
    $list .= '</br>';
}
echo($list);

Joel_Harley

slight problem it is only displaying the last [name] and the last [entered_service] from the loop.....

Installer

it is only displaying the last [name]

See my third point.

and the last [entered_service]

It should display all. Are you using "=" or ".=" in the loops?