Courses - Free up resources

[sniko]

Following on from

Database Table Design

 

This will help save resources, as said in the article above;

1. Run this SQL

http://codepad.org/ST5AIzuQ

 

2. Open up education.php

3. Find this query

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

4. Replace with

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

5. Replace this snippet

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

6. With

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

7. Save education.php

8. Open cron_day.php

9. Find;

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

10. Replace with;

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

11. Find;

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

12. Replace with;

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

And that's it...

-sniko

Edited March 14, 2012 by sniko
Thanks Illusions for your reply!

[danger boy]

Great idea!

However, this error occurs:

Parse error: syntax error, unexpected T_ELSE in /home/dangerbb/public_html/education.php on line 15

[sniko]

However, this error occurs:

Parse error: syntax error, unexpected T_ELSE in /home/dangerbb/public_html/education.php on line 15

 

Sorry, that should do it now, review step 6.

[danger boy]

Now I get the below error,

QUERY ERROR: Unknown column 'cdays' in 'field list'

Query was SELECT `crNAME`,`cdays` FROM courses WHERE crID=3

[Damagedcity.com]

@dangerboy.. Did u run the sql as per the first step?

[danger boy]

The above SQL has been excuted, yes.

[Uridium]

your Table shows as users_courses yet some parts refer to users_course

Just too make people aware..

 

6. line 5 needs editing from cdays to crDAYS

10. needs to be users_courses

12. need to be users_courses

Edited March 14, 2012 by illusions

[sniko]

your Table shows as users_courses yet some parts refer to users_course

Just too make people aware..

 

6. line 5 needs editing from cdays to crDAYS

10. needs to be users_courses

12. need to be users_courses

Thanks for spotting those!

** Illusions ** sorry for editing this post but i had to change 12

Edited March 14, 2012 by illusions