mysql_query("SELECT * FROM moppen WHERE cat = " . mysql_real_escape_string($_GET[cat]) . "") or die(mysql_error());Parse error: syntax error, unexpected T_WHILE in /home/fanhabbo/domains/thahab.nl/public_html/moppen/zoeken.php on line 15<center><head><link rel="stylesheet" type="text/css" href="style.css" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<body leftmargin="0" rightmargin="0" topmargin="0" bottommargin="0" bgcolor="FF5A00" alink="FFD800" vlink="FFD800" link="FFD800">
<a href="insturen.php"><b>MOP TOEVOEGEN</b></a><br /><br />
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]config.php[/COLOR][COLOR= #007700]);[/COLOR]
?>
[COLOR= #0000BB]<?php
$qLid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM moppen WHERE cat = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cat[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]())[/COLOR]
[URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$aLid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$qLid[/COLOR][COLOR= #007700]))
{[/COLOR]
?>
<div class="moptop">
<div class="tekst"><strong><?=$aLid[titel]?> » Ingestuurd door: <?=$aLid[naam]?> » <?=$aLid[cat]?></a> </strong>
<!-- Tekst sluit -->
</div>
<!-- Mop top sluit -->
</div>
<div class="mopmid">
<div class="moptekst"><?=$aLid[mop]?>
<!-- Tekst sluit -->
</div>
<!-- Mop mid sluit -->
</div>
<div class="moponder">
<!-- Mop onder sluit -->
</div>
[COLOR= #0000BB]<?[/COLOR]
[COLOR= #007700]}[/COLOR] [COLOR= #FF8000]//while afsluiten[/COLOR]
[URL="http://www.php.net/mysql_free_result"]mysql_free_result[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$qLid[/COLOR][COLOR= #007700]);[/COLOR]
?>
</center>Sevvlor schreef:Oja, bedankt!$qLid = mysql_query("SELECT * FROM moppen WHERE cat = " . mysql_real_escape_string($_GET[cat]) . "") or die(mysql_error()) is niet afgesloten met een ;
43:
Fanhabbo schreef:Oja, bedankt!Eerdere citaten tonen
Sevvlor schreef:$qLid = mysql_query("SELECT * FROM moppen WHERE cat = " . mysql_real_escape_string($_GET[cat]) . " AND keur = 1 ORDER BY RAND() LIMIT 20") or die(mysql_error()) is niet afgesloten met een ;
toevoeging op 19 februari 2012, 17
Nu wil ik in:
keur=1 ORDER BY RAND() LIMIT 20
in de code toevoegen hoe moet dat?