0
votes
0answers
80 views

Custom query on Wordpress custom table

I am working with a custom table where some values will be inserted or updated if they already exists, I have checked and rechecked the syntax and it seems to be working fine, if I run the same query ...
1
vote
1answer
39 views

Pushing stored procedure to a multisite database in WordPress

I am given a WordPress multisite and need to extract information from the site. I have written a stored procedure that recursively builds a tree relationship for posts of a certain kind. Now I am ...
1
vote
2answers
225 views

How to create and work with custom data / tables (i.e., for arbitrary data)?

Getting started on Wordpress just today. I noticed that Wordpress created tables in a mySql database (with name *.wrdp1) when I first set it up. These tables cover comments, posts, users, and some ...
0
votes
1answer
25 views

Multiple Wordpress Pages

Not sure how to approach this one. I have a wordpress page that uses a mysql query to grab info from a database based on the page title. I basically want to replicate that page to 50 or so ...
0
votes
1answer
356 views

Custom SELECT Query With Multiple Meta Values (Ordering Problem)

I have two custom meta values that I am using for an events list and have almost got everything working perfectly except for the ordering. I have two dates (event_date and event_enddate). One of these ...
2
votes
2answers
573 views

modify all posts of a category to “no comments allowed”

I'm looking for a way to modify all posts of a certain category to be "no comments allowed" without going into each post settings, one by one, and modifying manually. Perhaps a MySQL statement? ...
0
votes
2answers
159 views

Why doesnt my tag page populate with this custom post type?

I have a tag page that is generated with the first image attachments from all of the posts. I call it in the loop with : <img src="<?php echo get_first_attachment() ?>" /> and this is ...
3
votes
1answer
281 views

What specific database privileges does WordPress need?

I want to create a new database user for my WordPress installation. Usually on localhost, i can just use root, but it is good practice to use a user with as little rights as possible. What are those ...