PHP Retrieve Data From MySQL

[itsureboy]

Hi.. I just want to know the code to retrieve data from a MySQL Table.

I am having problems retrieving it when i load the page nothing comes up from the table.

Thanks in advance.....

[pocobueno1388]

<?php

$query = mysql_query("SELECT row1, row2 FROM table_name WHERE condition");
$row = mysql_fetch_assoc($query);

echo $row['row1'];

?>

[Archadian]

$query = mysql_query("SELECT col1, col2 FROM table_name WHERE condition");

 

col being the columns in the table at the top going from left to right