Tagged Questions
2
votes
0answers
61 views
Manually add “Product Model” number to Product Listing in Zen Cart
I am trying to find out how I could manually add the product model to each title in the category product listing in zencart, rather than having the model number appear in its own column.
It appears ...
1
vote
0answers
29 views
Arbitrary user-defined constraints on database results
In a survey framework, where user input (ie "asking" survey questions, not answering them) is fairly trusted, my predecessor went with building a MySQL query pretty much straight from user-defined ...
1
vote
0answers
54 views
MySQL - Friends Leaderboard ranking by wins and include player in ranking
Platform: MySQL/PHP
Scenario: Create Friend Leaderboard which includes all friends of a player and also include the player in the leaderboard within a single query.
Details: I'm trying to create a ...
1
vote
0answers
61 views
Magento 1.7 sorting by ordered quantity - bestseller products issues
There are several cases reported where the standard solution(s) for this query do not work (similar questions on SO are abunding,with no definitive solution whatsoever).
What one would do to retrieve ...
1
vote
0answers
41 views
Multiple ids with one form
I don't really know how to explain what I want but I'll try. I know my code is horrid and a big mess, I'm just really bad :/ any help would be appreciated.
I'm making a shop for my game, and have a ...
1
vote
0answers
86 views
Jquery.Ajax POST update query
I'm searching for a way to update my Database without having to post the whole page.
I'm trying to keep this as simple as possible.
I'm building a table with with some information in the database in ...
1
vote
0answers
55 views
Querying a Clarizen Project/Task in PHP
I'm currently trying to get a list of all Clarizen active projects so that I can modify some properties of its tasks. I've read the Clarizen API but it doesn't have many informations on PHP queries. ...
1
vote
0answers
91 views
returning an array to echo from sql query
the second echo, for user_name, prints correctly, but the first will only print array and give 'array to string error'.
my query should return an array of about 6 names. Is there something im missing ...
1
vote
0answers
113 views
Read Raw Contents of File in Private Repo on Github via access_token
I am trying to retrieve the raw contents of the README.rm file of a private repository on Github.
I'm extremely close, the only issue currently, is that I'm getting back a 401 unauthorized result.
...
1
vote
0answers
93 views
Slow postgresql queries in Zend
I am using Zend 1.12 with postgresql database.
I am also using Zend_Db_Table_Abstract interface for accessing my database.
My code (simplified):
class Application_Model_DbTable_Images extends ...
1
vote
0answers
157 views
Salesforce Soap API, query not returning the value for boolean fields
I have a salesforce query that works without an error. I can use all the data except the boolean fields. I would like to display different information depending on the value (True or False) of the ...
1
vote
0answers
47 views
How to add a second query as a condition?
Please see my query below. Right now its look for system_id from contacts where system_id = '$sid' but i want the query to ALSO look for friend_id from contacts where system_id = '$sid'
$tre = ...
1
vote
0answers
113 views
How to delete all joined entities in the single DQL
I have such a dql statement:
DELETE i, p, d, d2, s
FROM OverseerMainBundle:Image i
JOIN i.plates p
JOIN i.doc d
JOIN p.doc d2
LEFT JOIN p.symbols s
WHERE d.tag LIKE :tag
If ...
1
vote
0answers
153 views
query structure
So, I'm currently doing a small attendance system.
I have a problem structuring the necessary code to work with what I need.
So, to make things short, I have a page named TAKE ATTENDANCE in which ...
1
vote
0answers
306 views
Can $_SERVER['remote_port'] affect MySQL query success?
I'm experiencing a very strange issue with an e-commerce website: some queries, but not all, to update order's statuses are failing for some mysterious reason.
Upon a successful payment by a ...
