Well, at least this message has slightly more in it than your previous
one, but it doesn't actually have ANY useful information in it, such as:
WHAT LANGUAGE ARE YOU USING ?
On Sat, 16 Jan 1999, Darren Sweeney wrote:
>
> How do I return a string value from SELECT COUNT(*) FROM tbl_name ?
>
> e.g. $count = SELECT COUNT(*) FROM tbl_name
See above ...
> Also,
>
> Lets say I have 100 lines of data from 10 users ... 10 lines each ...
> how do I select only one line from each user?
>
> Do I use the unique statement and does the field have to be indexed? If
> so, can one index a field which is already created?
What is your schema ?
You don't need a field to be indexed to use 'unique'
Tha answer to the other question is something like:
alter table mouse add index squeak
But your field would have top be not null. If it isn't you will need to
make it NOT NULL first. See the MANUAL for more details.
Alistair
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
