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]

$query = "SELECT * from  idx_link where link_id = $link_id";
$result = $conn->Execute($query);

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

query = "select * from idx_link where category_id = $category_id order by title";
$result = $conn->Execute($query);

[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:

    ///hot links hack ******************
   $hot_links_obj = new clsLink;
   $hot_links_obj->InitDB($dbServer,$dbHostname,$dbUsername,$dbPassword,$dbName);
   $hot_links_obj->table_name = "idx_link";
   $hot_links_obj->category_table_name = "idx_category";  
   $hot_links_obj->max_rows = $main_hot_links;
  
  $queryh = "select * from idx_link where link_id = '$id'";
  $resulth = $conn->Execute($queryh);

  $category_id = $resulth->Fields("category_id");
  
  $hot_links_obj->queryh1 = "select * from idx_link where category_id = $category_id order by title";
  $hot_links_obj->resulth1 = $conn->Execute($queryh1);
  
  $hot_links_obj->template = $msg["99999"];
  
  $hot_links_obj->enable_cache = false;
  $hot_links = $hot_links_obj->Display();  

  ///hot links end **********************