Snobbery

I can certainly help you achieve "grade" 8, how quick this takes you is down to your time you put in to playing. For me i had a gap year so 12 hours a day was easy to do as i did not need a job either. Which is only technically grade 7 as the steps are: 1,2,3,4,5,6,8. Cos there was such a small difference between the two.. and "Grade 8" is a commonly known term in music they didn't change it to seven. Few tips.... Learn your chords (not so much how to play them... by why a major is a major... why a minor is a minor etc) Then learn the scales that will "work" with the chord you know. Followed by learning each "mode" of that scale and working out which of the modes will work with that chord as well. Once you know this.. grade 8 is piss to complete as its just maths. If you want to pass the grade 8 "playing" aspect which takes alot longer... For me it took 1 year which involved 12 hours a day every day and no social life pretty much during my gap year. I wouldn't recommend doing what I did, due to hand injuries, and well I ended up getting an obsessive compulsive with guitar and I still have my obsessive compulsive. As with many other subjects mind, which now means I cannot hold down a job as I always end up waking up at 6am playing guitar and never go to work. Not even by choice. So I'm kinda addicted i guess. I know alot of people who have done grade 8, in under one year, so i aint no "miracle guy" that this forums keep wording me as in a sarcastic way... its possible to do as many people can and have done it.. its not as hard as people make it out to be. In simple terms, if i can do it.. so can any one of you. Let me know what your track is key wise/beat wise. I can tell you what options you got.. then, show you them options then let you do it if you prefer it that way so that the whole track consists of "you" rather than you and some one else. But if you do want some one to assist..i can certainly try. Always happy to session with any one in any music genre. Experimenting = Good

I think you may be better off going on steam's website forums for support/help.

I play guitar.... what do you have in mind?

Is add/remove in control panel suppose to connect to the internet :S I don't quite see why it would do that.. sounds a bit unusual.

The way to do it would be to find all the files in your system32 folder.. as there must be a few in there which is keeping it there. Doesn't Add/Remove from control panel do it? Or does it not detect it ? Are you on Vista? Cos that can stop you due to permissions also.

I don't like the Wii.... the only people i know who have one are females so that put me instantly. And they all have these ridiculously crap arcade like games like bowling... who on earth pays so much money for a console to play a bowling game... just go to town and play the real thing its cheaper lol. I agree with the call of duty comment. That game is great specially drunk

Thanks Jon.

Oh right, nah it's not found the correct row. It didn't find any there but it should have found one row which is RecordID 11. I just get: Notice: Undefined variable: ReportsNoResponse in C:\xampp\htdocs\test140.php on line 51 NULL Which is expected if no row was found.

Group by should be possible as it only needs the "most recent" message in the message table anyway. I had a quick edit of your script to get it working.. am unfamiliar with the array approach to it. But it looks promising. How ever.. not sure how to pull out the data to echo it ? This is the edited version i placed it into a table for the no response just to try it out. <?php include($_SERVER['DOCUMENT_ROOT'].'/css/layout1.php'); // Variable to hold out lists in $ReportsNoReponse = array(); $ReportsUserResponse = array(); $ReportsStaffResponse = array(); // Temporary array to store already processed reports $ProcessedReports = array(); /** * This is the query we need, it will select all the data for the tables * we need and order them by the StartTime decending. */ $res = mysql_query(' SELECT *, ISNULL( RecordId ) AS NoResponse, ISNULL( UserId ) AS UserResponse FROM reportedusers LEFT JOIN reportsituation USING ( RecordID ) LEFT JOIN staff ON reportsituation.SaidBy = staff.UserID ORDER BY SaidTime DESC ') or die(mysql_error()); while ($row = mysql_fetch_assoc($res)) { // Check this report hasn't aready been seen if (!isset($ProcessedReports[$row['RecordID']])) { if ($row['NoResponse']) { $ReportsNoResponse[] = $row; } else if ($row['UserResponse']) { $ReportsUserResponse[] = $row; } else { $ReportsStaffResponse[] = $row; } // This report has not been processed $ProcessedReports[$row['RecordID']] = 1; } } ?> <div class=tablecenter> <table width="500" border="1" cellpadding="0" cellspacing="0"> <tr> <td width="100" align="center" class=blackBold><?=$ReportsNoReponse?></td> </tr></div></table> I get a return saying "Array". My original approach was like this: //reports that have no messages $GetAppeals = mysql_query("SELECT * FROM reportedusers, reportsituation WHERE reportedusers.RecordID != reportsituation.RecordID") or die (mysql_error()); //get user responses $GetAppeals2 = mysql_query("SELECT * FROM reportedusers, reportsituation, staff WHERE reportedusers.RecordID = reportsituation.RecordID AND reportsituation.SaidBy <> staff.UserID ORDER BY reportsituation.SaidTime ASC") or die(mysql_error()); //get staff responses $GetAppeals3 = mysql_query("SELECT * FROM reportedusers, reportsituation, staff WHERE reportedusers.RecordID = reportedsituation.RecordID AND reportsituation.SaidBy = staff.UserID ORDER BY reportsituation.SaidTime ASC") or die(mysql_error()); But the first query of them 3 was getting the record id's even if there was messages related to that ID in the other table. So that didn't work.

