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.