firedrop84

Hi Everyone, I wasn't sure which categoriy I should post this topic as I am not even sure of where the issue is. At , the programmer has went on holiday and I end up assigned to fix some issue with the site as I have some knolwedge of PHP. After I have looked at the site, I can see the programmer has used PHP, IIS as a service. However, the issue is that they have upgraded the server from IIS5, Windows 2000 to II6 and WIndows 2003. Once they have upgraded it, the site doesn't show all the data. Initially, I thought there is a problem with the DB as most of the data from the db it doesnt show. However, I checked the db and it is working perfectly fine. I then noticed that everything doesn't work in the site which is related to the db that is after I login but before I login I can see the data from the db. After some investigation, I guess I reached to the conclusion that the issue is with the session and that is why I dont see the data. The code is the same and it was working perfectly fine with IIS5, WIndows 2000 but once i upgraded to IIS6 WIndows 2003 I am getting this issue. Any idea, suggestion? I approciate your coproation with this?

Thanks everyone for your reply. I just would like to make it clearer of what I am trying to have. I am trying to change the date format in excel from dd/mm/yyyy to timestamp in order I can import at later stage in the database. I tried =(((E2-(6*3600))/86400)+25569) but it didn't work. I had in field B2 the date and I used the formula in C2. It changed it from 1/1/2010 to 1/1/1970!!.

Hi, I have an excel sheet with many data there. I am trying to import all these data to the righ tables in the database which I could manage to do it successfully. However, the issue I am facing is with the date coloumns. in the database, I am using a timestamp and the field is integer in the db (yes, I know I could use date as the field type but now it's quite late to change as it might affect my php code). my question is how can I change a normal date format in excel from something like dd/mm/yyyy to timestamp in excel. Any ideas? Best Regards, Ahmed

Thanks Daniel. Let me try it and I will let you know.

Thanks Daniel, your support is greatly approciated and I really need it. I am studying my masters but I am from Information System background not Computer Science which they gave us almost no math in uni. Matrix is a new concept for me. However, I asked a guy who graduated in math and he explained it for me. He doesn't have any IT knowledge. Based on what he said, I developed the sheet attached. The stuff I wrote in red in the attachment it's really just the index that it will be in the array. I thought if I have two arrays and each as two colomuns and two rows. Then, I thought maybe then I need to divide them into four arrays which they are C11, C12, C21, C22. You will see with the black pen is where I am getting the elements I need from each array. Then, I finish it by having a final array by adding the result into a final array. hmmm, nested for loop. Let me try to think how can I do it. to make my question clearler . This is a link of a thesis. Please look at page 294 - 299 which explains what I am trying to do. http://www.debii.curtin.edu.au/~ponny/doc/PhD_THESIS.pdf [attachment deleted by admin]

I am basically trying to know how can I multiple two matrix in PHP.

Hi Everyone, I have a problem in regards the coding that I am trying to develop. I am trying to implement some concept which uses matrix but I didn't find any matrix function in php which does that. I done some calculation which is working fine and now I have two arrays which I need to multiplie the first and the second array and get a new array. I have to do it twice for a two dimminssional array and a single diminssioanl array. Can any help advice how this can be done. p.s. I already found this one site which has a class for it but it's quite complex. Any other site you know about it or any ideas you can give that might help http://www.phpclasses.org/browse/package/2859.html. Your advice is greatly approciated.

Hi, I am currently trying to develop a prototype which I need to divide the page into two seperate page. When the user interacts with the left sidfe of the page nothing happens to the right side and the same for the right side. Any idea what will be the best and easier way to do that. I thought of frames but then I said let me check if there is something else around. the second question I got is if anyone have seen around a php script where users can vote on a topic but each user are assigned to a group where each grou phas different weight of voting. For example, if Experts in IT voted they get double marks than normal guyz and so on. this is all need to be in php.

Hi, I am in process of developing a website. However, currently I got a new requirment which I have to create a mail merge feature to the website. The mail merge should have email and mail (in the future maybe sms as well). In other words, users they search for customers and they get a result (i already got this search feature). Then, they can export it by either choosing a letter which is already saved in the database and merge it with those customers that has been searched for or write a new letter. It's a time consuming task to develop so i was thinking if i can buy something like this feature (a ready code or something). Any idea where can I get a code to intergrate it to my website.

Hi All, I am trying to find out a way to be able to read, edit, write, etc and OWL file in PHP. I know Java does support Ontology but I am not sure if PHP does as I couldn't find much about it on net. Anyone has any idea about this topic as I need some guidlines how I will be able to do it. Thanks in advance.

Thank you for your reply. I have attched the script that I am using for the date picker. Can you help on re-arrange it as i dont have much knowledge in JS. Regards, firedrop [attachment deleted by admin]

Hi All, I got a java script that is Date Picker but the format is year - month - day (YYYY - MM - DD). I need a date picker which is with different format (DD - MM - YYYY). something without time. does anyone knows where can I get a script on net that is already written for this. Regards, Firedrop

Dear All, I am developing a website which one of the client requirments is to have an HTML Editor. In other words, there will be a control panel that he can add Text, Hyperlinks, Images, Tables, changing font colours and size, etc in the control panel. Once he is able to do that it should be save in the database and then viewed in other page anytime with the format that he has entered in the control panel. For example, Let's say I have a page in the site called About Us. In this page he wants to be able to go the control panel and do all the formating and then once he visit About Us page he sees the page with all the format he entered. I am thinking of this can be possible. Any Idea of how can I do this. Regards, firedrop

Hi All, I have a problem with one of the functions that I am using in my website. The function basically forth staff to shift on/off. I test it into three cmputers that they show me different errors. The first computer it works fine unless if there isn't any row in the database. it displays an error when I try to shift on. The error is: Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\xampp\htdocs\CBDHealthSpa\test.php:130) in C:\Program Files\xampp\htdocs\CBDHealthSpa\test.php on line 147 The second computer it display a debug error any time i try to shift on/off. The debug it attached into the message. The third computer it works find for the first time when I shift on/off. The second time or even more it dsipaly the same debug error. I have attached a zip file that contains the php code and a screen shot of the debug error. Any one can help me with this. Regards, firedrop [attachment deleted by admin]

Hi everyone, I am using PHP, MySQL and Apache. I have coding some pages after I finished them and test them through localhost I didnt had any errors with them. I decided after that to uploaded into my server (on internet) and I had lots of warrning massages and lots or most of the pages that is related with the database it shows me a warrining massage. below is an example of a warring massage that displays Warning: mysql_query(): Unable to save result set in C:\Inetpub\vhosts\getonlinesystem.com\httpdocs\new\MyAccount.php on line 23 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\Inetpub\vhosts\getonlinesystem.com\httpdocs\new\MyAccount.php on line 25 the same page with the same code it works on localhost. When I test it on localhost or when I host it on the server I use the same database. can anyone give me an idea why its doing this is it because of different version or which reason it could be.