Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

k0mplik8ed

Pioneers
  • Posts

    14
  • Joined

  • Last visited

Everything posted by k0mplik8ed

  1. Thanks for your response, I just commented them out thinking it would work. About the looping, if i run it in simulation mode it still only sends me the email should i put it in production and see where it sends it? Right now I am still testing and have 3 different emails and no customer emails so I don't have to worry about sending it to them. Thank you again
  2. Hi Cord, I realize this is new, so I just want to tell you the errors I get. I get the above error so I change the code to : //count how many emails to send $count_queryleft="SELECT count(*) as count FROM subscribers WHERE customers_newsletter=" . MAILBEEZ_BULKMAIL_CUSTOMERS . ""; //$countleft=mh_db_query($count_queryleft); $sentleft = tep_db_fetch_array($count_queryleft); //while($rowleft = mh_db_fetch_array($countleft)){ //$sentleft=$rowleft['count']; //} //count how many emails have been sent $count_mailed="SELECT count(*) as count FROM mailbeez_tracking WHERE iteration='50'"; //$countmailed=mh_db_query($count_mailed); $mailed = tep_db_fetch_array($count_mailed); //while($rowmailed = mh_db_fetch_array($countmailed)){ //$mailed=$rowmailed['count']; //} Im not sure if that will work or not, I think its just a matter of getting the total # & the # sent? Another error is that it just loops through the first customer it finds and keeps sending them the email... Thanks, Judy
  3. Hi Cord, Great contribution! I haven't used it yet but I am sure I will love it when I get everything ready! I just installed bulkmail and this is the error I get when I "list recipients" my sql is not that great 1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause SELECT customers_newsletter, COUNT(customers_email_address) FROM customers WHERE customers_newsletter=1 I also have newsletters and subscribers on my site, so that unregistered users can sign up for the newsletter and that information is installed in a seperate table... I am thinking of how to: get customers from --customers table get emails -- from subscribers table ( just emails I don't require names) merge together if name is null { //do nothing}else {echo name} I know this isn't correct coding just a thought if I get this to work I will send you my new bulkmail.php so maybe you can intergrate it...? I think its good to let non-reg users sign up for emails. Any Ideas on that above error? Thanks
  4. Just wanted to say thanks you rock!! I struggled with this all day and decided to look here and found your solution, wish I looked here first... Thanks!!
  5. I do not know if this will help you or not:unsure:, but there is a small problem with the way I did it, All I did was put Limit 1000 at the end of each select statement that called all the products. and say I needed to get the 1559 product, I would put Limit 1000, 1000 at the end, that means give me 1000, start at the 1000th product---now where this is a problem, say you wanted product id 599 to x-sell to product id 1698 well then youd have to go in and make the correct limits at each statement, now this wasnt a problem for me because most the products that needed to b x-selled are close together, and maybe yours are too, the main benifit to this x-sell admin is you can see what you are x-selling but if you have 5000 products you probably know without seeing whats needs x-sold so you can always do it how I really did it, once I put the limit statement in and x-selled a few things I seen how the table worked, like what went in what column etc, and I did a search on my spreadsheet for the model # copied the id directly into the table through phpmyadmin, and basically just entered the information into the table without using the admin... hopes this helps Judy PS Sorry it took so long I was away for Thanksgiving
  6. that wouldnt help me either, unless there was a text input box where u typed the model # of the item you wanted to cross sell it to... This is something I will work on, and let you know as I get it updated... If anyone who knows php better than I wants to take a shot at it, we all would apreciate it. Judy
  7. I wonder if in the products area of admin there could be a link, cross sell this product, now this would only be benificial to people who don't cross sell alot. For instance we sell knives so I only wanna cross sell the knives and sheaths that go together and there isn't that many, but back on subject, and when they click the link it says select "All these things" where products_id=var_id, as you can tell I dont know my php good enuff to right exactly what it should say. but I can cut some code up to figure out what I want lol Judy
  8. Ok I put LIMIT 50,150 at the end of the first select and got the 150-200 rows!! so all I have to do is figure out how to make it automatically figure out what the last 50 I veiwed were :-) But I am for now just going to do it manually, so to anyone out there who has too many products and it won't list them all, here is a manual fix! THANKS ADAM!!!!!!
  9. Couldn't I use the split page results class? Thanks, Judy
  10. You have an error in your SQL syntax near '"select a.products_id, b.products_name, b.products_description, ". "a.products_q' at line 1 that is the error I got when I put in your code, so I straightened the code out to "SELECT b.language_id,a.products_id, b.products_name, b.products_description,a.products_quantity, a.products_model, a.products_image,b.products_url, a.products_price FROM products a,products_description b WHERE b.products_id = a.products_id AND b.language_id = 1 ORDER BY a.products_id; myphpadmin gave me resuts none of the selects gave me any errors.. I also just read your post about the amount of products I have. Maybe I can put select row $first_row through $last_row or something and have it only show 50 or less per page... I will let you know Thanks, Judy
  11. My default language id is 1, and I don't use any other languages. I did try to copy over the new code but it still didnt work. Could it be that I have to many products? we have 8000+ products. The appication top says I am running --> define('PROJECT_VERSION', 'osCommerce 2.2-MS2-CVS'); maybe the fault is mine for thinking it is compatable. Thanks, Judy
  12. Ok this is really confusing. I downloaded the Nov 17th release of x-sell, I installed it into the admin section of my site, when I click the link under the catalog box, the page loads the header and column left, but runs into an error, as no more of the page is shown not even the footer. I installed the sql that creates the tables also. if I comment out the following: /* Multiple Language fix --- [email protected] <mailto:[email protected]> $query = "SELECT b.language_id,a.products_id, b.products_name, b.products_description,a.products_quantity, a.products_model, a.products_image,b.products_url, a.products_price FROM products a,products_description b WHERE b.products_id = a.products_id AND b.language_id = 1 ORDER BY a.products_id;"; */ the page loads but ofcourse it doesnt connect to the databse. Giving me no information. But my point is it leads me to believe that there is an error either in the sql or the function general_db_conct($query_1) itself, is anyone else expeirencing(sp?) this problem and can anyone help me? There are no errors reported on the page or my error logs. Thank you all for your time and these great contributions! Judy
×
×
  • Create New...