On Wed, 27 Jun 2001 12:34, Marco Bleeker wrote:
> For the first time developing a PHP-MySQL system, I am experiencing
> strange things. Perhaps it is the off-line mode (Localhost) I am
> running Apache in, or my Wintel 98SE Pentium3. So I create and populate
> 3 small tables in a database with a standard little PHP script. Then I
> start working on my other PHP scripts and testing them out. Of course
> there are mistakes, like forgotten semicolons or a left bracket where
> it should be a right one (parse errors), and I correct them, untill I
> get a nice output on my screen. But suddenly - "Offset 0 is not valid
> for this result set". This is a mysql_data_seek() error, but that is
> probably a coincidence. The point is: MySQL suddenly thinks that the
> database is empty, as if it was destroyed.
You are making a wrong assumption here. In fact, the result set returned
by the query (not the database itself) has a problem - quite likely you
are trying to cycle through an empty result set. Perhaps you need to trap
the case where your query returns no results? Or perhaps you may be able
to structure your PHP code better.
In any case, the problem is not with Mysql - perhaps if you were to
enquire on the PHP list with a code sample?
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
I was arrested for selling illegal sized paper.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
