luminous

I have two tables with a structure as follows: Table 1: id_text - key long_desc Table 2: id_text - key id_product I'm trying to achieve returning an array as follows, where there are one to many id_products to each id_text fields: array( array( [id_text]=>1 [long_desc] = > Description goes here array( //product IDs [0]=>23, [1]=>17 ) ) ) at the moment I am retrieving a column for each and not grouped as above: Array ( [0] => Array ( [id_product] => 23 [long_desc] => Description goes here[id_text] => 1 ) [1] => Array ( [id_product] => 17 [long_desc] => Description goes here[id_text] => 1 can anyone help me? )

You my friend are an absolute saint! This has really helped me out, I've created an object to handle everything much more neatly but I'd been staring at this thing for so long my brain had turned to moosh, I just needed someone to push me in the right direction! Thank you again, your time is very much appreciated :'(

I've been stuck on this for about a week so I was wondering if I can get some help from you guys! Basically I'm exporting an array of values to a CSV file, within that array are two other arrays containing data I need. What I need to work out is how I can create a CSV with headers for these values, then with the nested arrays also print their values into the same rows as the first array. Example: $List = array ( 'Product ID' => '10', 'Customer Address' => '123 Fake Street', array( array('Product Name'=>'Product1', 'Product Price'=>'10.00', 'Product Reference'=>'HGJEN'), array('Product Name'=>'Product2', 'Product Price'=>'5.00', 'Product Reference'=>'HGJTN'), array('Product Name'=>'Product3', 'Product Price'=>'10.00', 'Product Reference'=>'HGJNN'), ), array( array('Product Customisation Name'=>'Additional Info', 'Customisation Value'=>'Things are great.'), array('Product Customisation Name'=>'Image Upload', 'Customisation Value'=>'Logo.jpg'), ), 'Telephone Number'=>'999', ); To be exported to something looking like this: Product ID Customer Address Product Name Product Price Product Reference Product Cus Name Cus Value Telephone Number 10 123 Fake Street Product2 5.00 HGJTN Additional Info Things are great 999 10 123 Fake Street Product1 10.00 HGJEN Image Upload Logo.jpg 999 10 123 Fake Street Product3 10.00 HGJNN [/td] [td] 999 If anyone could help me out in anyway I would be so appreciative, I'm sure this ones going to end up killing me!

thankyou!

I'm setting a date using: $day = date("d")+1; However when I echo this result I get a single character rather than two i.e '7' and not '07', anyone know what could be up with this? I'm sure it's something to do with the '+1' because i create the current date with this code and returns with the format I want. Thanks!

Cheers, Thanks!

Sorry, Should of mentioned that! I'm using the 'move_uploaded_file' function in both instances.

Just a question concerning the $_FILES['tmp_name'] field. I'm uploading a file which is being moved into two different locations. I run an 'If' check to see if either process fails but as I am running them both at the same time, when a $_FILES['tmp_name'] is moved, can it be used again? Both my functions run fine independetly but when I try run them both it doesn't work So my question is which may be seem fairly obvious: Once you move the $_FILES['tmp_name'] is it removed from the temp folder it's in? or is it copied? Thanks!

I have the following tables: ordersl: id_order id_carrier id_lang id_customer id_cart id_currency id_address_delivery id_address_invoice customization: id_customization id_product_attribute id_cart id_product quantity quantity_refunded quantity_returned customization data: id_customization type index value I'm trying to get each value field from the customization data table where the id_cart field in the orders table is equal to the id_cart field in the customization field The relationships are as follows Orders [One to One] Customization Customization [One to Many] Customization data I'm really don't understand joins to well but here is the query I've been using and it returns the data i want (for this example it should return two fields of 'values') but is instead returning the values 12 times! I've tried all kinds of combinations of joins to try and get what I want but it doesn't seem to make a difference Here's the query I'm using: SELECT ps_customized_data.value FROM pres.ps_customization_field, pres.ps_customization_field_lang, pres.ps_orders INNER JOIN pres.ps_customization RIGHT OUTER JOIN pres.ps_customized_data ON ps_customization.id_customization = ps_customized_data.id_customization WHERE ps_orders.id_cart = ps_customization.id_cart AND ps_customization.id_customization = ps_customized_data.id_customization

