Page 1 of 1
fetch row
Posted: Thu Apr 07, 2005 10:25 pm
by C_Calav
hi guys,
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);
getting a results of
Array
thanx guys
Posted: Thu Apr 07, 2005 10:38 pm
by ol4pr0
Code: Select all
print_r($order_row);
#
foreach ($order_row as $row) {
echo $row['whatever_field'];
}
Posted: Thu Apr 07, 2005 10:59 pm
by C_Calav
hi thanx for your help,
im not too familair with your code sorry, but i see what your doing.
i tried to change mine a bit.
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'];
i only want O_Id pulled from the DB.
now it is out putting nothing??
thanx
Posted: Thu Apr 07, 2005 11:09 pm
by anjanesh
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'];
Posted: Thu Apr 07, 2005 11:53 pm
by C_Calav
thanx anjanesh,
i cant seem to print the O_Id to screen?
am i doing anything wrong?
print_r($order_row); this here prints the O_Id but i cant print it on its own.
thanx
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);
Posted: Fri Apr 08, 2005 12:22 am
by marike
Code: Select all
while($order_row = mysql_fetch_assoc($order_number)) {
print $order_row['O_Id'];
}
or try:
Code: Select all
$order_row = mysql_fetch_assoc($order_number);
print_r $order_row['O_Id'];
Unless I'm missing something silly, it should work. Hope this helps.
Jcart | Typo
Posted: Fri Apr 08, 2005 1:00 am
by John Cartwright
Code: Select all
$sql_ordernumber = "SELECT `O_Id` from `orders` WHERE `O_CookieID` = '$CookieID'";
No use on fetching columns you arn't using

Posted: Fri Apr 08, 2005 1:58 am
by anjanesh
C_Calav wrote:i cant seem to print the O_Id to screen?
Ah..sorry - I forgot to replace $row with $order_row
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'];