Multiple Data Requests
| From: | Randum Ian | Date: | Mon, 24 Feb 2003 15:55:55 +0000 |
| Subject: | Multiple Data Requests | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-136921@lists.php.net to get a copy of this message | ||
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.