Code2Design.com

User login

The Layout

Programming

Graphic Design

Resources

Navigation

C2D Projects

Unsystematic Affiliates

Pixel2life Open Web Design Photoshop Star XeonFX 

Change Language

Who's online

There are currently 0 users and 31 guests online.

ORDER BY clause

ORDER BY has another clause called "ASC" and "DESC" which take whatever column you specify (like "id") and alphabetically order it.

<?php
mysql_query
('SELECT * FROM `table` ORDER BY `id` ASC');
?>

Also, don't use double quotes (") when working with strings as it takes longer. Second, make sure to sanitize your sql (mysql_real_escape_string) or you WILL get hacked! Third, don't set mysql_query() to a string - just do something like:

<?php
$query 
'SELECT `name`, `desc`, `poster`, `id` FROM `topics` WHERE `id` = \''mysql_real_escape_string($_GET['tid']). '\' ORDER BY `id` ASC';

//If there is a problem
if(!mysql_query($query)) { die 'MySQL Error:'mysql_error(); }

//on with the code
?>


Reply

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <br> <br /> <h3>
  • Lines and paragraphs break automatically.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • You can use BBCode tags in the text, URLs will be automatically converted to links
More information about formatting options



Like what you see?

Why not add more? C2D is looking for other Christian Web Masters who would like to help write articles for this site. If you have expericance in FLASH, CSS/HTML, PHP/MySQL, PhotoShop/GIMP, Blender, Javascript, or just General Design - our users would love to hear what you have to say. Contact Us

delicious   digg   reddit   magnoliacom   newsvine   furl   google   yahoo   technorati