Lorenz
|
| Posted: 05/21/2002, 2:23 AM |
|
HI, Nicole, you're here when I need help! :)
Thanks a lot, I have tried SQL custom queries, but ODBC I use don't like them.
I hope to try a solution by PHP. Can you help me?
Thanks again for your support!
|
|
|
|
Nicole
|
| Posted: 05/21/2002, 2:51 AM |
|
Lorenz,
please test queries against db and let me know do they work correct.
What do you mean:
< but ODBC I use don't like them
do you get incorrect results or any errors?
|
|
|
|
Lorenz
|
| Posted: 05/21/2002, 3:16 AM |
|
Here is my query :
SELECT Year,Field1,Field2,Field3,Field4
FROM Mytable
GROUP BY Year
This is the problem :
SQL Error ... Column not found Field1
if I cancel Field1 the same happen for Field2 and so on.
I need those Fields as they are keys.
Even if I write only :
SELECT Year
FROM Mytable
GROUP BY Year
the table is so long that webpage need 30 and more seconds to charge
I'm very confused ...
|
|
|
|
|
|
