heavencore

hi, i have a php site, sat on a mysql database works fine, but we want to integrate stock information which is already stored in a sage database on the clients server. He is using sageline 50, V.12, yet we dont have a clue what to do, does sageline sit on an mssql database for example? How can this be accessed via php? is there any software titles we have to install on the server to make the sageline database available over the net? (the site is stored off-site on a server farm and would need to access the sage database remotely, eg; install a webserver on the sage server so it could be accessed remotely etc? my main problem here is lack of knowledge in terms of how sage stores data. Any help or links to articles would be VERY gratefull, cheers Regards HC

length() may not be accurate, i think you might mean char_length() ? as mysql points out: although length would still work in most cases (as far as i understand it)

thanks alot m8! i adpated that as follows: SELECT YEARWEEK( date ) AS Week, Sum( total ) FROM orders GROUP BY Week However the date Returned is listed as yyyyww eg 3rd week in 2007 would be 200703 i'm guessing date() can be used to convert this to a more recognisable date eg: 21/01/2007 dd/mm/yy? Can you shed any light on this please? Cheers.

OK, i am a bit confused how to attempt this, i have a few ideas, but none are very efficient. I have a table in a mySQL database called "tblOrderArchive" which is a table of orders on my site, i have a graph class which requires two arrays of values one for X axis one for Y, ok easy enough so far, but the scenario is as follows: I need to make a graph as follows: X axis - Week by Week Y axis - Orders Taken Graphname - "Orders per week" To do so i need to generate arrays as follows: xAxisData('21/05/2006','28/05/2006') YAxisData('234','242') etc What would be the best way to get this data from my table in a week by week format? the table Schema is as follows: id - int client_fk - int date - DataTime Type htmlField - text value - Decimal(11,2) Any help would be VERY gratefull. Regards, HeavenCore

thankyou for your response. The script runs ok (no errors are thrown back) However no file is created. Do i have to specify save location? or should it just create in same folder as script? Cheers

Hello, intro I have come across a bit of a problem with one of my clients, i developed their website in php and it is hosted on a server farm under easyspace they have zlib 1.1.4 and gzip(i think) installed. i dont have shell access. The problem The site in question has thousands and thousands of product images, backing these up over ftp takes AGES due to thousands of ftp get commands etc, i need a way of compressing these images server side into one file, it does not matter about compression strength, this can be low, its just the 1 file i need. Any ideas would be greatly appreciated as i have little experience in server side archiving. Regards J.