- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
I'm trying to run a python script from the cron but get the error "No module named requests" Traceback (most recent call last): File "testscript.py", line 2, in <module> import requests ImportError: No module named requests The script will run from the console but not through a cron job. I … | |
I've got 2 tables, basically this weeks stock list and last weeks. Each has around 25,000 SKU's. I'm trying to run a comparison programme to see where there are stock-outs i.e. SKU missing from the latest table. Table structures identical. Both about 20mb in size. Script is timing out so … | |
This is the second part of a script. It gets the EAN from the form in the first part. Where there are sales, it will show total number but if not I want to show a message to say "none" or "No Sales". Don't quite get the else/if errors. Could … | |
I'm trying to cleanse a db field which stores UK postcodes. Postcodes can be 7 or 8 characters long but they will always have a space character in the 4th position from the end. The last 3 will be 1 digit plus 2 letters. Customers on entering their address will … | |
I have a table which shows our top sellers and Weeks of Stock left. Its generated by joining an order db with a stock db. I'm struggling with try to capture the really fast movers. Here is the script SELECT a.EAN, a.SKU, a.Name, Sum(a.OrderedQuantity) Round(Avg(a.Price),2) as AvgPrice b.Quantity, round((b.Quantity/Sum(a.OrderedQuantity)),0) as … | |
This simple query is proving to be a problem for me as I'm missing something obvious. Its a query to show Sales by Market ($var2) by Month ($var1). Any pointers as to what I'm doing wrong. [CODE]<html> <head><title>Monthly Sales Rank </title> <LINK REL=StyleSheet HREF="style.css" TYPE="text/css" MEDIA=screen> <script src="sorttable.js"></script> </head> <body> … | |
I have a php/mysql/html table of results The query is [CODE]$result = mysql_query(' Select var1, sum(var2) round(Avg(var3),0) round(Min(Price),2), round(Max(Price),2), round(Avg(Price),2) as AvgPrice, Country, From table Where country = "Australia" Group By var1 having var3 > 5 Order By var3 DESC') or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($result); print "<table width=800 … | |
Not sure if this can be done in php or whether I should look at other alternatives. I'm trying to access 4 different sources of data to put on one page - Amazon API, Ebay, our sales data on one server and our inventory data on another server. (Historical reason … | |
Have 2 tables - one for new titles and the other for authors. I want to tag the "new titles" table with the "author" value if the author's name appears in list of new titles. As you can see from my code, I don't have a clue what is wrong … | |
What I want to do is to take the previous day's logfile, strip out the search phrases and insert these into a mysql db. Currently using Deep Log Analyser to manually lift the search terms, but I's appreciate some pointers as to how the parsing could be done by a … | |
Re:
Where do I save my data? I've been at this for hours!!!!! Where's Doc_Root located? | |
I have 2 fields in my db, the first is Title and the other StopList. If a StopList word appears in any of the Title names, I want to flag that item for deletion. Currently using a PHP array to do this but wanted to know if mysql could do … | |
Running php/mysql site where the db is constantly being changed with new products added, categories and prices changed all through php scipts. Just before it publishes the results to a static html file, there is a (my)sql file with product data that has been held "off table" so it cannot … |