mysql problem

mysql , php Egypt
  • 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


    include 'connect.php';
    //$query = "SELECT user2.cpos, "."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 />";

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The most exciting phrase to hear in science, the one that heralds new discoveries, is not 'Eureka!' but 'That's funny...'” - Isaac Asimov