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

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 unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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


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 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 

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 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 

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: http://www.php.net/unsub.php