Forum Moderators: coopster
should do the trick :)
but the rest should be ok, I really dont see anything terribly wrong.....
Notice: Undefined variable: order_status_selector in D:\Fluke_Mambo\components\com_confirmation\order_status_finance.php on line 77
the mysql error only displays errrors :p and u get unexplained errors without the mysql_error
ofcourse, thats why it is there....
if the script reports an error why dont you fix it?
leaving it out will not fix the error.....
$query =
"SELECT order_id,
order_status_it,
order_status_manager,
order_status_finance
FROM $table
WHERE order_id NOT IN (select order_id FROM mos_pshop_order_user_info WHERE country ='$mycountry')";
$result = mysql_db_query("$Database",$query);
list($order_id,$order_status_it,$order_status_manager,$order_status_finance)=mysql_fetch_row($result); {
echo func_order_status_selector($order_status_finance);}
then it displays nothing again
<?
function func_order_status_selector($order_status){
$order_status_selector.= "<select name=\"order_status\" size=\"1\">\n";
{
if (empty($_POST['order_status'])){
$order_status_selected = $order_status;
}
if (isset($_POST['order_status'])){
$order_status_selected = $_POST['order_status'];
}
$poss_order_statusses = array('accepted', 'pending', 'cancelled');
foreach ($poss_order_statusses as $poss_order_status){
// build the options...
$order_status_selector.= "<option value=\"$poss_order_status\"";
if ($poss_order_status == $order_status_selected)
{$order_status_selector.= " selected ";}
$order_status_selector.= ">$poss_order_status</option>\n";
}
// close the select tags
$order_status_selector.= "</select>";
}
return $order_status_selector;
}
require($_SERVER['DOCUMENT_ROOT'].'/includes/connect.php'); //DB connect info
require($_SERVER['DOCUMENT_ROOT'].'/includes/functions.php');//all your functions, put func_order_status_selector() function code into the file
$table = "mos_pshop_orders";
$sessiontable= "mos_session";
$usertable = "mos_users";
$query = "SELECT name, username, country FROM $usertable WHERE username = '$my->username'";
$result = mysql_query($query) or die ("Error in query: $query " . mysql_error());
while(list($name,$username,$country) = mysql_fetch_row($result)){
echo "Welcome $name<br><br>"
$mycountry = $country;
;}?>
<table><?
//get order statusses
$query = "SELECT order_id,order_status_it,order_status_manager,order_status_finance FROM $table
WHERE order_id NOT IN (select order_id FROM mos_pshop_order_user_info WHERE country ='$mycountry')";
$result = mysql_query($query) or die ("Error in query: $query " . mysql_error());?>
<form name="change_order_id" method="post" action="components/com_confirmation/confirm_order_status_update.php">
<? //do not put the form opening tag inside a loop, as you will only need one form for this......
while($row = mysql_fetch_array($result)){?>
<tr>
<td><strong>order id:</strong></td>
<td><? echo $row['order_id'];?></td>
</tr>
<tr>
<td><strong>current status:</strong></td>
<td><? echo $row['order_status_finance'];?></td>
</tr>
<tr>
<td><? echo func_order_status_selector($row['order_status_finance']);//this is where we use the function!?></td>
<td>
<input type="submit" name="submit" value="Update status" class="button">
<input name="order_id" type="hidden" value="<? echo $row['order_id'];?>">
<input name="order_status_manager" type="hidden" value="<? echo $row['order_status_manager'];?>">
<input name="order_status_it" type="hidden" value="<? echo $row['order_status_it'];?>">
</td>
</tr>
</form>
<form action="components/com_confirmation/billing_shipping_info.php" target="_new" name="info_order_id" >
<tr>
<td>
<input name="id" type="hidden" value="<? echo $row['order_id'];?>">
<input type="submit" value="order <? echo $order_id info;?>" action="submit" class="button">
</td>
<td> </td>
</tr>
<? }?>
</form>
</table>
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in D:\Fluke_Mambo\components\com_confirmation\order_status_finance.php on line 86
Fatal error: Cannot redeclare func_order_status_selector() (previously declared in D:\Fluke_Mambo\components\com_confirmation\order_status_finance.php:2) in D:\Fluke_Mambo\includes\functions.php on line 26
you can only declare a function once and since it now is in a include AND inside the script, there error will show
wups well it cant find the database now but there is nothing asking for it in the script
is the error
<? @ $db = mysql_connect('localhost', 'mysql_user_name', 'mysql_user_password');?>
do a
@mysql_select_db('fluke');
somewhere at the beginning hehehe
