On Wednesday 22 August 2001 16:48, Jeremy Morano wrote:
>
> I was wondering if there was a way to retreive a column_name instead of a
> value in an sql select query?
>
> For example if my table has the field firstname, lastname, telephone,
> movie1, movie2, movie3......
>
>
> And my first record is John Doe 555-5555
> good bad bad
> My second record is Jane Doe 555-6666
> good good bad
>
> I would like to know which movies Jane Doe rated "good"'...............Is
> this possible and if so how?
Ouch! This is possible - that's what databases are here for ;-). However,
you'll want to think about normalizing your database structure.
Hint: you'll need three tables.
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a MySQL database is more fun than eating spam"
---------------------------------------------------------------------
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
