vyvyanhs
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: phpMyAdmin Changes not reflected on browsersJust in case it’s of interest, exactly the same thing just happened to me, with a theme originally based on twenty-ten. You just need to update a WP page or post and your db changes are reflected, until then, zilch.
Forum: Fixing WordPress
In reply to: $wpdb->get_results not behaving as expected with JOIN queryThanks, Marius, for your interest, but I have now solved (or rather side-stepped) the problem by using mysqli_query() for this particular function. I do think there may be a problem with the wpdb code as I have not had to change the SQL at all, and it was working perfectly OK for over a year under the now-deprecated mysql_query() and now works with mysqli_query().
The db schema is very simple, representing artists in an annual art trail who may exhibit at just one venue, which could be their own home, or elsewhere, or they don’t yet know the venue yet. Further simplified it is:
//venue venue_id int (primary key) address_1 varchar address_2 varchar address_3 varchar [... other text fields ...] //artist artist_id int // primary key venue_id int // may be null name varchar email varchar is_current_exhibitor int //flag to show they're taking part reg_date date //date the artist signed up) [... other text fields ...]The query delivers a list of all artists who are taking part this year together with the address of the venue they’re using, if known, as a CSV download.