Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Andrew Burnell
  1. Hi everyone... I don't know whether or not this is helpful, but I've spent hours trying to do it and it is so simple... (I could be repeating something that is already covered here, excuse my stupidity) I wanted to make the specials in the body on my mainpage random, similar to what a lot of people are doing with their new products boxes... The trouble was, while the display of the products selected from the database was random, the actual selection of them was not. So for example the code would select 10 products, and then display those 10 products randomly. I wanted it to select 10 random products and then display them. // start random new products $new_products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and s.status = '1' order by rand() limit " . MAX_DISPLAY_SPECIAL_PRODUCTS); // end random new products You will notice on the last line I have chaned what is normally "order by s.products_id desc" or "order by p.products_date_added desc" to "order by rand()" That is all you need to do to get random queries from the database! I hope this helps someone I had been trying to work it out for ages!
  2. ajats

    fast easy checkout

    If anyone else has gotten this problem the solution is here: http://www.oscommerce.info/kb/osCommerce/G...on_Problems/198 In my case I had the actual payment_confirmation.php file in the includes/languages/english section instead of the mini one.
  3. ajats

    fast easy checkout

    I had that exact same problem... Mine was coming from the /includes/form_check.js.php if that helps...
  4. ajats

    fast easy checkout

    Hi all... I set up the fast easy checkout at my website, http://www.smartgoods.com.au (live store). I didn't install the combined admin/login feature as I already had that going from another contribution. The FEC was working perfectly and then I caught it doing this: (http://smartgoods.com.au/checkout_confirmation.php): Fatal error: Cannot redeclare tep_db_connect() (previously declared in /home/sma3067/public_html/includes/functions/database.php:13) in /home/sma3067/public_html/includes/functions/database.php on line 13 Any ideas... I've taken off the files and put them back on again with no luck. It was all working fine before... Cheers, Andrew P.S I've created a test account username: test@test.com.au password: test01 if you want to log in and see.
  5. ajats

    [Cntribution] Specials Automation

    I ran the SQL line in the install text file to add the valid from date to MySQL... I copied over the required files and made the required changes to categories.php. If I add specials in through the specials window the normal way, it puts them on special straight away and ignores the start date... If I add specials through the inline editor when adding products it does nothing at all! Any assistance would be appreciated. This would be a really valuable contribution for my store as a lot of times the product is not coming on special for several weeks... Cheers, Andrew www.smartgoods.com.au