MySQL is an open-source, relational database management system.
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 ...