Query pulls records from 5 db tables and returns Account Receivable by line item (e.g. Work Order || Quantity || Width || Height || Part Number
EXAMPLE OF OUTPUT:
++++++++++++++++++++++++++++++...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
Hi Experts,
I am new to MYSQL stored procedures and functions. I have to create a procedure which requires to process multiple rows. For that I am using cursors.
...
http://www.experts-exchange.com/Database/Miscellaneous/Q_23361699.html
Hello. This is a followup to the question I posted here (http://www.experts-exchange.com/Database/MySQL/Q_23484583.html)
Basically, I am needing to do a join on a query that isn't working for m...
http://www.experts-exchange.com/Database/MySQL/Q_23489689.html
Hello -
I've got a query below that I'm trying to create a view for. When I try to create the view for this, though, I get an error message back - "View's SELECT contains a subquery in the FRO...
http://www.experts-exchange.com/Database/MySQL/Q_23493097.html
Just wondering if there are any good recommended books, online material or other reference material to learn good PHP Design pattern books used in an enterprise situation. Something that will show...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_23526022.htm...
Is there a way to do "something" on out of memory?
Ideally I probably want to do a backtrace but other things would be nice, like accessing an array after the error that could have memory alloca...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_23545362.htm...
Zones:
PHPDate Answered: 07/07/2008 Grade: B Views: 16
I have a tickets application where we track the check-in time (called startTime in the query) and the check-out time (called endTime in the query). The info is stored in a MySQL 5.x database (anywa...
http://www.experts-exchange.com/Database/MySQL/Q_23668502.html
When I execute the following code, I get two different results - whats up?
echo date('Y\WW');
echo "<br>" . strftime("%YW%W", time());
I get:
2008W37
2008W36
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_23714249.htm...
Zones:
PHPDate Answered: 09/08/2008 Grade: A Views: 0
1) This query selects all cities which have = 2 businesses. When using this query I get an empty result.
I apply this query on the whole table:
SELECT bizCity, COUNT(*) as biz_count from table GR...
http://www.experts-exchange.com/Database/MySQL/Q_23735611.html
I have a running MySQL production server with moderate load. I want to move that to another server (slowly), how can i setup (and configure) another mysql server on the other machine and have it re...
http://www.experts-exchange.com/Database/MySQL/Q_23848576.html
Zones:
MySQL ServerDate Answered: 10/29/2008 Grade: A Views: 4
