mysql problem

• • Reply

  13 years ago

  by lolita

  walaa omar

  , Egypt

  Joined 13 years ago

  i want to match between two tables in database postjobs and user2 which models employees CVs to filter CVs and find at end qualified applicants which match with posted jobs requirements.

  so i have problem in convenient sql statments

   

  <?php
  include 'connect.php';
  $kk=$session['user'];
  //$query = "SELECT user2.cpos, postjobs.post "."FROM user2, postjobs ".
  // "WHERE postjobs.jcat = user2.jcat";
  $query = "SELECT count(user2.Id) FROM (SELECT * "FROM user2, postjobs" . "WHERE postjobs.jcat = user2.jcat");
   
  $result = mysql_query($query) or die(mysql_error());
  
  
  
  
  
  
  

  
  // Print out the contents of each row into a table
  while($row = mysql_fetch_array($result)){
   //echo $row['post']." - ". $row['cpos'];
   echo $row['count(user2.Id)'];
   echo "<br />";
  }
  ?>
  
  
  
  
  
  
  

  Report abuse