I think you are not considering all the cases.
Suppose your column is NULL for the first record but it has a non-NULL value
on the second record. So, why do you want your query to return nothing
whereas there are values in it?
Col1Col2Col3
For the last Auto-increment
SELECT LAST_INSERT_ID() FROM tblName;
For the last row data:
SELECT col1, col2, col3, col4 FROM tblName ORDER BY SortedColumn
LIMIT 1
I don't know what you are looking for exactly.
Explain and we will try to help though I am not an expert.
Thanks
I forgot to add DESC for the ORDER BY clause:
... ORDER BY SortedColumn DESC LIMIT 1
Thanks
Emery
- Original Message -
From: Director General: NEFACOMP [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, September 28, 2003 19:05
Subject: Re: [PHP-DB]
From a design standpoint...I would have one table named ratings and
another named hits and link them using a key from the lyrics table.
Shadow
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[EMAIL PROTECTED] wrote:
How can I authenticate users against the database using NTLM instead of
Basic Authentication?
Instead of manually logging in, each user's NT account will automatically
allow or deny access.
Is there somewhere in the php.ini file where I have to enable the NTLM
module?
ed anderson wrote:
When running a PHP script (program), Mozilla stops displaying the web page
after using about 5mb of disk space.
Based on the percentage of source processed, I estimate I need about 200mb
of disk space. Any method or procedure where all the data processed and
saved would be