bios

thanks i actually got it working yesterday, but now i do need help selecting the file off the harddrive and inserting this it back into the database and updating the order status.

my whole code is this: <?php /******************************************** This code will extract the data from your table and format it for an excel spreadsheet download. It is very quick, simple, and to the point. If you only want to extract certain fields and not the whole table, simply replace the * in the $select variable with the fields you want to extract. /********************************************/ // Include Server parameters require(\'includes/configure.php\'); define(db_link, mysql_connect(DB_SERVER,DB_SERVER_USERNAME,DB_SERVER_PASSWORD)); mysql_select_db(DB_DATABASE); //Write the query, call it, and find the number of fields $select = "SELECT * FROM orders"; $export = mysql_query($select); $count = mysql_num_fields($export); //Extract field names and write them to the $header variable for ($i = 0; $i < $count; $i++) { $header .= mysql_field_name($export, $i)."t"; } // Extract all data, format it, and assign to the $data variable while($row = mysql_fetch_row($export)) { $line = \'\'; foreach($row as $value) { if ((!isset($value)) OR ($value == "")) { $value = "t"; } else { $value = str_replace(\'"\', \'""\', $value); $value = \'"\' . $value . \'"\' . "t"; } $line .= $value; } $data .= trim($line)."n"; } $data = str_replace("r", "", $data); //Set the default message for zero records if ($data == "") { $data = "n(0) Records Found!n"; } //Set the automatic download section header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=orders.xls"); header("Pragma: no-cache"); header("Expires: 0"); print "$headern$data"; ?>

Basically what I want to do is extract todays orders from a online store. $select = \"SELECT * FROM orders\"; But I only want it to extract todays date from my orders, or maybe orders with a status of pending or the number 3. My colum for date purchaced is named: date_purchased and it formats the date and time like this: 10/29/2003 9:28:16 PM. I want all with the date of today to be downloaded. My colum for orders status is named: orders_status and it formats the status by using a number: 1,2,3. I also want to have all with a status of 1 to be downloaded. Can anyone help me with this code?

I want my table locked at a 750 width and then display the php code from another page in it, but when I enter the code for the php file when it displays the output my table expands up and down, I dont want it to do this I want it to be locked in place. Any help on this?