[osCmax v2.5x] i need to customize in php

[saad_sinpk]

i have make one column in product and picture box table so i need to make some change in main page can u help me i need to know where is php code for top picture i have attach one picture check that, i have mark in 2 colors red is main product show and other is slid image, i need to know where select statement use for this 2 table, i need to add this code WHERE MY_COLUMN = 1 then show this product other wise no, and other thing is that that i need to add banner on right and left top, and in footer please can u tell me where is file for that also , any ways i am using oscmax v2.5beta3
sorry here is image

[ridexbuilder]

RTFM

[saad_sinpk]

what do u mean by rtfm ?

[ridexbuilder]

u??? d'uh, wiki

[saad_sinpk]

ok sorry i think in this u can help me i am getting this error in category page
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_CATALOG_DISPLAY_SEARCH_RESULTS' at line 1

select p.products_model, m.manufacturers_name, pd.products_name, p.products_image, pd.products_short, p.products_id, p.manufacturers_id, p.products_msrp, p.products_price, p.products_tax_class_id, p.products_featured, p.products_quantity, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c left join categories c using(categories_id) where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '32' and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', c.categories_hide_from_groups) = 0 order by pd.products_name limit -0, MAX_CATALOG_DISPLAY_SEARCH_RESULTS
and this error in search
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_CATALOG_DISPLAY_SEARCH_RESULTS' at line 1

select distinct p.products_model, m.manufacturers_name, p.products_image, m.manufacturers_id, p.products_quantity, p.products_featured, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, NULL as specials_new_products_price, NULL as final_price from products p left join manufacturers m using(manufacturers_id), products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%test%' or p.products_model like '%test%' or m.manufacturers_name like '%test%' or pd.products_description like '%test%') ) and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', categories_hide_from_groups) = 0 order by pd.products_name limit -0, MAX_CATALOG_DISPLAY_SEARCH_RESULTS

[TEP STOP]

[blackhawk]

I think he meant, read the friendly manual

[saad_sinpk]

ok i will read that but can u tell me why i am getting this error i don't think i will answer of this error in wiki or friendly manual

[blackhawk]

Trouble understanding you. Explain in a simple way what is your goal with the blue highlighted section you have in the image? What do you want there?

[saad_sinpk]

see i have make new column in products database and slideshow databases table, now i want that if that column = 1 then show that product and slideshow otherwise no can u tell tell me where i add that code, in blue line there is slideshow and in red there is product

[pgmarshall]

saad_sinpk,

You really need to read the wiki (properly) and spend a bit of time working out how the code works before posting almost unintelligible questions about your store setup.

You also need to make sure that when you are running off the SVN (which you are) that you update your database (every time) - either reinstall all patch through phpMyAdmin.

MAX_CATALOG_DISPLAY_SEARCH_RESULTS is a new config setting introduced to split the max result count between admin and catalog - so if you don't upgrade your dbase whilst running SVN you are going to get a whole load of errors.

Spend some time working it out for yourself before posting ... you will learn more in the long run and be able to build a better store.

Or - simply wait for the stable release ...