¡@

Home 

php Programming Glossary: product_db

MySQL select random row with JOIN from two tables

http://stackoverflow.com/questions/4209886/mysql-select-random-row-with-join-from-two-tables

reduce the time it takes to run the query. I have 2 tables product_db unique_id index image url_title status index product_page id.. page_id index What I want to select is a random image from product_db where status 'Online' and the product must be in page id 3 product_db.. where status 'Online' and the product must be in page id 3 product_db has over 90 000 products and product_page has over 150000 rows...