Order by name

Expand Post »

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

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);

sam1

Reputation Points: 10

Solved Threads: 1

Posting Whiz

Offline

300 posts
since Nov 2004

Permalink

Mar 17th, 2009

Re: Order by name

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.

almostbob

Reputation Points: 562

Solved Threads: 368

Posting Maven

Offline

2,970 posts
since Jan 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: unable to connect to MYSQL via PHP

Next Thread in PHP Forum Timeline: If Statement Error

DaniWeb Message

Cancel Changes

User Name
Password