mysql

members

id	name	age
1	alex	21
2	amanda	19
3	allan	20
4	jacki	18

mysql insert
mysql_query("INSERT INTO members (name,age) VALUES('jessica', '23' ) ")
or die(mysql_error());

id	name	age
1	alex	21
2	amanda	19
3	allan	20
4	jacki	18
5	jessica	23

mysql select

mysql_query("SELECT name FROM members") or die(mysql_error());

name

alex

amanda

allan

jacki

mysql where

mysql_query("SELECT * FROM members" WHERE name='allan') or die(mysql_error());

id	name	age
3	allan	20

mysql oreder by

mysql_query("SELECT * FROM members" ORDER BY age DESC) or die(mysql_error());

id	name	age
1	alex	21
2	allan	20
3	amanda	19
4	jacki	18