-
Posts
153 -
Joined
-
Last visited
Never
Posts posted by MrXHellboy
-
-
Couldn't change the sotry anymore...
Hello,
I have a query "INSERT INTO SELECT".
It's quite huge, so i minimize it with a simple example
INSERT INTO table (NAME, PRICE, CATEGORY, ORDER)
SELECT a.name, a.price, a.category, a.order
FROM table1 AS a
INNER JOIN table2 AS b
ON a.order = b.order
WHERE a.received<> (SELECT SUM(QTY) FROM shipped WHERE barcode = a.barcode GROUP BY barcode )
@ table 1 i have 1 record showing the total ordered quantity (324 - barcode 555666), and the received QTY 0, which i want to compare to the SUM of all the QTY from table2, which has 4 records (4* QTY 81 - barcode 555666).
If you get your calculator, you will see it makes 324, so the total quantity is correct. But since we didn't receive anything, the received QTY is different than the shipped QTY. Now i want all those 4 records moved into the other table.
But the query places 3 records into the new table and leaves 1 behind.
It must place all 4 the records into the new table instead of 3.
Please help ?
-
Hello,
I have a query "INSERT INTO SELECT".
It's quite huge, so i minimize it with a simple example
INSERT INTO table (NAME, PRICE, CATEGORY, ORDER)
SELECT a.name, a.price, a.category, a.order
FROM table1 AS a
INNER JOIN table2 AS b
ON a.order = b.order
WHERE a.ordered <> (SELECT SUM(QTY) FROM ordered WHERE barcode = a.barcode GROUP BY barcode )
@ table 1 i have 1 record showing the total ordered quantity (324 - barcode 555666), which i want to compare to the SUM of all the QTY from table2, which has 4 records (4* QTY 81 - barcode 555666).
If you get your calculator, you will see it makes 324, so the total quantity is correct.
But the query places 3 records into the new table and leaves 1 behind.
It must place all 4 the records into the new table instead of 3.
Please help ?
The thing is... I get 3 records placed into `table`
-
1) <select name=dropdown_list> -> <select name="dropdown_list">
2) I dont see your query
3) type echo 'Hello World'; somewhere
-
It would be possible to cheat i guess if you did not check for things and put some security into your script.
-
Testing @ localhost or your webserver @ hosting company ?
-
Your list is empty ? Or what ? you placed it @ the correct place but i dont get what your issie is
-
May i ask you want you want exactly ?
-
This is not PHP.
Second of all, the height of a table will be made of the total amount of rows with, in some cases, cellspacing
-
Trying to send from localhost @ webserver?
-
$_SERVER['HTTP_REFERER']; // = Visitor comes from http://google.nl/?search=blahblah for example
-
Sorry
SELECT MAX (postage_world) as something FROM basket
-
SELECT MAX (postage_world) FROM basket
-
you see the row @ DB ?
-
Remove the ID and the NULL as you probably filled in @ the field ID not null & auto_increment
-
No, It's your query
mysql_query($query) or die ('error updating database');
Remove the ID and the NULL as you probably filled in @ the field ID not null & auto_increment
-
As thorpe already stated, mail() is not relying on IMAP or POP. Those protocols are related to retrieving email through MUA/email clients.
-
IMAP is just for retrieving the email, just like POP3. If its a send issue, you can blame the MTA (otherwise known as SMTP).
In that case, you have to raise a support ticket
Add on top of your script to see error, which are trigger by mail()
error_reporting(E_ALL); ini_set('display_errors', 1);
-
We all want to help you, but how are we supposed to do that without any code ?
-
Are you using this @ localhost or hosting company ?
-
Whats your code ?
If you have a 1 file uploaded , and you succeeded, you probably are able to loop through the $_FILES array
-
What's your code right now ?
-
<link href="/htdocs/lso/style.css" rel="stylesheet" type="text/css" />
-
Sorry, you've lost me with haystack
haystack = array to search in
-
It could be easier, less writing, if you do it right and the style is quite pretty. If you learn how to do it, you will get the point of it.
But you could reach the exact same purpose with procedural style
UNION ALL
in MySQL Help
Posted
Hello,
This query seems to only receive the result from the first SELECT statement, and it doesnt add the COUNT() amounts together.
(SELECT a_LEV_NR, COUNT(DISTINCT ASN_ORDER), COUNT(ASN_ORDER), a_LEVER_WEEK
FROM qty_discrepancies
GROUP BY a_LEV_NR)
UNION ALL
(SELECT a_LEV_NR, COUNT(DISTINCT ASN_ORDER), COUNT(ASN_ORDER), a_LEVER_WEEK
FROM tht_tgt_discrepancies
GROUP BY a_LEV_NR)
Could someone help me out ?