while ($row= mysql_fetch_array($result,MYSQL_ASSOC))
{
foreach ($row as $value){
print ("$value |");
}
}
----- Original Message -----
From: "Jack" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 6:16 PM
Subject: [PHP-DB] Couldn't get all data using the "mysql_fetch_array" function, Pls
Help!!!!
> Dear all
> I was trying to fetch all the data from one of my table "leaverequest", but
> i couldn't fetch all the data if i use the * .
> here is my program, this one is only fetch the Reason field, but what i want
> is all the data.
>
> <?
> $dblink=mysql_pconnect("microsoft","console","edshk");
> mysql_select_db("nedcorhk",$dblink);
> $query = "select * from leaverequest";
> $result=mysql_query($query,$dblink);
>
> while ($row= mysql_fetch_array($result,MYSQL_ASSOC))
> {
> print ("{$row["Reason"]}");
> }
> ?>
>
> But can i do it like that way to get all the data? (Showing below) :
>
> <?
> $dblink=mysql_pconnect("microsoft","console","edshk");
> mysql_select_db("nedcorhk",$dblink);
> $query = "select * from leaverequest";
> $result=mysql_query($query,$dblink);
>
> while ($row= mysql_fetch_array($result,MYSQL_ASSOC))
> {
> print ("{$row["*"]}");
> }
> ?>
>
>
> Pls help me!!
>
> Thx
> jack
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]