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
Emer
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
ive a table called 'lyrics' which is the main content on my site, song
lyrics. im thinking of introducing rate this lyric and all that kind of
stuff into the site. would it be better, from a design point of view, to
create a second table for lyrics ratings and hits or just add a 'ratings'
and 'hits
>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?
Mark
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 appr