PHP - Two Different Tables And Linking Fields

Im doing a search system and Im having some problems. I need to search in two tables (news and pages), I already had sucess doing my search system for just one table, but for two tables its not easy to do. I already use a select statment with two tables using UNION because I want to show number of search results, that is number of returned rows of my first sql statment. But now I need to do a select statment that allows me to acess all fields of my news table and all fields of my pages table. I need to acess in my news table this fields: id, title, content, link, date, nViews I need to acess in my pages table this fields: id, title, content, link Im trying to do this also with UNION, but in this case Im not having any row returning. Do you see what I have wrong in my code?   <?php
//first I get my $search keyword
$search = $url[1];

$pdo = connecting();
//then I want to show number of returned rows for keyword searched
$readALL = $pdo->prepare("SELECT title,content FROM news WHERE title LIKE ? OR content LIKE ?
UNION SELECT title,content FROM pages WHERE title LIKE ? OR content like ?");
$readALL->bindValue(1,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(2,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(3,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(4,"%$search%", PDO::PARAM_STR);
$readALL->execute();
//I show number of returned rows
echo '<p>Your search keyword returned <strong>'.$readALL->rowCount().'</strong> results!</p>';
//If dont return any rows I show a error message
if($readALL->rowCount() <=0){
echo 'Sorry but we didnt found any result for your keyword search.';
}
else{
//If return rows I want to show, if it is a page result I want to show title and link that I have in my page table
//if it is a news result I want to show title and link that I have in my news table and also date of news
echo '<ul class="searchlist">';
$readALL2 = $pdo->prepare("SELECT * FROM news WHERE status = ? AND title LIKE ? OR content LIKE ? LIMIT 0,4
UNION SELECT * FROM pages where title LIKE ? OR content LIKE ? LIMIT 0,4");
$readALL2->bindValue(1, '1');
$readALL2->bindValue(2, "%$search%", PDO::PARAM_STR);
$readALL2->bindValue(3, "%$search%", PDO::PARAM_STR);
$readALL2->bindValue(4, "%$search%", PDO::PARAM_STR);
$readALL2->execute();

while ($result = $readALL2->fetch(PDO::FETCH_ASSOC)){
echo '<li>';
echo '<img src="'.BASE.'/uploads/news/'.$result['thumb'].'"/>';
echo '<a href="'.BASE.'/news/'.$result['id_news'].'">'.$result['title'].'</a>';
//if it is a news result I also want to show date on my list
//echo '<span id="date">'.$result['date'].'</span>';
echo '</li>';
}
echo ' </ul>';
//but how can I do my select statement to have access to my news table fields and my page table fields??
}
?>

<?php 

$con = database_connect();
$sql = "SELECT *
FROM anime1, episode1
WHERE animeid='$animeid'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$title = $row['title'];
$ep = $row['ep'];
}


 ?>

keep giving me back error

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\wamp\www\studying\take 2\addin12.php on line 45

Hi I got three tables (employers , company ,  and  Jobs) Employer table holds info about employer. Company hold info about the company and jobs table holds info about jobs. I was just wandering what would be a good way to link these tables in the database ?  Here is the coding for each table.


Employer Table

Code: [Select]


CREATE TABLE IF NOT EXISTS `employers` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



Jobs Table

Code: [Select]

CREATE TABLE IF NOT EXISTS `Jobs` (
  `id` int(11) NOT NULL,
  `JobTitle` varchar(200) default NULL,
  `Company` varchar(200) default NULL,
  `Salary` varchar(30) default NULL,
  `Description` varchar(2000) default NULL,
  `CompanyURL` varchar(200) default NULL,
  `PhoneNumber` varchar(30) default NULL,
  `Requirements` varchar(2000) default NULL,
  `JobCategory` varchar(100) default NULL,
  `JobType` varchar(100) default NULL,
  `Apply_To` varchar(1000) NOT NULL,
  `Email` varchar(200) NOT NULL,
  `modified_at` datetime NOT NULL,
  `PostedOnDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Address` varchar(250) NOT NULL,
  `State` varchar(200) NOT NULL,
  `City` varchar(200) NOT NULL,
  `Country` varchar(100) NOT NULL,
  `Zipcode` varchar(100) NOT NULL,
  `JobID` varchar(100) NOT NULL,
  `WorkExperience` varchar(2000) NOT NULL,
  `EducationRequirement` varchar(2000) NOT NULL,
  `WebsitePostedFrom` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



Company Table

Code: [Select]


CREATE TABLE IF NOT EXISTS `Company` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `CompanyName` varchar(100) NOT NULL,
  `Address` varchar(100) NOT NULL,
  `Logo` varchar(100) NOT NULL,
  `PhoneNumber` varchar(25) NOT NULL,
  `ContactPerson` varchar(25) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

So I have 3 tables: student, course_student and course. The student table is a student's registration info and course is the different courses the student can register for. The course_student table should contain the id fields of the other 2 which I should then use to link the tables and for example display all student's registered for current courses.  Student table has an id field: sno and course table has : cid. Course_student contains both. How do I go about linking the tables so the sno id field of the student table and the cid from course updates with those in the course_table?

I have two tables.  Let's call the first one items and the second one item categories.  Now the items table would look something like this:

id(auto_increment id)
name
description
categoryid

The item categories table would look something like this:
categoryid
name
description

An entry in the items table would look something like this:
categoryid = 1,2
name = Thing
description = something
id = 1

Say I want to retrieve records that contain "1" in the categoryid column.  How would I do that?