Sven,
This warning is telling you there your query is going to execute
very slowly. The EXPLAIN that it talks about is mentioned in the
manual here:
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
You should also search the manual for sections on query optimization
and index usage.
Here is another document that will help you get help online easier.
http://www.catb.org/~esr/faqs/smart-questions.html
--
Eric Bergen
eric.bergen@stripped
On Sun, 19 Sep 2004 07:50:14 +0200, Sven <local.host@stripped> wrote:
>
>
> Warning: mysql_query() [http://www.mysql.com/doc]: Your query requires a full
> tablescan (table bb1_designelements, 78 rows affected). Use EXPLAIN to optimize your
> query.
>
> I get this error on every products i tested
>
