How to use joined querys.

[Andy11548]

Just a quick question, I got told I should use joined querys, how would I use this query?

 

SELECT * FROM `forum_cats` AS cats, `forum_subs` AS subs, `forum_topics` AS topics, `forum_replys` AS replys, `users` AS users WHERE subs.cat=cats.name AND topics.sub_cat_id=subs.id AND replys.sub_cat_id=subs.id AND users.username=replys.username ORDER BY cats.id ASC, replys.id DESC

[Adam]

Just like any other query?

[Andy11548]

Well, I get this error...

 

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, string given in C:\wamp\www\test.php on line 6

 

OR

 

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in C:\wamp\www\test.php on line 6

[gristoi]

how exactly are you trying to execute the query?

[Andy11548]

The only way I know using mysql_query.

 

I've not been able to find a tutorial on it, so I've been playing the guessing game with some help from people.

[gristoi]

ok, can you post complete example of a query you are trying to execute. Its a bit hard trying to help you when we cant see what can be causing the issue. there is only so much I can guess at

[Andy11548]

Sure thing

 

<?php
session_start();
include './includes/mysql/connect.php';

$query = 
("
SELECT *
FROM `forum_cats` AS cats, `forum_subs` AS subs, `forum_topics` AS topics, `forum_replys` AS replys, `users` AS users
WHERE subs.cat = cats.name
AND topics.sub_cat_id = subs.id
AND replys.sub_cat_id = subs.id
AND users.username = replys.username
ORDER BY cats.id ASC , replys.id DESC
") or die(mysql_error());
$fetch = mysql_fetch_array($query);
?>

 

It's on my test page so I never ruined the rest of my code, so thats litterally everything.

 

I don't like this joined query stuff, haha .

[gristoi]

you havent executed the query. You need to execute the query to get the resource id THEN use any fetch commands to retrievfe the data. it should look something like this:

<?php
session_start();
include './includes/mysql/connect.php';

$query = 
("
SELECT *
FROM `forum_cats` AS cats, `forum_subs` AS subs, `forum_topics` AS topics, `forum_replys` AS replys, `users` AS users
WHERE subs.cat = cats.name
AND topics.sub_cat_id = subs.id
AND replys.sub_cat_id = subs.id
AND users.username = replys.username
ORDER BY cats.id ASC , replys.id DESC
") ;
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)){

// output the results . ie $row['item1'];

}
?>

[Andy11548]

Wow, thats what being tired does to you, makes you miss stupid things like "mysql_query" out haha.

 

I feel dumb, how the hell didn't I notice that? :S

 

Thanks for noticing haha.

 

~Andy

[gristoi]

coding + tired = mistakes

[Andy11548]

Yep, I normally stop coding when I'm tired, but I need something to keep me awake haha.

 

Anyways mate, thanks for that.

 

~Andy