Is there really such a difference between the two in terms of what the ending result is in DVD's etc? Cos if not then this battle will probably never end until the next bit of technology comes out and then it will be the final nail in the coffin for both of them.

No its not educational. my original method was apparently inefficient as what i did was use 5 queries but apparently it can be done in only one query. This is best explanation i can give for it to make sense: I'm trying to get my query to sort my list into 3 groups with 2 groups sorted in a desc order by time (except the first group does not need to be). The query is not even close to doing what it is meant to do! But i have given it my best shot! To get it to work i think it needs an additional table which i have shown below the query. Code: <?php $GetAppeals = mysql_query("select s.StaffType , r.SaidBy , r.SaidTime , r.RecordID from reportsituation as r inner join Staff as s on s.UserID = r.SaidBy order by s.StaffType ASC , r.SaidTime ASC") or die(mysql_error()); ?> The database relationship i have is : Report Table - ReportID (unique) | other unrelated fields | Report Messages table - ReportID | Message | SaidBy(UserID) | SaidTime | Staff table - UserID | StaffType | *ReportID being the important link here. *Staff table is there to check if the most recent "SaidBy" was by staff or not. The list it is meant to go in the order of when gathering rows: If report has no messages that goes top of the list. (order not needed) Then all the reports where the most recent saidby (via saidtime) field for each report was said by a user..in simple terms if SaidBy is not found in the Stafftable, then it was a user. (all these reports then get sorted in DESC by saidtime) Then all the reports where the most recent saidby field via saidtime for each report was said by a staff member. (then all these reports get sorted in DESC by time) Example of the list that it should make: No replies No replies No replies User response on report id 5 - 4 Days ago User response on report id 12 - 1 Day ago User response on report id 2 - 90 minutes ago Staff - response on report id 45 - 4 Days ago Staff - response on report id 7 - 2 Days ago Staff - response on report id 50 - 10 minutes ago **EDIT - Forgot to add it should group by the ReportID just encase by some pure unlucky chance two of the same were in the Report Table thats more of a error prevention. Hope my explaination is as easy to understand as possible. And hope you can help me out!

Any chance you could take a look ? If so i shall type it out for ya to have a gander.

I been set a challenge to make a query which creates a complicated list by splitting the order of the list 3 ways then sort each group individually in ASC time order. This is done across 3 tables which is what is pissing me right off! I'll wait to see if any one here is a pro at mysql who is able to help before i post a length explanation. Im thinking how ever a unison might be needed but not sure. Any way .. let me know if you willing to give it a go.

Hey Chaps, Just wondering if any of you know any good libraries for the sorta techno/rave/trance type of music? Been really interested in making my own track after listening to the radio stations on itunes. Obviously I have no samples for that kinda thing so was wondering if any one here had any suggestions for good quality...price is slightly irrelevant although free is slightly better where ever applicable! Hope you guys can help.