Re: Version errors?

[Paul DuBois]

At 8:50 AM -0500 9/25/99, Yuval Malchi wrote:
>Hi All,
>
>We've built a Mysql database for a web site and it
>works fine on our machine.  When we import it to the
>database server on the ISP site, it gives back lots of
>errors.  I have a few questions:
>
>1. Is there a command to find the version of Mysql
>they're using?  I have access to their database.

SELECT VERSION() will tell you the version of the server.

>
>2.  Anyone ever see this error:
>
>Warning: 0 is not a MySQL result index in
>/u/web/beetr2/pushonline/new_member.php3 on line 17

Generally this means you're not doing proper error checking in
your PHP script.  This often results from issuing a mysql_query()
call and then not checking whether or not the query actually
succeeded.

--
Paul DuBois, paul@stripped