In message <[EMAIL PROTECTED]>, Derek Nugent <[EMAIL PROTECTED]> writes >Thank you 2 guys mega amounts. > >The error is gone > >The only problem now is it's bringing up all the records in the database and >not >stopping.
SELECT... ... LIMIT 5? You have a counter, set to 0, and incremented, but never read. But this is (probably) not correct. If you want 5 records, and there are 20,000 in the database, why bring back all 20,000 then only use 5? You should only ever bring back what you need, and no more. For speed. >Where are you guys from? > >I'm currently in Scotland. Southern Spain (see below <G>) -- Pete Clark Sunny Andalucia http://www.hotcosta.com/comm_1.htm The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/php_mysql/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
