Listing mysql data using php - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

kayla · 06-26-2005, 07:44 PM

Hello,
I am very new to PHP but want to learn a little about it.

How can I list the contents of my mysql database in a column like fashion.
not this: Some Address Some City Some State Some Zip

I want the fields from my table displayed like this:
id_address
Some Address
Some City
Some State
Some Zip

id_address
Some Address
Some City
Some State
Some Zip

any help is appreciated for this novice, kay

xacto · 06-26-2005, 09:07 PM

Hi - Nice Forum WMF

`kayla` I think this might point you in the right direction.

PHP Code:


		
			
<html> 

<head> 

  <title>Results</title> 

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head> 

<body> 

<h1>Search Results</h1> 

<?php 

$database="database_name"; 

mysql_connect ("localhost", "username", "password"); 

@mysql_select_db($database) or die( "Unable to select database"); 

$query = "select * from tablename"; 

$result = mysql_query($query); 



  $num_results = mysql_num_rows($result); 



  echo "<p>Number matches found: ".$num_results."</p>"; 

  echo "<hr>"; 



  for ($i=0; $i <$num_results; $i++) 

  { 

      

     $row = mysql_fetch_array($result); 

     echo "<p><strong># "; 

     echo stripslashes($row["contact_id"]); 

  echo "<p><strong>Name: "; 

     echo stripslashes($row["first_name"]); 

  echo "<p><strong>Category: "; 

     echo stripslashes($row["lastname"]); 

     echo "<p><strong>Comment: "; 

     echo stripslashes($row["comments"]); 

      echo "<hr>"; 

     echo "</p>"; 

  } 



?> 

</body> 

</html>

cheers