Re: warning 1 is not mysql result index

still did not work. Keep returning the same error when I do this: $HotelName = mysql_fetch_row($resultHotel,1) or die(mysql_error()); And once again I am very sure there is data in the table. and the error keep saying that : 1 is not Mysql index. I don't see why? can anyone tell? cheers Jack jacky@activelifestyle.com "There is nothing more rewarding than reaching the goal you set for yourself" ----- Original Message ----- From: Christopher Allen <callen@driver8.org> To: Jacky@lilst <jacky@activelifestyle.com>; <php-general@lists.php.net> Sent: Thursday, January 25, 2001 12:39 AM Subject: Re: [PHP] warning 1 is not mysql result index > > > I want to get the result from first row (the one next from ID field) of the > table using > $HotelName = mysql_result($resultHotel,0,1) or die(mysql_error()); > > A suggestion: > Why don't you use mysql_fetch_row or any other function that reaches > beyond just getting 1 field? > this would be easier perhaps for you visualize the data you are trying to > get. > > http://www.php.net/manual/en/function.mysql-fetch-row.php > > > > >