Getting values from an SQL table on php - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

mrfox · 09-22-2005, 06:07 AM

How do I use php to select from the DB on to look at a specific item at a column and then display to me another value that is on the same row as the selected value? mysql_query?

kayla · 09-23-2005, 08:29 PM

You can just run a query like this for example:

PHP Code:


		
			
<?php

// Make a MySQL Connection

mysql_connect("localhost", "username", "passwd") or die(mysql_error());

mysql_select_db("test_db") or die(mysql_error());



// Get all the data from the "example_table"

$result = mysql_query("SELECT * FROM example_table") 

or die(mysql_error()); 



echo "<table border='1'>";

echo "<tr> <th>Name</th> <th>Age</th> </tr>";

// keeps getting the next row until there are no more to get

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

// Print out the contents of each row into a table

echo "<tr><td>"; 

echo $row['name'];

echo "</td><td>"; 

echo $row['age'];

echo "</td></tr>"; 

} 

echo "</table>";



?>

hope this helps