displaying data

[slj90]

Hi, I am trying to display data from a table in mysql with the following code, however when the page loads it just shows lines of '=='. Everything is spelt correctly and there is data in the table.

<?php

$connection = mysql_connect("localhost", "root");


mysql_select_db("people", $connection);


$query = "SELECT * FROM customer"; 


$result = mysql_query ($query); 


while ($row = mysql_fetch_array($result)) 
{  
 	  print $row["customerID"]; 
 	  print "=="; //print 2 equals signs 
 	  print  $row["surname"]. "<br>";  
 }
?>

Thanks

[laserlight]

For debugging purposes, perhaps you should change it to:

<?php

$connection = mysql_connect("localhost", "root") or die(mysql_error());

mysql_select_db("people", $connection) or die(mysql_error());

$query = "SELECT customerID, surname FROM customer";

$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_assoc($result))
{
    print $row["customerID"];
    print "=="; //print 2 equals signs
    print $row["surname"]. "<br>";
}

though since the loop is entered I doubt there is a database error. Specifying the column names might help in case there is a discrepancy.

[themarty]

just var_dump() $row in the loop to see how the array is structured

[Ashley_Sheridan]

Field names are case sensitive, so it could be that you've mis-spelt them in your loop code?