Drop the semi-colon off the end of the SQL Statement you wish to run. You
don't need them in the phpMyAdmin SQL Window.
Enjoy,
Tyrone
----- Original Message -----
From: "Tommy Beavitt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 8:31 AM
Subject: Re: phpMyAdmin newbie problem
> At 10:23 am +0100 19/6/01, Tommy Beavitt wrote:
> >
> >I am wondering why I am unable to use the SELECT statement to access
> >data in a MySQL (3.22.32) database I have created using phpMyAdmin
> >(2.1.0). Everything else about it is a delight to use (I am
> >migrating from SQLAnywhere) and I have managed to create tables and
> >insert data into them no problem. But every time I use a SELECT
> >statement I get the error:
> >
> > Error
> >
> >SQL-query:
> >
> >select *
> >from books;
> >
> >MySQL said:
> >Back
> >
> >Obviously I am making a wrong assumption somewhere. The
> >documentation I have checked is the official MySQL manual but this
> >does not relate specifically to phpMyAdmin and certainly does not
> >prohibit SELECT statements!
> >
>
> But nobody picked up on it. Does anyone know of a good discussion
> list relating specifically to phpMyAdmin?
>
> Thanks
>
> Tommy
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
