I have a database and under that database I have 2 tables. Log (which is an event reporting log)
under Log there is field called 'logccsd' CCSD (which is what identifies our circuits) under CCSD there is a field called 'CCSD' When I use my mysql statement I pull all records that match my criteria (In mysql) SELECT ccsd.CCSD, ccsd.Description, ccsd.Impact, ccsd.Isolation FROM ccsd, log WHERE ccsd.CCSD = log.logccsd It defaults to the last record of CCSD automatically. What I need it to do is pull from the last record of log where ccsd.CCSD = log.logccsd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php