Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
ae pessoal, to com um problema aqui..
eu to precisando que os filmes fiquem em 3 colunas:
Filme1 | Filme2 | Filme3
Filme4 | Filme5 | Filme6
Filme7 | Filme8 | Filme9
etc..
só que fica com uma coluna só
Filme1
Filme2
Filme3
Filme4
etc..
meu codigo é esse aqui
<?
include ('../config.php');
$id = intval($_GET['id']);
$cat_numb = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_games WHERE catergory_id=".$id." AND published=1"),0);
if ($cat_numb > 0) {
if(!isset($_GET['page'])){
$page = 1; $page = $_GET['page'];
}
$from = (($page * $max_results) - $max_results);
if ($_GET['sortby'] == 'nameasc') {
$sort = 'name ASC';
}
else if ($_GET['sortby'] == 'namedesc') {
$sort = 'name DESC';
}
else if ($_GET['sortby'] == 'newest') {
$sort = 'id DESC';
}
else if ($_GET['sortby'] == 'oldest') {
$sort = 'id ASC';
}$sort = 'id DESC';
}
$sql = mysql_query("SELECT * FROM ava_games WHERE catergory_id='".$id."' ORDER BY $sort LIMIT $from, $max_results");
if ($seo_on == 0) {
echo '';
}$catname = mysql_query("SELECT * FROM ava_cats WHERE id=$id ORDER BY name");
while($catnamea = mysql_fetch_array($catname))
{
$abcd= $catnamea['name'];
$abcd = str_replace (" ", "-", $abcd);
echo ' <strong>Organizar por:</strong> <a href="'.$site_url.'/cat/'.$catnamea['id'].'/'.$abcd.'/newest/p1" target="pesquisa">Novos</a> | <a href="'.$site_url.'/cat/'.$catnamea['id'].'/'.$abcd.'/oldest/p1" target="pesquisa">Antigos</a> | <a href="'.$site_url.'/cat/'.$catnamea['id'].'/'.$abcd.'/nameasc/p1" target="pesquisa">A-Z</a> | <a href="'.$site_url.'/cat/'.$catnamea['id'].'/'.$abcd.'/namedesc/p1" target="pesquisa">Z-A</a><br><br>';
}
}
echo '<div id="catwrapper">'; echo '<div id="cat_game_container">';
$therow = $therow + 1;
if ($row['import'] == 1) {
$image = '<img align="absmiddle" src="'.$site_url.'/games/images/'.$row['url'].'.png" width="100" height="100" />';}
else if ($row['import'] == 3) {
$image = '<img align="top" src="'.$site_url.'/games/images/'.$row['image'].'" width="100" height="100" />';}
else {
$image = '<img align="absmiddle" src="'.$row['image'].'" width="100" height="100" />';}
if (strlen($row['name']) > 20) {
$name = substr($row['name'], 0, 20)."...";
}
else {
$name = $row['name'];
}
if (strlen($row['description']) > 55)
{
$description = substr($row['description'], 0, 55)."...";
}
else
{
$description = $row['description'];
}
if ($seo_on == 0) {
$game_url = 'cine/player.php?id='.$row['id'].'';}
else {
$abcd= $row['name'];
$abcd = str_replace (" ", "-", $abcd);
$abcd = preg_replace ( "/[\.,\";'\:]/", "", $abcd );
$game_url = 'view/'.$row['id'].'/'.$abcd.$seo_extension;
}
echo '<center><div id="game_image"><a href="'.$site_url.'/'.$game_url.'" target="parte2">'.$image.'</a></div> <div id="game_text"><a href="'.$site_url.'/'.$game_url.'" target="parte2"><strong>'.$name.'</strong></a></center>';
include ('category_game_ratings.php');
if(isset($_COOKIE["ava_username"]))
{
$sqlaa = mysql_query("SELECT * FROM ava_users WHERE id=".$userid."");
$rowaa = mysql_fetch_array($sqlaa);
if ($rowaa['admin'] == 1)
{
echo ' <strong>Admin: </strong><a href='.$site_url.'/admin/?action=edit_game&id='.$row['id'].'>Edit game</a>';
}
}
echo '</div><br style="clear: both"/>';
echo '</div>';
if ($therow == 2) {
echo '<br style="clear: both"/></div><div id="homewrapper">';
$therow = 0;
}
}
echo '<br style="clear: both"/></div>';
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_games WHERE catergory_id='".$id."' AND published=1"),0);
$total_pages = ceil($total_results / $max_results);
$sq2 = mysql_query("SELECT * FROM ava_cats WHERE id=".$id."");
while($row2 = mysql_fetch_array($sq2)) {
$abcd2= $row2['name'];
$abcd2 = str_replace (" ", "-", $abcd2); }
if ($_GET['sortby']) {
if ($seo_on == 1) {
$url = ''.$site_url.'/cat/'.$_GET['id'].'/'.$abcd2.'/'.$_GET['sortby'].'/p';
}
else {
$url = ''.$_SERVER['PHP_SELF'].'?task=category&sortby='.$_GET['sortby'].'&id='.$_GET['id'].'&page=';
}
}
else {
if ($seo_on == 1) {
$url = ''.$site_url.'/cat/'.$_GET['id'].'/'.$abcd2.'/p';
}
else {
$url = ''.$_SERVER['PHP_SELF'].'?task=category&id='.$_GET['id'].'&page=';
}
}
if($page > 1){
$prev = ($page - 1);
if ($seo_on == 0) {echo "<a href=\"".$_SERVER['PHP_SELF']."?task=category&page=$prev&id=".$_GET['id']."\"><<".PREVIOUS."</a> ";}
else {echo '<a href="'.$url.''.$prev.$seo_extension.'"><<'.PREVIOUS.'</a> ';}
}
for($i = 1; $i <= $total_pages; $i++){
if(($page) == $i){
echo "<b><a href=#>$i</a></b> ";
} else {
echo '<a href="'.$url.$i.$seo_extension.'">'.$i.'</a> ';
}
}
if($page < $total_pages){
$next = ($page + 1);
if ($seo_on == 0) {
echo "<a href=\"".$_SERVER['PHP_SELF']."?task=category&page=$next&id=".$_GET['id']."\">".NEXT.">></a>";}
else {echo '<a href="'.$url.$next.$seo_extension.'">'.NEXT.'>></a> ';}}
}
else {
echo '<br>Essa categoria nao possui filmes!';
}
?>Carregando comentários...