Search found 273 matches

by facets
Sun Apr 12, 2009 1:37 am
Forum: PHP - Code
Topic: php code works on site A but not site B -- both PHP sites
Replies: 7
Views: 411

Re: php code works on site A but not site B -- both PHP sites

are the permissions different on the 'results' directory on each host.
by facets
Sat Apr 11, 2009 9:58 pm
Forum: PHP - Code
Topic: Creating an Item Database
Replies: 5
Views: 203

Re: Creating an Item Database

sounds like you could get away with a single table (as long as you can access the other tables for reading)

member_id,item_description_id(or name), qty

At a pinch see if you can access your database with a query browser or phpmyAdmin it may help you visualise the data.
by facets
Sat Apr 11, 2009 9:53 pm
Forum: PHP - Code
Topic: php code works on site A but not site B -- both PHP sites
Replies: 7
Views: 411

Re: php code works on site A but not site B -- both PHP sites

there could be many differences between your hosts. diff the output of phpinfo() on both hosts. you're looking for php version differences and libraries that are missing etc. that will get you started but we'll need more information if you expect any assistance.
by facets
Sat Aug 02, 2008 11:27 pm
Forum: Linux
Topic: Bash script to check Raid status
Replies: 8
Views: 5442

Re: Bash script to check Raid status

Have you thought about using mdadm to monitor your RAID? It does exactly what you are trying to script.
http://man-wiki.net/index.php/8:mdadm#MONITOR_MODE

Will.
by facets
Sun Aug 12, 2007 4:45 am
Forum: Databases
Topic: Getting sales/delivery stats from DB.
Replies: 8
Views: 945

Update.. Now using this code, but it's not finding any ret.total or del.total. Any ideas? $queryTotal = "SELECT date_format(state.statement_date, '%m') as Month, SUM(state.total) AS stateTotal FROM statements state LEFT OUTER JOIN ( SELECT date_format(del.date, '%m') as Month, del.statement_id,...
by facets
Sun Aug 12, 2007 2:25 am
Forum: Databases
Topic: Getting sales/delivery stats from DB.
Replies: 8
Views: 945

One step closer :) $queryTotal = "SELECT id AS statement_id, date_format(state.statement_date, '%m') as Month, SUM(state.total) AS stateTotal, (SELECT date_format(ret.date, '%m') as Month, SUM(ret.total) AS retTotal FROM returns1 ret) AS Returned, (SELECT date_format(del.date, '%m') as Month, S...
by facets
Sun Aug 12, 2007 1:38 am
Forum: Databases
Topic: Getting sales/delivery stats from DB.
Replies: 8
Views: 945

Thanks for the help so far! I have simplifies my code (with your help) to the following. I have 3 questions now.. 1. How could I workout the sales for each month. (deliveries - returns) 2. How do I merge this into one statement? 3. If there are no deliveries $query = "SELECT date_format(ret.dat...
by facets
Sat Aug 11, 2007 10:33 pm
Forum: Databases
Topic: Getting sales/delivery stats from DB.
Replies: 8
Views: 945

Here is the statements, returns and return_items tables. The deliveries table is the same setup as returns. I have inherited this database so the layout may *not* be the best layout, please be gentle. Statements table -> id, client_id, statement_date, due_date, total, notes Returns -> id, client_id,...
by facets
Sat Aug 11, 2007 7:15 pm
Forum: Databases
Topic: Getting sales/delivery stats from DB.
Replies: 8
Views: 945

Getting sales/delivery stats from DB.

Hi, Not sure if this is the correct forum for this question but here goes.. I'd like to extract sales, deliveries and returns statistics from my database for the past 12 months and display in a graph. I'm using jpgraph and have that side organised but i'm unsure on the best way to align the data. Th...
by facets
Sat Jul 21, 2007 10:22 pm
Forum: Databases
Topic: MySQL VIEWS - Different results
Replies: 1
Views: 547

hmm, I removed DISTINCT in the create VIEW script and it works as expected. Not sure why yet.
by facets
Sat Jul 21, 2007 10:00 pm
Forum: Databases
Topic: MySQL VIEWS - Different results
Replies: 1
Views: 547

MySQL VIEWS - Different results

Hi All, Views are behaving weirdly for me. Can anyone see what I'm doing wrong? Here's the view : DROP VIEW returns; CREATE VIEW returns AS SELECT DISTINCT product_id, SUM(amount) AS amount, return_date, price, returns_table.client_id, returns_table.date, returns_table.statement_id, returns_table.to...
by facets
Thu Jul 19, 2007 4:36 am
Forum: Linux
Topic: Transfer large files via ftp
Replies: 5
Views: 3194

also worth checking lftp. it can 'automatically' split the file up and open 5 connections. Although it may flood your network.

lftp ftp.server.com -u name,password
pget -n5 source dest

hth.
Will
by facets
Wed Jul 18, 2007 5:22 am
Forum: Linux
Topic: How to set custom screen resolution
Replies: 9
Views: 6793

Hi, Something like this should get you going. You may need to edit the VertRefresh and HorizSync, check your manual or the web for those. Also checkout your /var/log/Xorg.log for errors. If all else fails google "nvidia xorg hdtv" you could also add your Graphics card and TV models. Sectio...
by facets
Tue Jul 17, 2007 6:05 am
Forum: Databases
Topic: XML vs MySQL
Replies: 1
Views: 551

XML vs MySQL

Hi, I am embarking on a mission to create statistics for a sales database. I am currently using PHP to extract data from the DB, manipulate the array, then create a XML file for graphing purposes. This method seems rather slow. My question is, would outputting all 'related' data to XML then manipula...
by facets
Tue Jul 17, 2007 5:56 am
Forum: Linux
Topic: How to set custom screen resolution
Replies: 9
Views: 6793

Please post your xorg.conf file.
What video card are you using? Do you have the latest drivers installed?

Will../