display data stored in database

[yllai]

i have a few records in my phpMyAdmin database..now i want to display out all the records. i tried to code the sql statement for query all the record, following is my code:-

*******************************************************
$result=sql_query("select file_name, file_dept, file_desc from file",$dbi);
$row=sql_nnum_rows($result,$dbi);
for($x=0;$x<$row;$x++){
$myrow=sql_fetch_array($result, $dbi);
$file_name=$myrow["file_name"];
$file_dept=$myrow["file_dept"];
$file_desc=$myrow["file_desc"];
echo"$file_name&nbsp;&nbsp;$file_dept&nbsp;&nbsp;$file_desc<br>";

*******************************************************

but i receied an error message as "Fatal error: Call to undefined function: sql_query() in /var/www/html/Login/search.php on line 40
"....how do i define the function? where can i get these type of example? any suggestion?

thanks....

[johnerazo]

i have a few records in my phpMyAdmin database..

phpMyAdmin is not a database. PHPMyAdmin is a visual system for the managementof a MySQL database

PHP has built in functions to handle/communicate with MySQL database. Most of its commands are prefixed with 'mysql_'.

//------------[ UNTESTED PHP CODE ]-------------------
$result = mysql_query("select file_name, file_dept, file_desc from file",$dbi);
while ($myrow = mysql_fetch_array($result, MYSQL_ASSOC) {
 $file_name = $myrow['file_name'];
 $file_dept = $myrow['file_dept'];
 $file_desc = $myrow['file_desc'];
 echo"$file_name&nbsp;&nbsp;$file_dept&nbsp;&nbsp;$file_desc<br>"; 
}