hi. this doesn't have to do with mysql_fetch_array. the following will
create that error :
echo "a $b['c'] d e f";
the following will not :
echo "a $b[c] d e {$f['g']} h i $j[$k] l 'm' n o p";
adjust accordingly. just posted a few words on this topic recently, can
view them here :
http://marc.theaimsgroup.com/?l=php-general&m=100152166602273
regards,
Philip Olson
On Thu, 27 Sep 2001, Web user wrote:
> System: PHP4.06 + Mysql3.23.41 Win32 + Apache 1.3.20 Win32 + Win98
>
> 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\htdocs\web\site1\list.php on line --[the number of line]"
>
> What's the problem wiht mysql_fetch_array() or other?
> What does the T_STRING' or `T_VARIABLE' or `T_NUM_STRING' mean?
>
> THANKS
> Mike
>
>
> The full code below:
> ----------------------------------------------------------------------------
>
> <?
> $link=mysql_connect("localhost","","");
> if($link==false){
> echo "Failed linking to database.";
> exit();
> }
> $handler=mysql_select_db("database1");
> if($handler==false)
> echo "Failed linking to database.";
> $query="selct count(*) from users where sign=1";
> $res=mysql_query($query);
> $row=mysql_fetch_row($res);
> $all=$row[0];
> $step=5;
> $pages=ceil($all/$step); /*the number of pages needed to listed */
> if(empty($offset))
> $offset=0;
> $query="select user_id, user_name, time, status, comment from users
> where sign=1
> order by user_name
> limit $offset, $step";
> $res=mysql_query($query);
> echo "<table><td align=center>User</td>
> <td align=center>Added time</td><td align=center>Status</td></tr>";
> $num=mysql_num_rows($res);
> for($i=0; $i<$num; $i++) {
> $arr=mysql_fetch_array($res); /* HERE is line where the error occurs!!!
> */
> echo "<tr><td align=center><a href=\"profile.php?id=$arr['user_id']\"
> target='_top'>
> $arr['user_name']</a>></td>";
> echo "<td align=center>$arr['time']</td>";
> echo "<td align=center>$arr['status']</td></tr>";
> echo "<tr colspan=3><td>$arr['comment']</td></tr>";
> }
>
> echo "</table><br><br><br>";
>
> echo "<table><tr><td align='center'>"; /* show others in multi-pages */
> for($i=0; $i<$pages; $i++){
> echo "<a href='$PHP_SELF?offset=$i*$step' target='_top'>
> echo ($i+1)."</a>";
> echo " ";
> }
> echo "</td></tr></table>";
>
> ?>
>
> ----------------------------------------------------------------------------
> -
> create table users (
> user_id int not null auto_increment primary key,
> user_name varchar(30),
> time datetime,
> status tinyint(1),
> comment text,
> sign tinyint(1) default '1'
> );
>
>
>
>
>
>
>
> --
> PHP General 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 General 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]
