How to display records from database in php?

liniey rahman

12y1.8kPHP

Hello, sir.

i need your help.
im using php, want to display hotels record in table from database.
the records are displayed in order by "bestprice", the lowest price will be upper.

plss..help me.

Thanks,
Liniey

----------------------------------------------------------------------------------------

Untitled Document

global $wpdb;
$result = $wpdb->get_results ( "SELECT * FROM cyberjaya" );
foreach ( $result as $print ) {
echo '';
}
?>

Hotel Name	Stars Rating	Agoda (RM)	Asiarooms (RM)	Booking (RM)	Expedia (RM)	Best Price (RM)
' $print->hotelname.'

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nipun Tomar12y ago
Hi,

You may read and try the below links:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01776.1600/doc/html/san1357754973555.html

http://www.w3schools.com/php/php_mysql_select.asp

Thanks
Satyapriya Nayak12y ago
SELECT * FROM test ORDER BY price ASC LIMIT 10