MattDunbar

If you just want to do mobile sites (html optimized for smaller screens), I'm pretty sure any of them would work fine. If you're looking to build installable apps, you wouldn't be using PHP.

Try this, on the line where the query should be happening: echo "UPDATE global SET status='$status' WHERE id='1'"; I'm curious to see if $status is being set. If not, and the query was "SET status='' WH..." that would at least help source the error.

Depending on the version of mysql, you might be able to get away with doing it all in one query. Regardless, here's a decent way to do it, using 2 queries that will work on nearly any version of MySQL: $result = '1,2,3';//in reality, you're going to get this through a query instead, not assigning it by hand. $newQuery = 'SELECT * FROM table2 WHERE somevalue IN ('.$result.')'; You could also explode it as mentioned above, and individually deal with the records in a loop. E.g. $result = '1,2,3';//in reality, you're going to get this through a query instead, not assigning it by hand. $resultArray = explode(',',$result); for($i=0;$i<sizeof($resultArray);$i++) { $newQuery = 'SELECT * FROM table2 WHERE somevalue = '.$resultArray[$i]; }

I'm assuming you're dealing with timestamps as you didn't specify how times are stored, however this should be pretty simple for most other types. Also, my queries are very basic and doesn't touch on days of the week - I've left a bit of the easier things for you to do yourself. Then when doing the SQL select, try these queries: -Find anything with a start time during the new period. If count doesn't equal 0, it means that the time is taken. SELECT COUNT(*) as count FROM tCourse WHERE Start_Time >= (the start timestamp) AND Start_Time <= (the end timestamp) -Find anything with a end time during the new period. If count doesn't equal 0, it means that the time is taken. SELECT COUNT(*) as count FROM tCourse WHERE End_Time >= (the start timestamp) AND End_Time <= (the end timestamp) Now, the tricky part is finding things that fit completely within another time period. For example, 2PM - 6PM and inside of it, 3PM - 4PM To do that, we can use this query: SELECT COUNT(*) as count FROM tCourse WHERE Start_Time < (starting timestamp) AND End_Time > (ending timestamp). I'm pretty sure I've covered every scenario here, but I don't have the time to test it out myself right now. If I missed anything, post it and I'll try to come up with a query for you. You might also be able to combine a few of these queries into one by using OR statements. Theres a few ways this could be optimized.

The if statement has a few more brackets than it needs, this would suffice: if ($rpos>=$count && $rpos<($count+20)) I'm not really sure if it can be improved. You'd need to explain the purpose of the code.

Make sure that you fully comprehend what OOP is first. Don't look for OOP tutorials specific to PHP, look for a definition or explanation of OOP not specific to any programming language. This works: http://en.wikipedia.org/wiki/Object-oriented_programming Now, learn the terms (read the ones that you aren't familiar with): http://en.wikipedia.org/wiki/List_of_object-oriented_programming_terms After doing all that, you should be ready for a php-specific tutorial.