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

learn more… | top users | synonyms (3) | mysql jobs

0
votes
1answer
12 views

CodeIgniter 2.0: Unknown column ' ' in 'where clause'

I'm new in CI 2.0, when it come error like this: Error Number: 1054 Unknown column 'lap_jenis' in 'where clause' SELECT * FROM (laporankebijakan) WHERE lap_type = 0 AND lap_jenis = 0 ORDER BY ...
0
votes
0answers
9 views

SQL to update column in modified table

I am a reasonably competent SQL programmer but my skills are still pretty much in the domain of simple INSERT, SELECT, UPDATE statements with an occasional LIKE etc thrown in. What I am currently ...
0
votes
1answer
13 views

Download php script image

Helo I'm trying to create download script in PHP...upload form is ok and it stores file in folder 'upload/' but and file name is stored in DB, but when I download, it downloads file e.g. some image, ...
0
votes
0answers
9 views

SQL auto multiple joins

I've got some table with products, then some products_infobase table that joins products with one of the info bases with descriptions etc and then I've got some infobase_description table with id > ...
0
votes
0answers
19 views

Advanced Search Java Library

I am adding functionality of advanced search to JSF Based CMS product Search criteria : If User Searches with keyword Assets then he should be able to get records containing Asset As well as Assets ...
0
votes
0answers
19 views

Delete Entries in different DATABASE MysQL Query

This works to delete rows in a different table, as long both tables are located on same database (thanks to Yadav Chetan for the query) : DELETE FROM BLOGS WHERE `id` NOT IN (SELECT id FROM ...
0
votes
5answers
27 views

Can't create a dynamic page

<?php while($result = mysql_fetch_array( $resulta )) { echo "<tr>"; echo "\t\t<td>{$result['denumire_locatie']}</td>\n"; echo ...
0
votes
1answer
6 views

Make column as header and combine similar id in one row in sql

I have a query which output is something like the table below (see current output) wherein month is a column. What i want is to place month name as Header and combine same itemcode and their quantity ...
5
votes
2answers
43 views

Does MySQL cache queries?

I'm interfacing a MySQL database with PDO and executing an extensive SQL query. Normally, it takes about 1500ms; I still need to optimize it. When I run the PHP script twice with a short interval in ...
0
votes
0answers
20 views

MySQL JOIN performance issue

I am trying to build a query for later inserting it in a table I'm building. I want the query to return 4 columns, which are 4 ids from different entities which relate with each other. I've got one ...
4
votes
2answers
35 views

am i wasting server time if i call one method for each request for insertion

i am working on PHP on OOP's concept, this is the class called 'connect' which connects to database and also inserts the request in database_ class connect(){ public function insert($column, ...
0
votes
2answers
27 views

MYSQL - Select statement, if condition fail return empty string

I have this query (MYSQL): SELECT agent.name,agency.title FROM agent, agency WHERE agent.id = "1" AND agent.titleid = agency.titleid This will give me a record with the name and title, ...
0
votes
0answers
17 views

DISTINCT keyword IN MYSQL backend in Django?

I hae a MYSQL query like this: shared_file = File.objects.filter(id__in= Share.objects.filter(user_id = log_id).values_list('file', ...
0
votes
0answers
6 views

Paypal pro with express checkout using “payflow gatway” going live it give “Security header is not valid”

I integrated the Paypal pro with express checkout (PHP 5.3) that has a bespoke checkout process. While in development mode (using the sandbox details) everything works but the moment I switch the ...
-2
votes
0answers
6 views

Filling list using information from a database (JAVA)

Im pretty new at all this Java programming, so please correct me if i make any mistakes. Im making an application for my study, but im kind off stuck right now. I need to fill an Jlist using ...

1 2 3 4 5 11276
15 30 50 per page