Search results for query: *

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...

...http://Shop.MyPersonalHosting.co.uk WITHOUT changing the URL. I have used the following: RewriteEngine on RewriteCond %{HTTP_HOST} ^([^.:]+\.)*EducationShop\.co\.uk\.?(:[0-9]*)?$ [NC] RewriteRule ^(.*)$ http://Shop.MyPersonalHosting.co.uk/$1 [R=301,L] This works in terms of...

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...

Hi, I need help using mod rewrite to change the appearance of a URL. I am running a virtual shop (for educational purposes only) and hosting this on my own web hosting account. I have a domain for this educational shop and this points to the actual location of the index file. I need not to...

Thanks for the info jpadie, this could be a way around it. My current hosting provider however offer a site redirect or a framed redirect to point to another site location. Could you perhaps advise me further on a php proxy solution as you mentioned???? Many thanks, Gary.

Hi, I need help with a redirect and mask of url using PHP. I have created an online store to use within an educational context (the store is only a simulation - there is no live payment processing). I have hosted this on my own webhosting server that I use for a different site. I have...

Hi I need to create a database button that will save the content of the clipboard (a screenshot) as a JPEG. This is for students to create screenshots as evidence for ict coursework. I originally was going to paste the pictures into access, however the bloat with this made the file size huge. So...

Hi, I am trying to use crosstab queries to devise a weekly shift schedule for employees. I have a tblCheckIns that has fields: *employee name *payroll number *date *start time *end time from which I have 2 queries running on this: qryStartTime qryFinishTime I have got the date as...