DaniWeb Forum Index > Web Development > PHP

Order by name

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2004

Posts: 259

Reputation: sam1 is an unknown quantity at this point

Solved Threads: 1

sam1

Offline

Posting Whiz in Training

Order by name

Mar 17th, 2009

hi,

i have this script, which i want to order by name. but when i say order by name asc at the end i get error:

here is the bit i am changing

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$genre_id = $_GET['id'];   
 
 $items = ITEMS_PER_PAGE; 
 
 if(isset($_GET['page']))
 {
    $offset = $_GET['page']; 
    $offset *= $items; 
    $query = 'select * from artist where genre_id = '.mysql_real_escape_string($genre_id)." limit $offset,$items"; 
 }
 else  
 {
    $query = 'select * from artist where genre_id = '.mysql_real_escape_string($genre_id); 
 } 
 
 $allArtists = mysql_query($query);
$genre_id = $_GET['id'];   
 
 $items = ITEMS_PER_PAGE; 
 
 if(isset($_GET['page']))
 {
    $offset = $_GET['page']; 
    $offset *= $items; 
    $query = 'select * from artist where genre_id = '.mysql_real_escape_string($genre_id)." limit $offset,$items"; 
 }
 else  
 {
    $query = 'select * from artist where genre_id = '.mysql_real_escape_string($genre_id); 
 } 

 $allArtists = mysql_query($query);

•

Join Date: Jan 2009

Posts: 1,396

Reputation: almostbob has a spectacular aura about

Solved Threads: 170

almostbob

Offline

Nearly a Posting Virtuoso

Re: Order by name

Mar 17th, 2009

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$genre_id = $_GET['id'];   
  $items = ITEMS_PER_PAGE; 
  if(isset($_GET['page']))
 {
    $offset = $_GET['page']; 
    $offset *= $items; 
    $query = 'select * from artist where genre_id = '.mysql_real_escape_string($genre_id)." limit $offset,$items"; 
 }
 else  
 {
    $query = 'select * from artist where genre_id = '.mysql_real_escape_string($genre_id); 
 } 
 $allArtists = mysql_query($query);
$genre_id = $_GET['id'];   
  $items = ITEMS_PER_PAGE; 
  if(isset($_GET['page']))
 {
    $offset = $_GET['page']; 
    $offset *= $items; 
    $query = 'select * from artist where genre_id = '.mysql_real_escape_string($genre_id)." limit $offset,$items"; 
 }
 else  
 {
    $query = 'select * from artist where genre_id = '.mysql_real_escape_string($genre_id); 
 } 
 $allArtists = mysql_query($query);

[code=php] tags, syntax highlighting

select * doesnt allow "us" to see the column names, Is there a column "name"
$items = // are you sure about this definition it doesnt look right
$items = $_GET['ITEMS_PER_PAGE']; // looks more usual to me
what is the exact error message
and where did you put the order by clause in this code

Last edited by almostbob; Mar 17th, 2009 at 11:08 am.

Failure is not an option It's included free, you don't have to do anything to get it
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it

Please mark solved problems, solved