Need some help with this query.

[Hart_House]

I have a query that I just can't seem to figure out.

I want to select links from the same category that link is in.

query = "select * from idx_link where category_id = (to same category that link is in) order by title";

[esm]

Content visible to License Owner only.

[Hart_House]

Fatal error: Call to a member function on a non-object on:

$category_id = $result->Fields("category_id");

I'm basically trying to insert this query into the detail.php page.


Where am I going wrong?

[esm]

try changing $link_id to $linkid

[Hart_House]

its not the $linkid or $id which I have tried.

For some reason it get an error on that one important line

$category_id = $result->Fields("category_id"); which prevents me from isolating the category_id

why oh why...

When i put $category_id = 200; it works for category 200... but thats not what i want... boo

[esm]

send me your detail.php file

[Hart_House]

OK. I fixed it.

$result1 = $conn->Execute($query);

$category_id = $result1->Fields("category_id");

All i had to do was place a 1 after the result...

[TLC]

Shouldn't something be pass to $result first before trying to extract something from it

[esm]

here is the code to make it work:

Content visible to License Owner only.