HaggisQueen

Thanks to you both for the time you took to reply and for your suggestions, neither of which worked unfortunately. I am going to go back to the drawing board and rethink my approach to this as I know that there has to be a more simpler way of doing this. gnerjm is right, the query being used (while it works in MySQL) needs to change as I think this is the problem.

“<?php include("session.php"); ?> <!--get customer information for customer name selected in view_customer_list--> <?php $business_name = $_GET['business_name']; $this_query = "Select business_name, account_num, main_contact, business_phone, business_email, business_suite, business_address, business_city, business_region, business_province, business_postal FROM orders WHERE sale_datetime in (Select Max(sale_datetime) from orders Group by business_name) and business_name = '$business_name' ORDER BY business_name ASC "; $result = mysql_query($this_query); $row_customer = mysql_fetch_array($result); ?>

Hello! I have a php page which shows a list of customers displayed in an html table format, The first column in the table contains a link for the user to select the row which then navigates to another php page, which is the customer order page. On this page, I want to get certain information based on the name of the customer to prepopulate the customer fields on this form, so I have some php code near the top of the page, as per attached document. I have checked to ensure that the $_GET['business_name'] contains a value. The query runs fine in myssql and returns only one record when I provide a value for the business_name, however when I run the code in php, the $result variable shows 'Resource id ='7' type='mySQL result'. I am a total newbie on PHP/MySQL and inherited this application. I have tried to find solutions on line through various forums, but no luck. Perhaps I am not asking/looking for the right question. Anyway, any assistance would be greatly appreciated. customer_order_php.php