Powered by InterCreatives | Site Map
Search:
NewSourceMedia Popular Tutorials: PHP Javascripts Web Hosting
SoftwareTutorials
CATEGORIES
Job Listings
 
Home / PHP / MySQL / Database

Query Select From a Database

Published by: Alex


1) Basic Query

SELECT * FROM table

2) Limit the Display of a Query

This displays only 10 rows of data

SELECT * FROM table LIMIT 10

This displays only 10 rows of data but starting from 0

SELECT * FROM table LIMIT 0,10

3) Order the Display of a Query

Alphanumerically order rows by a field using either Ascending (ASC) or Descending (DESC).

SELECT * FROM table ORDER BY field_id ASC


Next PHP Page:
1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  [20]  21  22  23  24  25  26  27  28  29  30  31  32 





Hosting by iPowerWeb.com - 50 Gb for $7.95