Help on this Optimization!

[Gayner]

$DB->query("SELECT cl.*, f.id AS to_desktop, a.desktop as jesktop
FROM ibf_faq AS cl
INNER JOIN ibf_members AS f ON f.name = cl.editor
INNER JOIN ibf_members AS a ON a.name = cl.editor
     where cid = $id ");

 

Instead of keep putting more

INNER JOIN ibf_members AS a ON a.name = cl.editor

is there way to call all what i want from ibf_members instead of making new lines each time?

[ignace]

denormalise parts of your db

[Gayner]

denormalise parts of your db

 

lol that makes perfect sence.. ^^

[ignace]

denormalise parts of your db

 

lol that makes perfect sence.. ^^

 

Yeah it does. You create joins because of created relationships if you lower the number of relationships then so do your number of joins. If you don't know what denormalisation is then look up what db normalisation is (denormalisation is the reverse process).

[Gayner]

denormalise parts of your db

 

lol that makes perfect sence.. ^^

 

Yeah it does. You create joins because of created relationships if you lower the number of relationships then so do your number of joins. If you don't know what denormalisation is then look up what db normalisation is (denormalisation is the reverse process).

 

That's like telling nto to post here if i dont have a question..

 

Is there anyway u can asnwer my question man? about the database issue not denormailising.. thx

[ignace]

With an attitude like that no sorry can't help ya.

[Gayner]

With an attitude like that no sorry can't help ya.

 

Attitude? your the one who started it..