Help with an error in my CMS

[FirefighterKyle]

Okay I am trying to add recent activity thing to my job info but it gives me this error

You must be registered for see links

can someone tell me what I have to do to fix it? here is the array on page 135

You must be registered for see links

if you can tell me how to fix this error it would help me out a lot

 

[Ecko]

You are not doing any error checking. The query is not returning any results. What is the value of $getCorpID ?

Try running the query by itself to see what results it gives.

 

[FirefighterKyle]

So you want me to get rid of the while($corpLog = mysql_fetch_array($getCorp1) part?

 

[Ecko]

So you want me to get rid of the while($corpLog = mysql_fetch_array($getCorp1) part?

No..

 

[FirefighterKyle]

Then what do you mean by


"The query is not returning any results. What is the value of $getCorpID ?

Try running the query by itself to see what results it gives."


Okay I fixed the error but it doesn't show the cop log tho I mean I have it all right here

You must be registered for see links

but it doesn't show on here

You must be registered for see links

I will up load the code so you can see or anyone can see what they can do to fix it for me

Spoiler

<h2 class="title">Recent Activity
</h2>

<div id="credits-safety" class="box-content credits-info">

<div class="credit-info-text clearfix">

<table width="100%">

<tr style="font-weight:bold">

<td>Target</td>

<td>Master</td>

<td>Action</td>

<td></td>

</tr>

<?php
$getCorp1 = mysql_query("SELECT * FROM jobs_corps WHERE id = '".$getCorpID."' ORDER BY id DESC LIMIT 25");
while ($corpLog = mysql_fetch_array($getCorp1)) {
?>

<tr>

<td><?php echo $corpLog['target']; ?></td>

<td><?php echo $corpLog['master']; ?></td>

<td><?php echo $corpLog['action']; ?></td>

<td><img src="./info.png" onMouseover="ddrivetip('ID: <?php echo $corpLog['id']; ?>')";
onMouseout="hideddrivetip()" /></td>

</tr>

<?php
}
?>

 

[Ecko]

What happens if you change the query to this:

$getCorp1 = mysql_query("SELECT * FROM jobs_corps ORDER BY id DESC LIMIT 25");

 

[FirefighterKyle]

That did this

You must be registered for see links

I mean it made more rows of it but still not showing who was hired etc I will copy more of the code if you want me to

$getCorpID = $input->FilterText($_GET['id']);
?>
 
<div id="container">
<div id="content" style="position: relative" class="clearfix">
    <div id="column1" class="column">
 
    <div class="habblet-container ">
 
<div id="column1" class="column" style="width:540px">
 
<div class="habblet-container ">
<div class="cbb clearfix white ">
 
<h2 class="title">Recent Activity
</h2>
 
<div id="credits-safety" class="box-content credits-info">
 
<div class="credit-info-text clearfix">
 
<table width="100%">
 
<tr style="font-weight:bold">
 
<td>Target</td>
 
<td>Master</td>
 
<td>Action</td>
 
<td></td>
 
</tr>
 
                                       <?php
$getCorp1 = mysql_query("SELECT * FROM jobs_corps ORDER BY id DESC LIMIT 25");
while ($corpLog = mysql_fetch_array($getCorp1)) {
?>
 
<tr>
 
<td><?php echo $corpLog['target']; ?></td>
 
<td><?php echo $corpLog['master']; ?></td>
 
<td><?php echo $corpLog['action']; ?></td>
 
<td><img src="./info.png" onMouseover="ddrivetip('ID: <?php echo $corpLog['id']; ?>')";
onMouseout="hideddrivetip()" /></td>
 
</tr>
                            
                            <?php
}
?>
 
 
 
</table>
 
</div>
 
</div>
 
</div>
 
</div>
 
 
<?php
$getRank = mysql_query("SELECT * FROM jobs_ranks WHERE corp_id = '".$getCorpID."';");
$count = mysql_num_rows($getRank);
for ($i=1; $i<=$count; $i++)
{
  $getRankInfo = mysql_query("SELECT * FROM jobs_ranks WHERE corp_id = '".$getCorpID."' && job_rank = '".$i."'");
  $rankInfo = mysql_fetch_array($getRankInfo);
  $getUserInfo = mysql_query("SELECT * FROM users WHERE secure_id = '".$rankInfo['id']."'");
?>
 
 <div class="cbb clearfix white ">
 
<h2 class="title"><b>Rank:</b> <?php echo $rankInfo['motto'].''; ?>
</h2>
<p class="credits-countries-select">
<?php
while($UserInfo = mysql_fetch_array($getUserInfo)){
  echo '<img src="http://www.habbo.nl/habbo-imaging/avatarimage?figure='.$UserInfo['figure'].'&size=s&direction=2&head_direction=3&gesture=sml&size=m" align="left"><strong><a href="#">'.$UserInfo['name'].'</a></strong><br />'.$UserInfo['mission'].'<br />Rank: '.$UserInfo['staffrank'].'<br />Last visit: '.$UserInfo['lastvisit'].'<br /><br />';
}
?>
</p>
               </div>
<?php
}
?>
 
</div>
</div>
<div id="column2" class="column">
<div class="habblet-container ">
<div class="cbb clearfix blue ">
<?php
$getCorp = mysql_query("SELECT * FROM jobs_corps WHERE id = '".$getCorpID."'");
$corpInfo = mysql_fetch_array($getCorp);
$getOwner = mysql_query("SELECT * FROM users WHERE id = '".$corpInfo['owner']."'");
$owner = mysql_fetch_array($getOwner);
?>