You're probably going to need to create some indexes on your tables. If you have no indexes, MySQL can only do a full tablescan.
See the manual for the syntax of the statement that creates an index. Rhino ----- Original Message ----- From: "Sven" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 19, 2004 1:50 AM Subject: help!!!!!!!!!! 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]