error on count()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hello, this is problably newbie question, but I can not understand why my count() function doesn't work. I need to count how many items has a determinated customer ordered ever.
 
1. I tired to get the array like this:
 $una = $check["uname"];
function orderquantity ($una) {
  $pss = mysql_query("SELECT OID FROM orders WHERE una = '".trim($una)."'") or die (mysql_error("Query error on Order search"));
  while($pisao=mysql_fetch_array($pss)) {
  return count($pisao);
  }
}
$okuan = orderquantity();
 
2. and like this:
 $una = $check["uname"];
function orderquantity ($una) {
  $pss = mysql_query("SELECT OID FROM orders WHERE una = '".trim($una)."'") or die (mysql_error("Query error on Order search"));
   return count($pss);
}
okuan = orderquantity();
 
None of them gave me a valid value, is it because the OID is an int value?

		
---------------------------------
Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage !
Créez votre Yahoo! Mail

Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis.Téléchargez GRATUITEMENT ici !

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux