Razor42

Ok. Thanks

Where abouts would I enter that? Above he initial print?

Something I need a little help on... I want it so that when players click a grade link it takes them the courses within that grade. So far I have.. print "Hello and welcome too school. Before doing a course, you must first select a grade....<br /> <table width=75% cellspacing=1 class='table'><tr style='background:gray;'><th>Grade</th><th>Required Courses Complete</th><th>Enter</th></tr>"; while($r=$db->fetch_row($q)) { $enter="<a href='education.php?gcourses={$r['grade_id']}'>Enter</a>"; print "<tr><td>{$r['grade_name']}</td><td>{$r['crREQUIRED']}</td><td>$enter</td></tr>"; } print "</table>";   The part im unsure about is: $enter="<a href='education.php?gcourses={$r['grade_id']}'>Enter</a>";   I know that at the moment that wouldn't work but i'm unsure what to do to make it so that when Enter is clicked they go to the courses within that grade. The column where the id of the grade in that course is called crGRADE.

I took it into a different direction. Made it so that staff members set a required amount of courses complete to be able to enter a grade. If you haven't completed the set number of courses then you simply can't enter that grade and do the courses in it. I am having problems and unsure what i'm doing but i'm sure ill get it sorted. Thanks for your help Sniko it was much appreciated and also thank you Octarine.

Lol sorry for the fact that I needed help. If you feel that way then go ahead and close the thread.

Still off topic ;)

New layout looks tons better and the player base is growing nice. Well done.

Did you get the full $300?

You've gone off topic guys ;)

CREATE TABLE `grades` ( `grade_id` INT(11) NOT NULL AUTO_INCREMENT, `grade_name` varchar(255) NOT NULL, PRIMARY KEY(grade_id) ) ENGINE=MyISAM ; Thats the MySQL's for my grades tables, I'm thinking I would need to add another column in either the courses tables or grades tables. Then when a staff member creates a course it will add the course id or even just +1 so that their is something which shows which or how many courses their are in this grade. then when someone completes a grade this would then remove the course id or -1 depending on how I did this. One thing is how would I make it so everytime a course is created it +1's to that exact grade number? And how would I make it so that everytime a grade is created, it gets its own grade_count?

Thank you.

Right so I have been re-coding the education system so that staff members can create grades which the courses will be added into, for a player to move onto a next grade so they must complete all classes in grade one .i.e. Grade 1 includes courses- attacking, defending & working then grade 2 includes- attacking advanced, defending advanced & working advanced. For players to do any of the courses in grade 2 they must complete all courses in grade 1. Not sure where to start really with this so some pointers in the right direction would be great. P.S. All staff files are re-coded and working its just the education.php I need help with. Thank you.

Very interesting concept.

Wow looks very good. One thing, would you not need copyrights to use players name, club badges etc. Another premiersip teams alone would not be enough to create a game. Add other large leauges like Series A, La Ligua etc.

Would be greatful if someone could help me out with this. My query: $db->query(sprintf("UPDATE `users` SET `money` = `money` - '%d', `investPROFIT` = '%d', `investSTART` = unix_timestamp(), `investLENGTH` = '%d', `investDAYS` = '%d', WHERE `userid` = ('%u')", $_POST['invest'], $profit, $investtime,$timeuni, $userid));   Error: QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `userid` = ('1')' at line 6 Query was UPDATE `users` SET `money` = `money` - '40', `investPROFIT` = '0', `investSTART` = unix_timestamp(), `investLENGTH` = '0', `investDAYS` = '0', WHERE `userid` = ('1')

I don't feel the game needs to look amazing, just a simple, clean & easy to use and you've got what you need.

Well done looks like you've worked hard on this and I can see it becoming a big success, one thing is the layout thought. Well done bud. Hope it all goes well.

Well theres no fun in buying crappy work...

Make sure as that would return an error.

$connection = mysql_connect("$mysql_host","$mysql_user","$mysql_ password") or die ("Unable to connect to MySQL server.");   Why is there a space on $mysql_ password?

Ok, I get it now, thanks guys.

So I need to create a common value in each table? Something like `dog_id`? Which would make the query: $dd = $db->query("SELECT * FROM `dogs` JOIN `dogs_stats` ON `dogs.dog_id` = `dogs_stats.dog_id` JOIN `dogs_bgc` ON `` = `dogs_bgc.dog_id` WHERE `dogs.dog_id` = 1");   Would that be correct?

Hello there would be greatful if someone could help me with a problem I am having. Basically I want to create a query which selects from three tables in my database, I know this query uses the JOIN and I have a basic knowladge of what it should look like but I am not 100% sure how to do it. I know it should be something along the lines of: $dd = $db->query("SELECT * FROM `table1` JOIN `table2` ON `table1.id` = `table2.id` JOIN `table3` ON `table2.id` = `table3.id` WHERE `table1.id` = 1");   I think.... Table 1 should be- `dogs` Table 2 should be- `dogs_stats` Table 3 should be- `dogs_bgc` But I am unsure what to put in `table1.id`,`table2.id` and `table3.id` If someone could point me in the right direction that would be great.

Negatives would ruin the concept of it really. You are all respected coders in my eyes who if I wanted work doing, I know I could go to you guys and recieve quality work. That would be one thing that would help new comers know who to trust when buying things instead of going to someone who is going to rip them off, and as you say in the past you all had negatives, which would mislead people into thinking your untrustworthy or something and go to someone who couldn't produce the work you guys could.

Why not create it....?