At 12:20 PM +0100 12/13/07, Zoltán Németh wrote:
2007. 12. 12, szerda keltezéssel 20.13-kor tedd ezt írta:
> I would like to create a temporary table to perform searches.
From my main table, I need to exclude records that have certain
fields that are null or empty; and then sort the final result.
why do you need a temp table for that?
select * from blah where not isnull(checkfield) and checkfield <> ''
order by someotherfield
Zoltán:
Ok, here's the problem.
I have a table with over 5000 records.
There is no index (not my dB) and the records are not complete.
There is a numeric product_id field, but in the dB this is not in sequence.
Some records have a product_id, but no product_name.
I need to travel the dB showing each item in
order (product _id) and excluding those products
that have no product_name.
That sounds simple enough, but currently for each
step the entire table gets sorted (unless I'm
doing it wrong).
I was thinking that I could:
1. Create a temporary table.
2. Sort the table once.
3. Remove the records that have no product_name
4. And then just travel the temporary table for the duration of the script.
5. Drop the table when done with it.
Now, what's wrong with my thinking?
Cheers,
tedd
--
-------
http://sperling.com http://ancientstones.com http://earthstones.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
