MrXHellboy

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 ?

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" />

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