4 Replies Latest reply on Apr 30, 2008 3:11 AM by (Oriyomi_Shokunbi)

    two recordset to display information on same page

      Hi,
      I am designing a webpage that calls from a specific entered value and at the same time should have a news headline calling from the same dbase on the same page.
      On creating the record set I got the message

      Warning: Supplied resource is not a valid MySQL-Link resource in c:\apache\htdocs\nusokoto\egovt.php on line 38

      Warning: Supplied resource is not a valid MySQL-Link resource in c:\apache\htdocs\nusokoto\egovt.php on line 40

      The line 38 and 40 is indicated below.
      I will like you to please help me with this.
      More so using ADDT can I create a master to detail page?
      Thanks
      Yomi

      }

      mysql_select_db($database_sokoto, $sokoto);
      $query_sokoto = "SELECT * FROM onsite WHERE id = 7";
      $sokoto = mysql_query($query_sokoto, $sokoto) or die(mysql_error());
      $row_sokoto = mysql_fetch_assoc($sokoto);
      $totalRows_sokoto = mysql_num_rows($sokoto);

      (38) mysql_select_db($database_sokoto, $sokoto);
      $query_news = "SELECT * FROM news WHERE topic = topic";
      (40) $news = mysql_query($query_news, $sokoto) or die(mysql_error());
      $row_news = mysql_fetch_assoc($news);
      $totalRows_news = mysql_num_rows($news);
      ?>