thecase

Thanks CroNiX and DavidAM you were both correct I could only mark one. Works perfectly. I will take into consideration about using the array keys Thanks.

Hi I am reading in data from a csv file if (($handle = fopen("data.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { echo "User Name: $data[0]"; echo "Booking IDs: $data[1]"; } echo "<hr>"; The problem is some of the usernames are duplicated so get outputted the same user name 20 times but with different IDs, obviously but I am unsure how to group them together. I can't seem to figure out how to write if the next username is the same as current then just add another ID not go through the entire loop. Any ideas? Thanks

Hi I have this date in my database 11/06/2013 12:00 This is my code and the format I would like it in $dateformatstart = date_format(date_create($row['datestart']), 'D j M y H:i'); Although it comes back as Wed 6 Nov 13 12:00, Think the month is the day and day is the month I don't know why

I'm trying to comapre the two arrays for duplicates and set up an array with the dates that arent duplicated. I don't have control over the 1st array as it comes from the database but I can change the 2nd array. I'll try what you suggested Barand thanks

Hi, I'm trying to compare arrays but they have different levels of keys I've tried to compare using array_diff but this only finds a difference on the first entry for array 1 I assumed due to the different way it set up. Any ideas how I can get this to work Thanks

Thank you works great and learnt some new conditions

It comes back with string 'SELECT TRUE FROM studiorota WHERE date='2012-09-19' AND starttime <= '17:30' AND endtime > '16:30' ' (length=99) There is no error just coming back with the wrong results. The $_POST data is from a dropdown like this echo '<p>Start: <select name="timestart">'; for ($i = $start; $i <= $end; $i += 1800) { echo '<option>' . date('G:i', $i); } echo "</select></p>";

Sorry I didn't know how much info was necessary is this any better? The Code: -- -- Table structure for table `studiorota` -- CREATE TABLE IF NOT EXISTS `studiorota` ( `id` int(11) NOT NULL AUTO_INCREMENT, `show` varchar(100) NOT NULL, `date` date NOT NULL, `starttime` time NOT NULL, `endtime` time NOT NULL, `volunteer1` int(11) NOT NULL, `volunteer2` int(11) NOT NULL, `volunteer3` int(11) NOT NULL, `volunteer4` int(11) NOT NULL, `removedate` int(10) NOT NULL, PRIMARY KEY (`id`), KEY `volunteer2` (`volunteer2`), KEY `volunteer3` (`volunteer3`), KEY `volunteer4` (`volunteer4`), KEY `volunteer1` (`volunteer1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `studiorota` -- INSERT INTO `studiorota` (`id`, `show`, `date`, `starttime`, `endtime`, `volunteer1`, `volunteer2`, `volunteer3`, `volunteer4`, `removedate`) VALUES (1, 'An Hour Of Fun', '2012-09-05', '17:00:00', '18:00:00', 1, 38, 48, 16, 1348763388), (2, 'Talk', '2012-09-19', '10:00:00', '12:00:00', 19, 8, 53, 29, 1348763532); mysql_query("SELECT TRUE FROM studiorota WHERE date='$_POST[date]' AND starttime <= '$_POST[timestart]' AND endtime > '$_POST[timeend]' "); The problem is for example ID 1 the system must come back as TRUE when the user selects a start/end time between 1700 and 1800 although the query I already tried lets the user start at 1730 or end at 1730 clashing with ID 1. As for SQL Injections and Data verification I can implement this when the query is fully working but any pointers? Hope this is clearer

This is how the database is set up `starttime` time NOT NULL, `endtime` time NOT NULL All the $_POST data comes from a drop down (as I limit the user to only certain times) so I know that I am going to be getting the exact format I need. Thanks

Hi, I'm creating a booking form but am having problems. In the table I have two fields set to Time: starttime and endtime. I am trying to create a query that checks in between these times to stop double bookings so something like this mysql_query("SELECT TRUE FROM studiorota WHERE date='$_POST[date]' AND starttime <= '$_POST[timestart]' AND endtime > '$_POST[timeend]' "); Although it doesn't work as expecting resulting FALSE when it should be TRUE so how do I set the query up correctly to compare the two time fields. Thanks