I'm rubbish with REGEX, I need help extracting a string between two characters like so: $date = "Wednesday, June 23, 2010"; preg_match ("/[,](.*)[,]/", $date, $matches); which gives me: Array ( [0] => , June 23, [1] => June 23 ) However I only want the second value (without the ',' at the beginning and the end) help me please!

I know you can use group_concat to do this, however, is it possible to group the values from a column into seperate row values instead of just a single row value containing all the data?

I'm having trouble trying to understand where to put a 'join' in this query, this returns: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ps_orders ON O.id_order = OD.id_order AI.id_address=id_address_invoice AND' at line 34 SELECT O.`id_order`, OD.id_order, O.`date_add`, O.`total_paid`, O.`total_shipping`, O.`delivery_date`, O.`invoice_date`, C.`id_gender`, AD.`firstname`, AD.`lastname`, AD.`company`, C.`email`, AD.`phone_mobile`, AD.`phone`, CONCATC(AD.`address1`, " ", AD.`address2`, " ", AD.`postcode`, " ", AD.`city`), CONCAT(AI.`address1`, " ", AI.`address2`, " ", AI.`postcode`, " ", AI.`city`), OD.`product_name`, OD.`product_quantity`, OD.`product_weight`, OD.`product_price`, CA.`name`, CL.`delay`, M.`name` FROM ps_carrier_lang AS CL, ps_carrier as CA, ps_orders AS O, ps_customer AS C, ps_order_detail AS OD, ps_manufacturer AS M, ps_address AS AD, ps_address AS AI LEFT OUTER JOIN ps_order_detail, ps_orders ON O.id_order = OD.id_order AI.id_address=id_address_invoice AND AD.id_address=id_address_delivery AND CA.id_carrier = O.id_carrier = CL.id_carrier AND C.id_customer=O.id_customer AND O.id_order = 28 Can someone please help?

I'm using th PHP 'goto' function and I've just read you can't jump in or out of methods or loops which is probably why I'm having trouble with this code... $standard_shipping = array("4","5","6"); $free_shipping = array("1","2","3"); $mail_shipping = array("7","8","9"); goto first; first: foreach($standard_shipping as $standard) { if(array_key_exists($standard, $keys)) { $resultsArray = array_slice($resultsArray, 0,2); break; }else { goto second; } } second: foreach($free_shipping as $free) { if(array_key_exists($free, $keys)) { $resultsArray = array_slice($resultsArray, 6); break; }else { goto third; } } third: foreach($mail_shipping as $mail) { if(array_key_exists($mail, $keys)) { $resultsArray = array_slice($resultsArray, -3); break; } } How can I run through this type of method without using the 'goto' function?? Thanks in advance!

splendid i think i can work with this, thankyou!

Hi, I'm looking to see if there's an array function or method I can use to see if an array contains only one integer value. For example: Go through the array, if the array only contains the value 8 or multiple instances of the value 8:: do this else Go through the array, if the array contains the value 8 or multiple instances of the value 8 AND ANY OTHER NUMBER:: do something I've been working with 'in_array' but can seem to get the result I'm after :'(

hey andrew, Sorry for this and I do appreicate you time but after trying the query again with the removed comma I've noticed it's saying the error is at the: 'ON (O.id_customer = C.id_customer), ps_order_detail AS OD, I know this kind of query qould require and JOINS of some kind but I am inexperienced with MYSQL, do you have anywhere I could learn about these quickly or have anymore ideas how to get this working? Thanks!

When i try your example i get: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON (O.id_customer = C.id_customer), ps_order_detail AS OD, ' at line 24

I did give that a try but the same thing is still happening

