Displaying MYSQL Results

[johnowen]

Hello, i've been at this for a while but this piece of code won't work. Maybe someone can help me, I know the connection to the database works fine.

 

<?php

$query = "SELECT * FROM tracking";
$result = mysql_query($query);
echo "ERROR: " . mysql_error();

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

			$string = "ID: " . $row['id'];
			echo $string;

		}

?>

 

Thanks

[ignace]

echo "ERROR: " . mysql_error();

 

is always executed, wrap a conditional around it:

 

if (!$result) { echo "ERROR: " . mysql_error(); }

 

Where's the mysql_connect() and mysql_select_db() part?