Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

is it possible ?????????????...

Codes here !

Moderators: macek, egami, gesf

is it possible ?????????????...

Postby cho@ » Thu Aug 29, 2002 8:13 am

I knw dat its possible to force mysql to create a temporary table with the option

SQL_BUFFER_RESULT

but i like to knw if its possible to do a SELECT in this table ??????? and if yes how?

My prob is that i wanna do a kind of left jonction on the same table ?!?...I knw its sounds wierd but its like dat....

So i have two queries
the first one:
SELECT LName, FName, forum.date, views, content, idlink, forum.id FROM member, forum WHERE forum.type LIKE 'topic' AND forum.authorID = member.ID ORDER BY date DESC

the second one
SELECT t1.*, t2.date FROM forum AS t1, forum AS t2 WHERE t1.id = t2.idlink ORDER BY t2.date DESC

I d like to do the second one on the result of the first one....
is it possible...
thanxs for your help
cho@
New php-forum User
New php-forum User
 
Posts: 39
Joined: Tue Aug 06, 2002 8:58 am
Location: UK

Postby DoppyNL » Thu Aug 29, 2002 11:00 am

double post: http://www.php-forum.com/p/viewtopic.php?t=199

VERY annoying, please don't do it, just post you're question in the forum wich suits you're question most. (wich of the 2 you posted, is here, but I allready replyed in the other)
tnx.

Greetz Daan
DoppyNL
 


Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 0 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron