Try it like this --
SELECT @BF:=Date FROM Results WHERE GameID=1 ORDER BY Date ASC LIMIT
1;
SELECT @BL:=Date FROM Results WHERE GameID=1 ORDER BY Date DESC LIMIT
1;
SELECT @BF AS BF, @BL AS BL;
"Mariusz Muszalski" <[EMAIL PROTECTED]> wrote:
Look at this MS SQL:
Declare @BF char(10)
Declare @BL char(10)
SET ROWCOUNT 1
Select @BF=Date From Results Where GameID=1 Order by Date ASC
Select @BL=Date From Results Where GameID=1 Order by Date DESC
Select @BF As BF, @BL As BL
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php