Hello:
I would actually disagree with [EMAIL PROTECTED]
The mysql_query() function does not require both database and query as arguments,
only query.
The mysql_db_query() function does, thus the function name. Using mysql_query()
with database as a parameter would actually be incorrect. (See the PHP manual for
details on these two functions?)
I can't tell from the code snippet, but it may not be working because there's no
database connection defined.
Cheers,
db
[EMAIL PROTECTED] wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Chris Hogben,
>
> > I've just been looking at this snippet, and wondering why it's not working..
> > Either i'm doing something wrong, or i'm just totally ignorant.. (More
> > likely the latter). But if anyone can help me out, please let me know..
> >
> > ---
> >
> > $query = "SELECT * from counter";
> > $result = mysql_query($query);
>
> incorrect - must be mysql_query($database,$query);
>
> or better you use mysql_db_query(...), in this case a
> id will generated if no id for the query-executing is generated.
>
> > $numone = mysql_numrows($result);
> > $i = 0;
> > while ($i <= $numone) {
> > $seekrow = mysql_data_seek($result, $i);
> > $fetchrow = mysql_fetch_row($result);
> > $time = $fetchrow["time"];
> > echo "$i = $time<br>";
> > $i++;
> > }
> >
> > ---
> >
> >
> >
> > --
> > PHP Database 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]
>
> - ----------------------------------
> E-Mail: [EMAIL PROTECTED]
> Date: 01-Jan-2002
> Time: 13:48:00
>
> This message was sent by XFMail
> - ----------------------------------
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.6 (GNU/Linux)
> Comment: Weitere Infos: siehe http://www.gnupg.org
>
> iD8DBQE8MbCfEK4asBW3N7wRArMPAKC2GPb8uwDgEUn2dOZG2B2PkXESSACgkDIQ
> oFxpZgl8eue2n39eG71O0uw=
> =DK3J
> -----END PGP SIGNATURE-----
>
> --
> PHP Database 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]
--
----------
Dan Barton
Terrestrial Program Biologist
Data Manager
Point Reyes Bird Observatory
http://www.prbo.org
[EMAIL PROTECTED]
[EMAIL PROTECTED]
--
PHP Database 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]
