I am posting again to see if I can get another idea where to go with this one. My DB is set up and all my information is set to be called properly. I am not sure what could be causing the problem or what road I could head down to figure out the fix anymore.
The only thing I can figure is that the syntax is not right since everything worked on a linux server but it’s not working on a windows server. So, if anyone could point me in the right direction I would appreciate the help. Below is the code that resutls in the following errors:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:Program Filesxampphtdocsordersclassesorder.php on line 1416
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:Program Filesxampphtdocsordersclassesorder.php on line 1419
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:Program Filesxampphtdocsordersclassesorder.php on line 1422
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:Program Filesxampphtdocsordersclassesorder.php on line 1429
[code]function orderSummary ( $orderID, $userID ) {
$queryOrder = "select * from orders where ID=".$orderID;
$orderInfo = mysql_fetch_array ( mysql_query ( $queryOrder ) );
$queryStatus = "select name from status where ID=".$orderInfo['statusID'];
$orderStatus = mysql_fetch_array ( mysql_query ( $queryStatus ) );
$queryRequestor = "select firstName, lastName from teamMembers where ID=".$orderInfo['requestorID'];
$requestorInfo = mysql_fetch_array ( mysql_query ( $queryRequestor ) );
$queryUserInfo = "select * from teamMembers where ID=".$userID;
$userInfo = mysql_fetch_array ( mysql_query ( $queryUserInfo ) );
$queryTLInfo = "select * from teamMembers where ID=".$orderInfo['approverID'];
$resultTLInfo = mysql_query ( $queryTLInfo );
$tlInfo = mysql_fetch_array ( $resultTLInfo );[/code]