On Mon, May 29, 2000 at 12:50:39PM +0100, Comerford, Wayne mentioned:
> I've been using Webadmin. Which until now has been great.
> I'm no SQL chap, so creating and removing Databases is easy with Webadmin.
> But can someone tell me how to remove data from a database with out dropping
> the whole table.
>> I've got this website where people can enter someone and vote using a php
> page which i bastardised.
> Basically somebody has submitted the same name twice.
> If i was a code head I'd write something to validate it but unfortunately
> I'm really crap when it comes to coding. and I've no SQL books to help me
> either.
> So RTFM will happen soon, when i get a book. Any recommendations for
> complete beginner?
See can you steal the "Oracle SQL reference" thing from someone. I just
learned from reading other peoples SQL code, and just working out the
syntax.
delete from tablename where field1 = 'seomthing' and field2 = 'somethgin';
Kate
--
"The fool must be beaten with a stick, for an intelligent person
the merest hint is sufficient" -- Zen Master Greg
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!