Re: mysql_fetch_array() doesn't work
| From: | Pedja | Date: | Wed, 26 Sep 2001 03:18:34 +0000 |
| Subject: | Re: mysql_fetch_array() doesn't work | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-68804@lists.php.net to get a copy of this message | ||
array mysql_fetch_row (resource result)
MySql_fetch_array returns an array that corresponds to the fetched row, or
FALSE if there are no more rows. So put MySql_fetch_array in FOR loop. Look
like this:
for ($count = 1; $row = mysql_fetch_row ($query_result_handle); ++$count)
{
.......
}
...the same thing with WHILE:
a)
while ($row = mysql_fetch_row ($query_result_handle))
{
...............
}
b)
while (list($first, $second) = mysql_fetch_row($resource)) {
[...]
}
"Web User" <random11@telekbird.com.cn> wrote in message news:008601c1459e$5f853800$6a915fd3@hexiao...
> System: PHP4.06 + Mysql3.23.41 Win32 + Apache 1.3.20 Win32 + Win98
>
>
> <?
> ......
> ......
> $res=mysql_query($query);
> $num=mysql_num_rows($res);
> for($i=0; $i<$num; $i++){
> $arr=mysql_fetch_array($res);
> ...
> }
> ...
>
> When PHP is running at the line: $arr=mysql_fetch_array($res);
> The IE always show info as below:
> "Parse error: parse error, expecting
T_STRING' or
> T_VARIABLE' or
> `T_NUM_STRING' in
> c:\program files\apache group\apache\...\page.php on line ..."
>
> What's the problem wiht mysql_fetch_array() or other?
>
> Thanks!
> Mike
>
>
>
>
>
>