Search results for query: *

I am having to update a system I built from mysql to mssql (and also from a wamp environment to IIS running windows php). All is going well so far apart from datetime data types. I read that datetime is not supported and to use the much more forgiving datetime2 instead but I'm still getting the...

Firstly let me apologise if this is the wrong forum, I couldn't find a specific forum for IIS and php. The IT team in their wisdom are decomissioning the apache machines and only supporting windows, they have created a virtual Windows Server 2008 R2 system with IIS7. I managed to set up php...

I have a table that features 5 columns that are entered into a database, there are 3 rows of these <form method='post'> <table> <tr> <td><textarea name='this'></textarea></td> <td><textarea name='that'></textarea></td> <td><textarea name='other'></textarea></td> <td><textarea...

I have a page that I'd like to open up different options depending on the answers to two fields, here's the scenario can you confirm that the info is correct? [Please select|Yes|No] Do you have the relevant qualifications [Please select|Yes|No] Yes | Yes - show div1 Yes | No - show div2 No |...

I have a table with a set of questions as columns, the answers to the questions are either 1, 2 or 3 i.e. id | q1 | q2 | q3 | q4 | q5 1 | 1 | 1 | 1 | 2 | 2 2 | 1 | 2 | 2 | 2 | 2 3 | 1 | 1 | 2 | 1 | 2 4 | 1 | 1 | 2 | 1 | 2 I need to work out how many 2's there are for each...

I have tables that store scores of 1-3. i.e. table 1 id | userid | t1-score1 | t1-score2 | t1-score3 | t1-score4 | t1-score5 | t1-score6 | t1-score7 | t1-score8 | t1-score9 | t1-score10 table 2 id | userid | t2-score1 | t2-score2 | t2-score3 | t2-score4 | t2-score5 | t2-score6 | t2-score7 |...

I am making a fullname text field and want it so that when people start to type, it accesses the users table in the database and suggests names, the user clicks one to autocomplete the text field. This will hopefully prevent fullname spelling errors. I got this working no problem, but, is it...

I have a table with many columns, I want to return all columns but ignore duplicates based on one column id | fullname | this | that | other 1 | Bob | 1 | 0 | 0 2 | Mary | 1 | 1 | 0 3 | Bob | 0 | 1 | 0 In the above example I need to only pull...

I have written a php script that interrogates a database and produces 30 results from it and outputs these to a page i.e. number of surveys completed in total = 200 number of surveys per staff member = 0.2 surveys scored 50 and above = 20 percentage of surveys scored 50 and above = 10 etc etc...

I need to populate a table within mysql with data from an excel spreadsheet. A new updated spreadsheet will be generated weekly, the data will need to be entered into the table weekly to reflect this new spreadsheet. That in itself isn’t a problem, I have been doing this by preventing access...

I have a database that needs moving over to mssql I have looked around the web about data type differences and there is a lot of conflicting info, so I thought I would ask the experts here. Looking through the database the data types used are int(11) longtext text varchar(1) to varchar(2500)...

I want to move some web systems over to a new machine. The machine is all set up, wamp installed and working fine, files copied over. When I view http://localhost/ all works fine When I view http://127.0.0.1 all works fine When I try to view http://machinename/ (on the server and over the...

I have a database with a 'date' data type where some of the fields are 0000-00-00. I need to run a SQL command that will find all date that are 0000-00-00 and replace with a date that is in another field. The column name with some instances of 0000-00-00 is date_finished The column name with...

I am checking that all sections in a database have been completed, if each has then set a variable to say it is complete. I then check that all of those variables have been set as complete, if they have then open up some content on a page. I am getting a problem though where my final if...

I have a table that features 20 columns, the results of these are either y, n or na. The vast majority of the results are y so a typical row would be id | col1 | col2 | col3 | col4 | col5 | col6 etc (the actual comumn names are not sequential, I just did this for ease) 123 | y | y | y | n | y...

I am trying to export some info to excel, it's working perfectly fine however the html of the page is also being exported into excel. Here's a basic example of what I am doing <?php Header("Content-Disposition: attachment; filename=export.csv"); print "boom"; ?> <html> <head></head>...

This is a bit of a strange one. I have to use a server for a new website that was built many years ago and runs wamp with IE6. The rest of the company is on IE8, running my website locally all css and javascript works as intended. I have now moved the site over to the server and browse it...

I have a large form with many questions, the answers are either y (for yes), n (for no) or x (for N/A). The form table is structured as IPC1 | Question | radio for y, no or x IPC2 | Question | radio for y, no or x etc etc RS1 | Question | radio for y, no or x RS2 | Question | radio for y, no...

I am using dompdf and php to create a pdf page, this works fine when I pass some html to it i.e. <?php require_once("dompdf/dompdf_config.inc.php"); $html ='<html><body>'. '<p>sample pdf</p>'. '</body></html>'; $dompdf = new DOMPDF(); $dompdf->load_html($html); $dompdf->render()...

A table contains a date field of the format yyyy-mm-dd, I want to grab rows where today is 30 days before that date. The final script will be run every day as a cron job so needs to pull dates that are exactly 30 days away, but as that will not return any rows today, I have been trying to...