You need to pass the functions a variable to work with because you've specified parameters. Try: $okuan = orderquantity($una); Ditto for the other function call. -- Peter Ellis - pellis@xxxxxxxxxxxxxxx Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Tue, 2004-09-07 at 13:09 +0200, Sancerni Veronica wrote: > 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 ! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php