Tagged Questions

2
votes
0answers
28 views

Subqueries with Load Data Infile

I am having a problem with a particular sub query: LOAD DATA INFILE 'some_address' INTO TABLE 'some_table' FIELDS TERMINATED BY 'field_terminate' ENCLOSED BY '"' ESCAPED BY '\\' ('fieldX', ...
2
votes
0answers
153 views

How to integrate sqlite extensions in XAMPP?

There's an extension on the http://www.sqlite.org/contrib?orderby=date, extension-functions.c, which integrates the SQRT command in sqlite. How can I integrate this and use it in my Windows-XAMPP ...
2
votes
0answers
277 views

How can I custom options to an item dynamically when it is added to the cart in Magento?

I have been struggling with this issue for a few days now. I have inherited a website built on Magento. This website sells products that can be all customized, and every product is built to order. My ...
2
votes
0answers
110 views

Unable to perform mySQL query using Paypal PDT data

So here is the issue, I am trying to do a PDT and grab the basic info and post to sql, more importantly a custom variable aswell. Its an integer, called "lvel" also "apv" into users under "user_level" ...
2
votes
0answers
109 views

Calling SQL procedure from Zend PHP gives @@@@@ as result

I have recently loaded Zend Server on my iSeries and am trying to run an SQL stored procedure. When I run a regular SQL query everything works. When I change the query to the SQL stored procedure ...
2
votes
0answers
463 views

How to do an update query in SQL/PHP with ORACLE(OCI)

I'm new to Oracle and using OCI with PHP. I've been doing ok until I've tried to do an update statement. include("ORCLconfig.php"); $updateTitleInserted = oci_parse($conn, "UPDATE insured SET ...
2
votes
0answers
347 views

SQL Query optimization in Prestashop solution

I'm working on the layered navigation module with Prestashop solution, I'm trying to optimize a Sql query which create a tmp table to execute it and by this way create a bottleneck in mysql. This is ...
2
votes
0answers
169 views

Customize Infobox Map Sql php

I would appreciate a hand hecharais I am trying to create a map connected with php and sql. My intention is to customize the "infobox" but I can not find the solution. This is in .js I wish you could ...
2
votes
0answers
96 views

application/octet contains an image file from android phone to php, how to convert it into a blob?

My app sends a jpeg to php service which recieves the file as application/octet. Does anyone know what I can do with this file and how I can insert it as blob in my sql as an Image file?
2
votes
0answers
267 views

Can't read CLOB into string… sometimes

I have an array of CLOB datatypes. In my sample data, there are two items in the array. The array is embedded in a FOR loop that will loop until all of the data is read from the array (in this case, ...
2
votes
0answers
931 views

Installing PEAR on XAMPP

Attempting to install propel with PEAR on XAMPP. This is the error I get when attempting to: pear install -a propel/propel_generator ERROR: failed to mkdir ...
1
vote
0answers
45 views

Populating selection list based on prior entry

I have some PHP/SQL written to populate a selection list with data from a database with the option being populated based on a prior numeric entry in a text box. At the moment i gave it a go but i ...
1
vote
0answers
43 views

Clean way to get foreign key objects in PHP MySQL query

I use the following code to get a book object from my MySQL database. $q = $pdo->prepare('SELECT book_id "id", book_title "title", ...
1
vote
0answers
77 views

Joining multiple SQL queries to display online friends list?

I am trying to join 3 tables together to display a list of table users taken from table subscribers only where their IP = an IP in table online. subscribers table: (Doesn't allow duplicates, type ...
1
vote
0answers
36 views

Remove Hyphens from Query & Database Lookup Field

I recently setup a Magento store which draws products from various external feeds - most we have no control over. I've run into a problem in that our customers are searching our site using queries ...

1 2 3 4 5 … 104
15 30 50 per page