How to retrive the values from the database

[ishlux]

Hi all,
I want the the tag , to retrieve the values from the database.........

Thanks

[lydia21]

use select query

[lydia21]

$r1=mysql_query("SELECT * from tblenme where column='$id'") or die("ERROR:".mysql_error());
while($rom = mysql_fetch_row($r1))
{
echo $rom[0];//to disply first element from the fetched record
}

[ishlux]

Hi , I have written the code, but its giving an error,,,
Error: Could not connect to database. Please try again later.

<?php
include 'database.php';

$result = mysql_query("SELECT * FROM autoalto_contractor");

while($row = mysql_fetch_array($result))
{
echo $row;
echo " " . $row;
echo " " . $row;
echo "<br />";
}

mysql_close();
?>

[nav33n]

Do you have mysql_connect and mysql_select_db in database.php ?