[SOLVED] selecting the highest number in the database

[syntax101]

help

 

how do you get the hightst number in the database

 

ex.

 

 

order_num

1

4

10

2

3

4

6

7

 

 

RESULT

10

[syntax101]

i tried to use

 

$sql = 'SELECT max(order_num) from orders ';  - no result

 

but it wont work in php

 

then i tried it in phpyadmin

 

select max(order_num) from `orders`   - result ok

 

it works

 

can anybody help me.

[syntax101]

i already got it

 

$sql = 'SELECT order_num from orders where order_num = (Select max(order_num) from orders)';

 

thanx to the moderator who taught me how to use select in a select data from table where data = (select ..)

[fenway]

Actually, you don't need a subselect, it's just a single table:

 

SELECT max(order_num) from orders