Why is this code not working

[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

 

[.josh]

if you are seeing lots of "==" then you are connecting okay. So then it can only be:

 

a) you said you double checked and you spelled the column names correctly.  This is the most common cause of bug.  Double check.  Make sure you capitalized correctly (case-sensitive!).  print_r($row); in the loop to dump out what is in $row

b) are you using the right table name?

c) are you using the right database?

 

[slj90]

Thanks for your response. Im new to PHP and didn't realise it was case sensitive. The code now works, thanks alot!