MySQL is an open-source, relational database management system.
0
votes
0answers
4 views
Same sub-query used multiple times in a single query
I am running a query that contains same sub-query used multiple times in a WHERE clause.
I have a table having tow fields client_id, buyer_id.
The sub-query returns the list of dates to be excluded ...
0
votes
0answers
10 views
How do I decrypt and encrypt Joomla user password for Java program?
I have programed a Java program which has access to my MySQL database.
Currently I am using Joomla as CMS, therefore I would like to program my Java program so it is able to check the user data(of ...
0
votes
2answers
12 views
PHP - Alter URL to hide querystring and display page title instead
I have a selection of pages which currently have a url which looks something like this:
www.mydomain.com/directory/?id=123
This displays a story from a mySQL table with the id of 123.
What I would ...
-3
votes
6answers
23 views
Date conversion for PHP & MySql
I am getting date from an XML feed in the below format
Wed, 12 Jun 2013 06:13:37 -0400
How can I convert this date in PHP to insert into MySQL database as
2013-06-12 06:13:37
0
votes
0answers
4 views
Error handling in LOAD DATA INFILE in bash script
I am using LOAD DATA INFILE to import multiple csv files into MySQL database, for this I use a bash script. Now I want to log all the errors to log file or STDOUT which occurs while loading the files ...
0
votes
0answers
3 views
How to show mdb(access) file fields(Include utf8(arabic persian) charactrers) with php?
I have an access(.mdb) file include Arabic or Persian characters.
and I need to use from it in php or import it to MySQL.
but it shows ???? instead of utf8 word.
this is my code:
$conn = new ...
-2
votes
3answers
67 views
Storing Comments with PHP
Hello Friends I wrote the following code to insert comments (like Facebook) in MySQL but i didn't succeeded. please help me.
This is the html page
<html>
...
0
votes
0answers
5 views
Selecting an object by it's id using django with heroku postgresql
I've got an app running on heroku with django, the local DB I use mysqllite, but on heroku the app uses postgresql.
I'm having a problem and I've no idea why is happening. Let me explain myself:
I ...
heroku
0
votes
1answer
27 views
where clause in query that all dates in range
i need to fill missing dates with last values available, so i am going on first step to get query with all dates including missing one on daily table. I know there a lot of question about fill missing ...
0
votes
4answers
24 views
Replace tags with space in PHP for SEO Meta Description
I am trying to strip tags from HTML in a mySQL database to plain text for an SEO Meta Description. The HTML in the database looks like this:
<p>The Break-ezee is a vital piece of equipment for ...
0
votes
0answers
16 views
optimizing a query using union left joins and inner joins
I have a query that I want to optimize. Both unions executed separatley run fine, however as soon as I include inner join it takes up to 57 seconds. How do I solve this. My query is as follows
SELECT
...
1
vote
2answers
34 views
how do you do a mysql WHERE something = 'something' OR … (PHP)
Is it possible to do an OR statement like this?
WHERE pR.projectRelationId = '$id[ 0 ]' OR '$id[ 1 ]' OR '$id[ 2 ]'
AND pR.type = 'yada' AND
or do you have to keep redeclaring the comparison:
...
0
votes
1answer
10 views
how can i find all column with full text index in mysql 4.1.22
I'm trying to find all column of a mysql database (4.1.22) whith a Full Text index.
With Mysql > 5.0 i can run this query
SELECT TABLE_SCHEMA, TABLE_NAME
FROM information_schema.STATISTICS
WHERE ...
0
votes
1answer
14 views
Select specific columns with average of specific row values using joins in CodeIgniter
I have two tables table1 and table2, in table1 I am saving the user details and in table2 the ratings he has given which are multiple rows with same table1.id and ratings in rating column, but when I ...
0
votes
1answer
38 views
Change mysql query to show tasks only on specified days
I'm working on a transport planner and to show the tasks by the selected date I'm using the following mysql query:
SELECT *
FROM planner
WHERE '$date' >= date
AND '$date' <= ...
