mousey182

Hey Guys, Thanks for taking the time to read this, I have the following, rather complicated queries that I am trying to join, and I've spent the past two days attempting to do so, but had no luck so far so any help would be very much appreciated. I have …

Hey Guys, I have the following code, which averages the scores in a select statement and works no problem. [code] SELECT AVG(score) as 'avg' FROM (SELECT d_key_id, frequency, weighting,(frequency*weighting) as 'score' FROM users_to_keywords WHERE s_user_id=$user_id AND d_key_id = $score_key ORDER BY score DESC)a [/code] However, as there are some duplicated …

Hi Guys, Im having problems with some mysql select statements. I have a database containing 7 tables in the following format: [U] Adverts [/U] Field Type Null Default advert_id int(11) No 0 frequency int(11) No 0 [U]keywords[/U] Field Type Null Default key_id int(11) No 0 keyword varchar(20) No [U]keywords_to_adverts[/U] Field …

I've tried searching the web and cant find anything to help me. I'm trying to create a 2D java maze application and have come up with the code below. It generates the maze and GUI no problem, and I've worked the code out to create a xPosition and a yPosition …