Hello,
Try
SELECT messages.message_id, messages_1.message_id
FROM messages as messages_1
INNER JOIN connections
ON messages_1.message_id = connections.child
INNER JOIN messages
ON messages.message_id = connections.parent
ORDER BY messages.message_id, messages_1.message_id
or
SELECT messages.me
Funtion name is strtoupper()
See PHP4 manual, function reference, string functions.
Regards
JC
- Original Message -
From: "Hoo Kok Mun" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 11, 2001 11:00 AM
Subject: upper and ucase
> Hi,
>
> I am using mysql-3.22.32 with p
