Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2003022

[PHP] Multiple Data Requests From: Randum Ian (ian <email protected>)
Date: 02/24/03

Hi guys,
 
Wonder if you can help me with this.
 
I have a "recording_global" table which has "recording_global_id" in and
"dj_global_id".
 
I want to be able to sort the "recording_global" table alphabetically by
dj name which I need to find from the "dj_global_id" table referencing
it from the ID in the "recording_global" table and enter it into a
script.
 
I have been banging my brain all afternoon but am no nearer to the
solution. Below is the code I got upto before I realised I was stuck.
 
$sql = "SELECT * FROM recording_global ORDER BY recording_global_name
WHERE recording_global_name LIKE a%";
 
Any help hugely appreciated! Ian.