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 [EMAIL PROTECTED] On Sun, 19 Sep 2004 07:50:14 +0200, Sven <[EMAIL PROTECTED]> 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
