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 :roll:

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'];