rp_jobs id not working (help please)

Ben144

Member
Jan 31, 2017
76
5
Hey,

I am creating a custom CMS and i have stubbled onto a problem after changing the query (Shown in the code below). The query was needed to work the rest of the code, but when the user clicks on the "View" button then the user always gets directed to corporation with the id 1.

Code:
<div class="content">

        <div class="container">
            
    <div class="corporation-index-grid">
                <?php
                $badgepath = "{url}/fluxweb/corps/";
                
                
                $q = mysql_query("SELECT * FROM rp_jobs AS rp LEFT JOIN users AS u ON rp.owner_id = u.id WHERE rp.type = 'Skilled' and rp.hidden = 0");
                    while($row = mysql_fetch_assoc($q))
                {
            
                echo "<div class='corp'>
                <div class='content-box'>
                    <div class='title'>" . $row['name'] . " <span class='title-small float-right'><small>20 employees</small></span></div>
                    <div class='box-content d-flex justify-content-center align-items-center p-0'>
                        <div class='' style='margin-left: -15px;'>
                            <div class='manager-wrapper'>
                                <img src='https://www.habbo.nl/habbo-imaging/avatarimage?figure=".$row['look']."&amp;direction=2&amp;gesture=sml&amp;size=l'>
                            </div>
                        </div>
                        <div class='mr-auto'>Managed by <strong>" . $row['username'] . "</strong></div>
                        <div class='pr-3'>
                            <img class='corporation-badge' src='" . $badgepath . $row['badge'] . ".gif'>
                        </div>
                        <div class='pr-3 d-flex'>
                            <div class='mr-1'><a class='button blue pr-1' href='" . JobsView() . $row['id'] . "'>View <i class='far fa-arrow-alt-circle-right'></i></a></div>
                            <div class='ml-1'> <a class='button discord' href=''><i class='fab fa-discord'></i></a></div>
                        </div>
                    </div>
                </div>
            </div>
        ";
        }
        ?>

Any help appreciated and thanks in advance.
Post automatically merged:

Hey,

I am creating a custom CMS and i have stubbled onto a problem after changing the query (Shown in the code below). The query was needed to work the rest of the code, but when the user clicks on the "View" button then the user always gets directed to corporation with the id 1.

Code:
<div class="content">

        <div class="container">
           
    <div class="corporation-index-grid">
                <?php
                $badgepath = "{url}/fluxweb/corps/";
               
               
                $q = mysql_query("SELECT * FROM rp_jobs AS rp LEFT JOIN users AS u ON rp.owner_id = u.id WHERE rp.type = 'Skilled' and rp.hidden = 0");
                    while($row = mysql_fetch_assoc($q))
                {
           
                echo "<div class='corp'>
                <div class='content-box'>
                    <div class='title'>" . $row['name'] . " <span class='title-small float-right'><small>20 employees</small></span></div>
                    <div class='box-content d-flex justify-content-center align-items-center p-0'>
                        <div class='' style='margin-left: -15px;'>
                            <div class='manager-wrapper'>
                                <img src='https://www.habbo.nl/habbo-imaging/avatarimage?figure=".$row['look']."&amp;direction=2&amp;gesture=sml&amp;size=l'>
                            </div>
                        </div>
                        <div class='mr-auto'>Managed by <strong>" . $row['username'] . "</strong></div>
                        <div class='pr-3'>
                            <img class='corporation-badge' src='" . $badgepath . $row['badge'] . ".gif'>
                        </div>
                        <div class='pr-3 d-flex'>
                            <div class='mr-1'><a class='button blue pr-1' href='" . JobsView() . $row['id'] . "'>View <i class='far fa-arrow-alt-circle-right'></i></a></div>
                            <div class='ml-1'> <a class='button discord' href=''><i class='fab fa-discord'></i></a></div>
                        </div>
                    </div>
                </div>
            </div>
        ";
        }
        ?>

Any help appreciated and thanks in advance.
Bump I still need help with this
 
Last edited:

Users who are viewing this thread

Top