Find content
Not Telling
hey clavid, I pretty much just added parens to the various MySQL queries that generate the product lists.
To troubleshoot where things are coming from I used php back traces and echo'd out the mysql queries that were being passed along to the various functions.
And I meant to say esp MrPhil who turned me on to the parens int he MySQL >.<
Latest News: (loading..)
Posts I've Made
In Topic: OOOLD osCommerce PHP 4 -> PHP 5
22 July 2011, 04:18
got it!!
in product_listing.php there was a variable $listing_numrows, which somehow was getting set before but wasn't now.
I got that set by tep_num_rows on $listing_sql and it works perfectly!@#
Thanks for the help all
exp kymation who put me on the right track w/ the parens
in product_listing.php there was a variable $listing_numrows, which somehow was getting set before but wasn't now.
I got that set by tep_num_rows on $listing_sql and it works perfectly!@#
Thanks for the help all
exp kymation who put me on the right track w/ the parens
In Topic: OOOLD osCommerce PHP 4 -> PHP 5
22 July 2011, 04:06
that helped, now its executing this SQL
Which returns 3 results, but for some reason I'm still getting "no products to list"
select p.products_image, p.products_model, p.products_id, p.products_name, p.products_price, s.specials_new_products_price, IFNULL(s.specials_new_products_price,p.products_price) as final_price from (products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = '716' order by p.products_model
Which returns 3 results, but for some reason I'm still getting "no products to list"
In Topic: OOOLD osCommerce PHP 4 -> PHP 5
21 July 2011, 20:55
Well I managed to get it to not display any errors, but now it doesn't display products either
Can I seriously not pay someone who has a better grasp of php/mysql to just tweak the code and make this work?
Can I seriously not pay someone who has a better grasp of php/mysql to just tweak the code and make this work?
In Topic: OOOLD osCommerce PHP 4 -> PHP 5
21 July 2011, 18:05
ahhh Kymatian, I will try to just replace that segment of code from a newer 2.x version of OSC, thanks
