Networking, Programming and Graphics Tutorials
Home >> Development >> WEB Programing >> PHP >>

select * from PHP [2/2]

In next example we will extend the query to more complex and specific query.

This query will return you all male personal, ordered by age and will start from old to young mans.

<?php
$query="select `id`, `name` from `staff` where `sex`='male' order by `age` desc";
$result=mysql_query($query);
?> 
And the above example will return you:

ID Name Sex Age
4 Peter Trump Male 46
1 John Smith Male 33
Rate this tutorial:                    
Networking, Programming and Graphics Tutorials - select * from PHP [2/2] - Networking, Programming and Graphics Tutorials

Need a specific tutorial? Do not hesitate and submit a request!
Related Tags: select inside mysql select query  query mysql select dalam select  select the last select php code script  select from select query mysql  twee select in select mysql  in select select query  php mysql select in select  mysql select in select  mysql select as select  select * from php  SELECT * FROM php  select * from "php  "select * from php  SELECt * from +PHP  select where AND php  "SELECT FROM" + php  select * from, php  select * from+php  select * from php  select where and php