[COLOR= #0000BB]<?php
$pageTitle[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]Uitgaansgelegenheden - Overzicht[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/include"]include[/URL] [COLOR= #DD0000]includes/header.php[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$aantalOverzichten[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]mysql[COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT
1
FROM
bedrijven"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$totaal[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]mysql[COLOR= #007700]->[/COLOR]num_rows[COLOR= #007700]([/COLOR][COLOR= #0000BB]$aantalOverzichten[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$huidige[/COLOR] [COLOR= #007700]= ([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/ctype_digit"]ctype_digit[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]]) &&[/COLOR] [COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]] >[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]] :[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$per_pagina[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]10[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$str[/COLOR] [COLOR= #007700]=[/COLOR] paging[COLOR= #007700]([/COLOR][COLOR= #DD0000]uitgaang/overzicht/[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$totaal[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$huidige[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$uitgaanQuery[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]mysql[COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT
id,
naam,
type,
beschrijving,
foto,
website
FROM
bedrijven
WHERE
activatie = 1
ORDER BY
naam
DESC LIMIT
"[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$huidige[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]) -[/COLOR] [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]mysql[COLOR= #007700]->[/COLOR]num_rows[COLOR= #007700]([/COLOR][COLOR= #0000BB]$uitgaanQuery[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$per[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div style="text-align: center; padding-top: 5px; padding-bottom: 5px;">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$str[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</div>[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uitgaanFetch[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]mysql[COLOR= #007700]->[/COLOR]fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$uitgaanQuery[/COLOR][COLOR= #007700]))
{[/COLOR]
[COLOR= #0000BB]$percentageQuery[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]mysql[COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT
*
FROM
bedrijf_recensie
WHERE
bedrijf_id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$uitgaanFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$percentageFetch[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]mysql[COLOR= #007700]->[/COLOR]fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$percentageQuery[/COLOR][COLOR= #007700]))
{[/COLOR]
[COLOR= #0000BB]$percentage[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$percentageFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]service[/COLOR][COLOR= #007700]] +[/COLOR] [COLOR= #0000BB]$percentageFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]prijs[/COLOR][COLOR= #007700]] +[/COLOR] [COLOR= #0000BB]$percentageFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]sfeer[/COLOR][COLOR= #007700]][/COLOR] / [COLOR= #0000BB]3[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$per[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/number_format"]number_format[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$percentage[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000],[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000] [/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bg[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++ %[/COLOR] [COLOR= #0000BB]2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]ccc[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]AAA[/COLOR][COLOR= #007700]);[/COLOR]
?>
<div style="width: 900px; background: #[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$bg[/COLOR][COLOR= #007700];[/COLOR] ?>; padding: 5px;">
<img src="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700];[/COLOR] ?>img/fotos/[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$uitgaanFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]foto[/COLOR][COLOR= #007700]]);[/COLOR] ?>" alt="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$uitgaanFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]]);[/COLOR] ?>" style="float: left; border: 1px dashed #fff; width: 150px; heigth: 150px;" />
<div style="float: left; margin-left: 10px; width: 700px;">
<h2>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$uitgaanFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]]);[/COLOR] ?></h2>
[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][URL="http://www.php.net/stripslashes"]stripslashes[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uitgaanFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]beschrijving[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]300[/COLOR][COLOR= #007700]))).[/COLOR][COLOR= #DD0000]...[/COLOR][COLOR= #007700];[/COLOR] ?>
<div style="clear: both;"></div>
<div class="cijfer">
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$per[/COLOR][COLOR= #007700];[/COLOR]
?></div>
<div class="button">
<a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700];[/COLOR] ?>bedrijf/[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$uitgaanFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR] ?>/[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]link_replace[COLOR= #007700]([/COLOR][COLOR= #0000BB]$uitgaanFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR] ?>">Informatie</a>
</div>
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uitgaanFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]website[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700])
{[/COLOR]
?>
<div class="button">
<a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$uitgaanFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]website[/COLOR][COLOR= #007700]]);[/COLOR] ?>" target="_blank">Website</a>
</div>
[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]}[/COLOR]
?>
</div>
<div style="clear: both;"></div>
</div>
[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]}
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div style="text-align: center; padding-top: 5px;">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$str[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</div>[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL]
[COLOR= #007700]{[/COLOR]
?>
<div style="text-align: center; padding-top: 10px;">
<h2>Foutmelding</h2>
<div class="error" style="margin: 0 auto; width: 400px;">Er zijn geen uitgaansgelegenheden op dit moment.</div>
</div>
[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]}[/COLOR]
?>
<div style="text-align: center;">
<script type="text/javascript">
<!--
google_ad_client = "ca-pub-0535299266123300";
/* */
google_ad_slot = "3422471233";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
</div>
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL] [COLOR= #DD0000]includes/footer.php[/COLOR][COLOR= #007700];[/COLOR]
?>
Niet getest, moet je zelf ff kijken

Lennard bedoelde dat je de vakken met de teksten + de echo $per; in de while van de precentage zet, ipv in de while van de uitgaan query... tenminste dat denk ik..