David
Forum Replies Created
-
Forum: Developing with WordPress
In reply to: Major Database ChallengeThanks for the reply. I have it working with the $wpdb adjustment, but not sure I have it in the most streamlined way possible. Here is what I have so far and it works http://wordpress.pastebin.com/76cRLKga
I had to use the $wpdb->prefix for the sql as that seemed to work so I just went with it.
Basically I have a loop inside a loop. The parent loop runs thru an array of the days of the week and passes the days into the sql and then the second loop displays the results. I am checking if there are any classes for each day. I am sure there is a better way to run thru the days of the week with %s like the original sql before the $wpdb , but not sure how to do this with the new version of my sql statement with the $wpdb. Any help with this would be great. I am so close.Forum: Developing with WordPress
In reply to: Major Database Challengeguess I need to ask for help one more time. If someone needs me to explain sql more then please ask. I just need a nudge with this one. I need to change the day of the week for every loop through the query to check if that day has any classes.
Forum: Developing with WordPress
In reply to: Major Database Challengeno one?
Forum: Developing with WordPress
In reply to: Major Database ChallengeYes it is stored on the same database. I have done the $wpdb before for simple sql’s… it is just this is a little complex for me. I need to incorporate the foreach loop that loops out the days of the week and then the query loops out classes for those days. example of the loop….
Monday
class one
class two
Tuesday
class One
class two
Wednesday
No classes
Thursday
class one
class two
Friday
class One
class two
Saturday
No classes
Sunday
class oneSomething like so…it also prints out class type and teacher for the first loop in the header for the table. Anyway…as it is it works and works well just need to do it the wordpress way.
Forum: Developing with WordPress
In reply to: Major Database ChallengeIs there anyone that can help with this issue? I would be greatly appreciated for your time.
Forum: Developing with WordPress
In reply to: Major Database ChallengeHere is the code on pastebin http://pastebin.com/gaqJjPdQ