MySQL is an open-source, relational database management system.

learn more… | top users | synonyms

0
votes
0answers
17 views

Choosing the right server for a big WordPress site with buddypress

I started working in a WordPress site with buddypress and I need to choose a server. They have 1.9 million users in the database and they are estimating to have like 250,000 views every month. The ...
0
votes
1answer
25 views

Linking Plug-In Files to WP

I am writing a plug-in right now which adds a table to the database when activated. I have another file in my plug-in directory which handles a form submission and writes to the database. This file ...
0
votes
1answer
25 views

Query the database after get_header() has been included

I'm trying to create a custom template. Iv'e searched a lot but cannot find how to query the database once the get_header() is added to the page. What I am looking for is for PROPER ways to query ...
0
votes
0answers
16 views

wordpress with mysql or wordpress with mssql [on hold]

We have a working software that was built in a client development environment. We would like to convert this software to the web and want to use wordpress for the task. The software is built in ...
1
vote
0answers
29 views

Writing into MySQL Table

I'm trying to write some data from the frontend into a custom database table. As long there is no value in the input field this script creates an empty line in the database table, but if the input ...
2
votes
2answers
45 views

WordPress for a very large website

I've searched and searched but I did not find an answer online. Also, I've posted this on StackOverflow and apparently it wasn't ok and I reposted this here. I hope it's ok. I have this website which ...
0
votes
0answers
22 views

Renaming admin user on multisite install by MySQL

As part of a general tightening of security, I want to change the name of the admin user on my multisite install to something less commonly used. This user is admin on all five sites in the network ...
0
votes
0answers
22 views

How to display the image of first product in a woocommerce category as it's category image?

After an import of products to woo commerce system, I am faced with an issue where I have 50+ categories without any featured image and limited time. Assigning them an image manually will be tedious ...
0
votes
1answer
27 views

Using mysql to replace img src?

I tried to use the Enable Media Replace Plugin to replace some images on my site with updated versions. There is an option to update all instances where the file is used on the site, but this only ...
0
votes
1answer
27 views

meta_query on a date range using an array of values

How can I do a query to return the post if the custom field array contains a date that is within the specified range? The query below is basically what I am after but it does not work... // the ...
0
votes
1answer
12 views

meta_query dates from an array

I have the below query which isn't returning anything. The query is meant to look for the date (2014-03-01) that is in the array, which it is. Any ideas? Or would I need to use a custom SQL query? ...
0
votes
1answer
28 views

Calling mysql_query() on another database, assumes WordPress using that database

I'm attempting to import some data from a legacy site into WordPress. First step is terms for taxonomy event_category. Here is my approach: $link = mysql_connect( 'localhost', 'blah', ...
0
votes
2answers
59 views

Query multiple meta key values for template

I am using this template: http://demo.undsgn.com/studiofolio/front-page/ I tried to make some modifications because I need the homepage template to display an excerpt beneath each thumbnail. I copied ...
0
votes
0answers
18 views

Queries gone haywire since update to 3.8.1 [duplicate]

I have a WordPress install on a dedicated server with decent memory (upwards of 8GB) Since upgrading to 3.8, I started getting mysql disconnects/timeouts, better known as MySQL server has gone ...
-1
votes
0answers
10 views

Run mySQL Code on Option Page of a Plugin

I'm a complete noob when it comes to create option page for a plugin. I don't want to create a plugin and this is not a "do my work" post. I don't wanna create anything like that I'm asking this cuz ...

15 30 50 per page