manishkumar97 Posted September 29, 2008 Share Posted September 29, 2008 i dont know how to display products on default (home/front) page.....how can i write sql queries according to oscommerce syntax... can some body tell me simple sql query to fetch data from database.... help me.....please........ :( Link to comment Share on other sites More sharing options...
♥FIMBLE Posted September 29, 2008 Share Posted September 29, 2008 Hi On your Index.php find <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> and replace it with <td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td> Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
manishkumar97 Posted September 29, 2008 Author Share Posted September 29, 2008 thanks for ur reply......... i did wht u said bt it gave this error=>"1109 - Unknown table 'p' in field list select count(p.products_id) as total [TEP STOP]" actualy i am making product listing by editing default page ("C:\wamp\www\oscommerce-2.2rc2a\catalog\includes\languages\english\index.php") in text main. i put all html code in $all = array(); $all[] = define('TEXT_MAIN', '<table for product listing>'); bcoz i want particular design.... is it rite way to do this....? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.