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
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
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: [
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
"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
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
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