Having problems displaying column view

mabans

I read various tutorials on how to do this and I tried my best to make this work correctly but no chance what so ever. Any input would be great. Thanks in advance.

The link is here:

http://69.13.156.225/test/includes/main_stage_items/results/thumbs.php?show_cat=1

<?PHP
//The Required Files to access the data base
require("../../../includes/configs/config.cfg");
require("../../../includes/configs/select_db.cfg");
//The Required Files to access the data base
$columns = 2;
$show=$_GET['show_cat'];
$query = "SELECT * FROM poster WHERE category='$show' ORDER BY code LIMIT 0,30";
$result = mysql_query($query) or die ("Could not do, what you ask of me, sorry man. Check your Code!");
$num_rows = mysql_num_rows($result);
echo "<TABLE BORDER=\"0\">\n";
for($i = 0; $i < $num_rows; $i++) { 
$row = mysql_fetch_array($result); // Line 13 //
if($i % $columns == 0) {
echo "<TR>\n";
}
echo "<TD>"
.$row['code']
."</TD>\n";
if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_rows) {
echo "</TR>\n";
}
}
echo "</TABLE>\n";
?>

jasonmills58

it might be a problem with your SQL statement, which doesn't manifest until you actually ask it to do something on line 13.

I would change it to this:

$query = "SELECT * FROM poster WHERE category=".$show." ORDER BY code LIMIT 0,30";

hope it helps.

On a purely cosmetic level, you may want to ident nested code. It can make it easier to tell what is dependent on what:

for($i = 0; $i < $num_rows; $i++) {  

    $row = mysql_fetch_array($result); // Line 13 // 
    if($i % $columns == 0) { 
        echo "<TR>\n"; 
    } 
    echo "<TD>" 
    .$row['code'] 
    ."</TD>\n"; 
    if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_rows) { 
        echo "</TR>\n"; 
    } 
} 
echo "</TABLE>\n";

cheers,
Jason

mabans

Same result.

jasonmills58

Are you sure your required files are working? have you tried just outputting some basic database stuff?

Usually, if you work backwards (or upwards) from the error message, you can find whats wrong.

13 looks fine to me, but if the SQL statement isn't working, then $num_rows isn't being populated.

So if a basic query works, I'm not sure what to tell you. I'm sorry, I'm still kind of new myself...

mabans

Everything is fine, there was just some weird hidden character inserted in the script. I deleted them and it worked fine. BBEdit is pure goodness.