am i doing something wrong here?
Code: Select all
$order_number = mysql_query($sql_ordernumber, $db) or die ("Execution failed for Order Number: ".mysql_error());
$order_row = mysql_fetch_row($order_number);thanx guysArray
Moderator: General Moderators
Code: Select all
$order_number = mysql_query($sql_ordernumber, $db) or die ("Execution failed for Order Number: ".mysql_error());
$order_row = mysql_fetch_row($order_number);thanx guysArray
Code: Select all
print_r($order_row);
#
foreach ($order_row as $row) {
echo $row['whatever_field'];
}Code: Select all
$sql_ordernumber = "SELECT * from orders WHERE O_CookieID = '$CookieID'";
$order_number = mysql_query($sql_ordernumber, $db) or die ("Execution failed for Order Number: ".mysql_error());
$order_row = mysql_fetch_row($order_number);
$O_Id = $row['O_Id'];Code: Select all
$sql_ordernumber = "SELECT * from orders WHERE O_CookieID = '$CookieID'";
$order_number = mysql_query($sql_ordernumber, $db)
or die ("Execution failed for Order Number: ".mysql_error());
$order_row = mysql_fetch_assoc($order_number);
print_r($order_row);
$O_Id = $row['O_Id'];Code: Select all
$sql_ordernumber = "SELECT * from orders WHERE O_CookieID = '$CookieID'";
$order_number = mysql_query($sql_ordernumber, $db) or die ("Execution failed for Order Number: ".mysql_error());
$order_row = mysql_fetch_assoc($order_number);
print_r($order_row);
$O_Id = $row['O_Id'];
#Finished inserting
print_r($O_Id);Code: Select all
while($order_row = mysql_fetch_assoc($order_number)) {
print $order_row['O_Id'];
}Code: Select all
$order_row = mysql_fetch_assoc($order_number);
print_r $order_row['O_Id'];Code: Select all
$sql_ordernumber = "SELECT `O_Id` from `orders` WHERE `O_CookieID` = '$CookieID'";Ah..sorry - I forgot to replace $row with $order_rowC_Calav wrote:i cant seem to print the O_Id to screen?
Code: Select all
$sql_ordernumber = "SELECT * from orders WHERE O_CookieID = '$CookieID'";
$order_number = mysql_query($sql_ordernumber, $db)
or die ("Execution failed for Order Number: ".mysql_error());
$order_row = mysql_fetch_assoc($order_number);
print_r($order_row);
$O_Id = $order_row['O_Id'];