I'm trying to grab a set of infomation which is unique to an Order ID. Currently, for this query it should return 4 results (4 products) but it's bringing back 66 I think this is because it'd returning duplicate values. Here's the Query I'm working with at the moment: SELECT O.`id_order`, O.`date_add`, O.`total_paid`, O.`total_shipping`, O.`delivery_date`, O.`invoice_date`, C.`id_gender`, AD.`firstname`, AD.`lastname`, AD.`company`, C.`email`, AD.`phone_mobile`, AD.`phone`, CONCAT(AD.`address1`, " ", AD.`address2`, " ", AD.`postcode`, " ", AD.`city`), CONCAT(AI.`address1`, " ", AI.`address2`, " ", AI.`postcode`, " ", AI.`city`), OD.`product_name`, OD.`product_quantity`, OD.`product_weight`, OD.`product_price`, M.`name` FROM ps_orders AS O, ps_customer AS C, ps_order_detail AS OD, ps_manufacturer AS M, ps_address AS AD, ps_address AS AI WHERE O.id_order = 28, AI.id_address=id_address_invoice AND AD.id_address=id_address_delivery AND C.id_customer=O.id_customer The 28 in this example will be inserted dynamically but for testing I'm using the number 28. If anyone can help me or needs any more info to help me, then please let me know! Thanks!

nope, I'm getting the data just fine and the arrays have what I want stored in them, it's just a case of extracting the data and presenting it in this way!

Hi, I just re-read this and I made it pretty unclear I want to achive, but this is it basically; Each time there is value in the $datas array, I want to match it against the $titleMonths array and to echo the values of data under the titleMonths value e.g ($items['month'] = 1) January 07/01/2010 29/01/2010 ($items['month'] = 4) April 03/04/2010 13/04/2010

I have an array of months: $titleMonths = array ( 0=> 'January', 1=> 'Febuary', 2=> 'March', 3=> 'April', 4=> 'May', 5=> 'June', 6=> 'July', 7=> 'August', 8=> 'Septmeber', 9=> 'October', 10=> 'November', 11=> 'Decem' ); I also have a list of values stored in a database, the month value for these values is stored as a $items['month'] which is an integer e.g 5 (for May) I'm trying to run a foreach loop that goes through the list of months, if the array position is the same as the month number, it'll echo the title for the month with all the values for that month underneath it. So far experimenting I've managed to echo just the $titleMonth values, echo the $titleMonth values for as many results as the database returns, but so far no donut! Here's what I've been working with ($dates is the rows returned from the database) $titleMonths = array ( 0=> 'January', 1=> 'Febuary', 2=> 'March', 3=> 'April', 4=> 'May', 5=> 'June', 6=> 'July', 7=> 'August', 8=> 'Septmeber', 9=> 'October', 10=> 'November', 11=> 'Decem' ); foreach($titleMonths as $month) { echo $this->_html .= $month; for($i = 0; $i < count($titleMonths); $i++) { foreach ($dates as $items) { echo $items['day'].'/'.$items['month'].'/'.$items['year'] } } } Please help in anyway you can!

I've got a table with some values in and a datetime field (fieldname: time). I want to be able to select the values from the current time (NOW()) until a week into the future. I've tried: SELECT * FROM dd_restriction WHERE (time(NOW(), INTERVAL 7 DAY)) But it's not working :'( what am I doing wrong?

I'm using a script that exports database details into a CSV file. I want to he script to work so that the data and headings are in columns like so: heading1 heading 2 heading 3 Data1 Data2 Data3 However with my current script I'm getting: Heading 1 Heading2 Heading 3 Data1 Data2 Data3 The data is from two seperate arrays ($columns and $data) and the following code is executed: public function build($columns, $data) { $csv = ''; // initialise csv variable foreach($columns as $heading) // csv column headings { $csv .= $heading.','; // concat heading onto row } $csv .= "\n"; // all the headings have been added so move to new line for csv content foreach($data as $row) // csv table content { foreach($columns as $column => $t) { echo $row[$column]; if(strpos($row[$column],',')) // if cell content has a comma in it... { // ...double any existing quotes to escape them... $row[$column] = str_replace('"','""',$row[$column]); // ...and wrap the cell in quotes so the comma doesn't break everything. $row[$column] = '"'.$row[$column].'"'; $csv .= "\n"; } $csv .= $row[$column].","; // concat the value onto the row if($t==end($columns)) { // if we're at the end of a row move to a new line for next row $csv .= "\n"; } } } return $csv; } Please any help would be appreicated!

Thanks alot squire! I'm familiar with your screen name from lees phpvideos aswell as your own site. Thanks alot and keep up the good work!