In message <[EMAIL PROTECTED]>, libertyhosting
<[EMAIL PROTECTED]> writes
>$count = $db->Num_rows($sql);
>
>echo $count."<p>";
>                                         
>$arr = $db->Fetch_array($sql);
>                                                         
>foreach($arr as $key=>$value){
>   echo $key." => ". $value. "<br>";   
>}
>exit;
>
>Now, $count returns 2 record, however only one is being returned in 
>the foreach loop.
>
>Can anyone shed some light?

You have only asked for one row,
>$arr = $db->Fetch_array($sql);

you need a loop around it...

-- 
Pete Clark

http://www.hotcosta.com
http://www.spanishholidaybookings.com




------------------------ Yahoo! Groups Sponsor --------------------~--> 
<font face=arial size=-1><a 
href="http://us.ard.yahoo.com/SIG=12hre3tkf/M=362329.6886308.7839368.1510227/D=groups/S=1705375618:TM/Y=YAHOO/EXP=1124486386/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</a>.</font>
--------------------------------------------------------------------~-> 

The php_mysql group is dedicated to learn more about the PHP/MySQL web database 
possibilities through group learning.  
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php_mysql/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Reply via email to