Sure...
SQL Query:
SELECT * FROM asp, c, cpp, java, javascript, coldfusion, xml, pascal, vb,
perl, cgi, php, assembly, python where user = '"&user&"'
(gets an ambiguous error and I know why)
Database structure (all tables the same)
Tables- ASP, C, CPP, Java, Javascript, Coldfusion, XML, VB, Pascal, Perl,
CGI, PHP, Assembly, Python, dHTML
Columns- user text, email text, homepage text, code longtext, tutorial
longtext, codetype enum ('file', 'file-sourcecode', 'tutorial',
'file-tutorial', 'sourcecode'), file_path text, title text, description
text, codeid text, rating int, votes int, views bigint, date_created
datetime, level enum ('all', 'novice', 'intermediate', 'advanced')
- Deryck H
- http://www.comp-u-exchange.com
----- Original Message -----
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 10:00 AM
Subject: Re: using LEFT JOINS
> Show us your table definitions, what you tried, and
> what you think didn't work.
>
>
>
> Deryck Henson wrote:
>
> > Well, before I asked which joins to use and now I want to know how to
use
> > the LEFT JOINS. They would be quite useful on my site right now. Any
help
> > is appreaciated and dont say to read the manual cause Ive tried that and
it
> > doesnt give a good enough explanation. This will be very helpful when
> > displaying my database tables.
> >
> > - Deryck H
> > - http://www.comp-u-exchange.com
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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
>
>
> --
> Gerald L. Clark
> [EMAIL PROTECTED]
---------------------------------------------------------------------
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