[PHP-DB] Re: Relational database

2002-03-21 Thread Ron
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 cr

RE: [PHP-DB] Re: Relational database

2002-03-21 Thread Rick Emery
Huh -Original Message- From: Ron [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:30 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Relational database But can you do that in PHP before you pull info from it -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] Re: Relational database

2002-03-21 Thread Rick Emery
What do you mean "last record in a table"? What are you REALLY trying to do here? Do you want the last entry made according to a specific criteria? -Original Message- From: Ron [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:20 AM To: [EMAIL PROTECTED] Subject: [

[PHP-DB] Re: Relational database

2002-03-21 Thread Ron
But can you do that in PHP before you pull info from it -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Relational database

2002-03-21 Thread Hugh Bothwell
"Ron" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Is there a way under mysql to identify the last record in a table so that I > can pull information that I need from that entry. Um... sort backwards then use the first record (ie LIMIT 1)? -- PHP Databa

[PHP-DB] Re: Relational database

2002-03-21 Thread Ron
Is there a way under mysql to identify the last record in a table so that I can pull information that I need from that entry. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Relational database

2002-03-21 Thread Ron
SELECT ccsd.Description, ccsd.Impact, ccsd.Isolation FROM ccsd, log WHERE ccsd.CCSD=log.logccsd I have tried this and the code and now I get to where it include variable from the table, but it is the wrong record??? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: htt