BetterPHP

Hi, I'm creating this job site. I have created some dummy user profiles and I want these profiles to only show jobs posted by that company for example.

A company called Janko logs into this website. They are then ask to create a job.
So they create a job called "Marketing Intern". All of their jobs can be found at http://pleekant.com/Janko

However, the method I am currently using to fetch the jobs from the database is fetching all of the jobs, including jobs from other companies. For example, at http://pleekant.com/Janko, there are jobs from other companies on that page and vice versa.

I want to make it so, only jobs posted by Janko are found at http://pleekant.com/Janko and not every single job in the jobs table.

This is the current code I am using to return jobs

    <?
                                            
    $q = mysql_query("SELECT `users`.`user_id`, `users`.`company_name`, `jobs`.`user_id`,
    `jobs`.`job_title`, `jobs`.`job_id`
    FROM `users` INNER JOIN `jobs` ON `users`.`user_id` = `jobs`.`user_id`
    WHERE `jobs`.`user_id` = `users`.`user_id`
    ORDER BY `jobs`.`user_id` DESC LIMIT 20");
    $jobs = array();
    while($r = mysql_fetch_assoc($q)){
        $jobs[] = array(
        'user_id' => $r['user_id'],
        'company_name' => $r['company_name'],
        'job_title' => $r['job_title'],
        'job_id' => $r['job_id']
    );
        
    }
    foreach($jobs as $j) {
    $job_title = $j['job_title'];
    $company_name = $j['company_name'];
    $job_id = $j['job_id'];
    ?>
                                <li class="one-third video">
                                <div class="portfolio-item-holder">
                                
                                </div>
    <h4><a href="<?php echo $company_name?>.php?job_id=<?php echo $job_id ?>"><?php echo $job_title?></a></h4>
                                
                                </li>
    <?php
    }
    ?>

Thu Jul 19, 2012 12:39 pm
Hi, I'm creating this job site. I have created some dummy user profiles and I want these profiles to only show jobs posted by that company for example.

A company called Janko logs into this website. They are then ask to create a job.
So they create a job called "Marketing Intern". All of their jobs can be found at http://pleekant.com/Janko

However, the method I am currently using to fetch the jobs from the database is fetching all of the jobs, including jobs from other companies. For example, at http://pleekant.com/Janko, there are jobs from other companies on that page and vice versa.

I want to make it so, only jobs posted by Janko are found at http://pleekant.com/Janko and not every single job in the jobs table.

This is the current code I am using to return jobs

textpop-up

   <?
                                            
    $q = mysql_query("SELECT `users`.`user_id`, `users`.`company_name`, `jobs`.`user_id`,
    `jobs`.`job_title`, `jobs`.`job_id`
    FROM `users` INNER JOIN `jobs` ON `users`.`user_id` = `jobs`.`user_id`
    WHERE `jobs`.`user_id` = `users`.`user_id`
    ORDER BY `jobs`.`user_id` DESC LIMIT 20");
    $jobs = array();
    while($r = mysql_fetch_assoc($q)){
        $jobs[] = array(
        'user_id' => $r['user_id'],
        'company_name' => $r['company_name'],
        'job_title' => $r['job_title'],
        'job_id' => $r['job_id']
    );
        
    }
    foreach($jobs as $j) {
    $job_title = $j['job_title'];
    $company_name = $j['company_name'];
    $job_id = $j['job_id'];
    ?>
                                <li class="one-third video">
                                <div class="portfolio-item-holder">
                                
                                </div>
    <h4><a href="<?php echo $company_name?>.php?job_id=<?php echo $job_id ?>"><?php echo $job_title?></a></h4>
                                
                                </li>
    <?php
    }
    ?>

I need some kind of statement that only shows jobs that match the company's id, in the jobs table.
P.s the user_id is the company id

SOLVED