select Realm, AcctStartTime, AcctStopTime from radacct; ??? Did I miss something here?
=C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -----Original Message----- From: David Lubowa [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:29 AM To: [EMAIL PROTECTED] Subject: Query hey guys ..i got a question here i need to do a query which will let me pull 3 fields from a table; below is the table [snip] mysql> desc radacct; +--------------------+-------------+------+-----+---------------------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-------------+------+-----+---------------------+----- -----------+ | RadAcctId | bigint(21) | | PRI | NULL | auto_increment | | AcctSessionId | varchar(32) | | MUL | | | | UserName | varchar(32) | | MUL | | | | Realm | varchar(30) | YES | | | | | NASIPAddress | varchar(15) | | MUL | | | | NASPortId | int(12) | YES | | NULL | | | NASPortType | varchar(32) | YES | | NULL | | | AcctStartTime | datetime | | MUL | 0000-00-00 00:00:00 | | | AcctStopTime | datetime | | MUL | 0000-00-00 00:00:00 | | | AcctSessionTime | int(12) | YES | | NULL | | | AcctAuthentic | varchar(32) | YES | | NULL | | | ConnectInfo | varchar(32) | YES | | NULL | | | AcctInputOctets | int(12) | YES | | NULL | | | AcctOutputOctets | int(12) | YES | | NULL | | | CalledStationId | varchar(10) | | | | | | CallingStationId | varchar(10) | | | | | | AcctTerminateCause | varchar(32) | | | | | | ServiceType | varchar(32) | YES | | NULL | | | FramedProtocol | varchar(32) | YES | | NULL | | | FramedIPAddress | varchar(15) | | MUL | | | | AcctStartDelay | int(12) | YES | | NULL | | | AcctStopDelay | int(12) | YES | | NULL | | +--------------------+-------------+------+-----+---------------------+----- -----------+ 22 rows in set (0.00 sec) [/snip] now what i need from this table in one query that will give me all these: " Realm, AcctStartTime, AcctStopTime" how can i do this in one query!! and is it possible to set up a script that can do this for me auto anyone with any ideas all help is highly appreciated cheers David Ziggy Lubowa --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
