query

How do I enable the MySQL function that logs each SQL query statement received from clients and the time that query statement has submitted? Can I…

I need to get a script working for our billing system (WHMCS) using their sample code that shows the average response time to support tickets for…

I'm doing a db to organize my movies. I have two tables (1 for movies one for actors). Puting it simple and omiting useless fields for this exercise…

I have searched in a few topics for how to resolve this issue I am having with a query that uses CONCAT but yet must return the groups even if the…

i need to catch the password of a specif email when the value of activation is 1 or 2 query that i am using: $stmt = $db->prepare('select…

I have no idea why this error is happening, it's shown in all the expressionengine tutorials and on the forums yet for some reason I still get it?…

I have a query where I currently get information from 2 tables like this: SELECT g.name FROM site_access b JOIN groups g ON b.group_id = g.id WHERE…

This is my table structure fName Friend's Name [Varchar] fUID Friend's ID [Int] UID User's ID [Int] pk [fUID, UID] i want to get common friends of 2…

The problem: I need to select, for each building in my table that has say at least 2 pharmacies and 2 education centers within a radius of 1km, all…

I need days in my tables and I need the query to compare with today like this ex : $query = "select course_ID from course where day = (today)"; This…

I'm trying to make a search query between a table of key terms and pages. Consider the following tables. PAGES page_id page_name 1 cats 2 dogs 3…

The following query takes about 30 seconds to execute when current_vacature_response contains 88k records, and daily_vacature_response contains 10k…

I have table structure as follows id productid ip hittime --------------------------------------------------------------------------- 1 5 1.1.1.1…

thanks for taking the time to read this. Essentially I have 3 tables. Posts, Follows, Artists. What I am trying to do is pull all the 'Posts' from…

I am trying to limit my count results to those that meet a specific criteria. I am currently using a WHERE clause and my output is as expected. Here…

MySQL Server Version: Server version: 4.1.14 MySQL client version: 3.23.49 Tables under discussion: ads_list and ads_cate. Table Relationship:…

Just discovered data stored in an sqlite file on IOS isn't so secure after all. So I'm considering encrypting some key fields. Can anyone tell me is…

I am doing a pretty normal routine, but having a tough time getting my output correct. I have two tables: *ads_list* (listings) and *ads_cate*…

The following query finds the directors of all shops. I think that there is a simpler solution to this, something that I will prefer to use. Thank…

After taking some advice from people on here in a previous thread, I'm trying to convert my MySQL to PDO, but am running into some issues. Here is…