Recent content by gazza110

Hi, I have a table that holds different rating categories in a single field - comma separated (table name: scale). Each rating has a value relative to where it is in the list (first_item = 1, second_item = 2, third_item = 3 etc). I want to be able to run an SQL query in MySQL to split the...

Hi, I have been trying to generate a pivot table in MS Excel from an Access query without success. I can get the data into excel however cannot create the Pivot, keep getting error: Run-time error '5': Invalid procedure call or argument Private Sub cmdPTable_Click() Dim ExpCheck As...

Hello I have designed a database to capture detail of revision session for students. The database can detect if there are clashing sessions and generates a report (query) I want to create a cross-tab to identify which subjects are clashing with each other however I cannot get the output to...

Hello, Does anybody know a way (perhaps using JavaScript) to merge PDFs together based on their filename? I have created several PDF files (extracting from a large file) with student timetable on it and named the files with their student ID and page number (some are 2 pages and some are only...

Hi thanks for the reply. Unfortunatly the databases are NOT on the same server. With my hosting company you can only set-up single databases with their own login and password associated. I was looking at a procedure of something like ... <?php $DB1Conn = mysql_connect ("localhost"...

Hi, I am having some trouble joining two tables together that exist in seperate databases. In PHP you can connect to one database but not two?? I have a database that contains customer and their login (they log in with email and password). I wanted to link this to another site (a helpdesk...

I tried the following code in the .htacess file which is hosted on the domain name http://www.MusicStore.co.uk LoadModule proxy_module modules/mod_proxy.so AddModule mod_proxy.c ProxyRequests off ProxyPass / http://Music.MyPersonalHosting.co.uk/ This caused a: 500 Internal Server Error...

Thanks for the suggestion Noway2 I have looked at details of mod_proxy but have not been able to get this to work as I need it to. Could you perhaps write an example piece of code of this for me to follow? Thanks in advance.

Hi I am trying to redirect from one domain to another without changing the URL address. I have a url which is: http://www.MusicStore.co.uk This domain is hosted however has limited functions. The files for this site are actually stored on another domain that has phpDatabases, more space and...

OK - Change of plans!! I have now transfered my domain www.EducationShop.co.uk to another provider with limited hosting. The site files are still on MyPersonalHosting. I have created a subdomain to the EducationShop files which now looks something like: http://Shop.MyPersonalHosting.co.uk...

Thanks elgrandeperro for your advice. I have tried and failed! When I attampted to access http://www.mypersonalhosting.co.uk/hello.txt This worked and the text file was displayed in the brower. When I again tried with http://www.educationshop.co.uk/hello.txt noting happened, still a blank...

Thanks again everyone for your help. I think I'm getting there but still not 100% there yet! I have set an A Record for alias "www" of the domain "EducationShop.co.uk" to point to the ip address of my personal hosted site "http://www.MyPersonalHosting.co.uk" When you enter...

Thanks for the info. Unfortunatly the hosting provider I am with does not allow me to do this nor can I change. I really do need to do this somehow using a rewite solution. PLEASE can anyone help with this specific request? Thanks, Gary.

Thanks for the advice. I have tried and failed to use the htaccess rewrite function. All I want to happen is the URL in the address bar to be changes (no REDIRECTION). When a user enters www.educationshop.co.uk in the address bar this is automatically sent to...

Thanks for the advice Noway2. The domain www.educationshop.co.uk is not hosted, it mearly has web forwarding to http://www.MyPersonalHosting.co.uk/EducationShop/index.php I did try and use URLproxyServer.php with limited success, the page was displayed however this was then shown in the address...