Then add a language column and initialize it to the table name.
Deryck Henson wrote:
> 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]
--
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
