Re: Re: mysql_fetch_array() doesn't work

My opinion is that there is a problem with the $query. May be the problem is like this select fname from some_table where lname=Smith; this is not good sql. I missed the quotes around Smith. or you make varaible substitution in the query string. Debug the code, instead of mysql_query($query); do var_dump($query) and see what you send to mysql. you may also use mysql_error(hmm no sure about the name). Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS ----- Original Message ----- From: "Rick Emery" <remery@excel.com> To: <php-db@lists.php.net> Sent: Tuesday, September 25, 2001 4:17 PM Subject: RE: [PHP-DB] Re: mysql_fetch_array() doesn't work > I agree with Steve. > > Also, print value of $num; is it 0? Is $res valid; is it NULL? > > We need far more details than what you think we need. > > -----Original Message----- > From: Steve Brett [mailto:steve.brett@e-mis.com] > Sent: Tuesday, September 25, 2001 6:34 AM > To: php-db@lists.php.net > Subject: [PHP-DB] Re: mysql_fetch_array() doesn't work > > > there doesn't look to be any problem with the code you've shown. > > it would be helpful, however, if you included the full error including the > line and the lines surrounding this point as the error probably lies in > previous code. > > Steve > > "Web User" <random11@telekbird.com.cn> wrote in message > news:008501c1459e$5dd87260$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 > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >