Goedemiddag
Sinds enige tijd heb ik een foutmelding op een website (Warning: mysql_query() expects parameter 1 to be string, resource given in /home/verko/public_html/footer.php on line 146)
Ik ben geen specialist in php en weet niet wat er fout gaat. De melding staat aan de rechterkant van de pagina (bijna onderaan)op http://www.verkoop-koop.nl/ (na de taal keuze)
Hieronder de footer.php zoals nu in gebruik en waar de foutmelding weg komt.
Alvast bedankt bedankt voor reacties
-----------begin script-------
<center>
<?php
$sql = "SELECT * FROM banner WHERE positie = '0' AND ((alles = '1') or (categorie_id like '%,$categorie_id,%')) ORDER by rand() limit 1";
$sql_query = mysql_query($sql)or die(mysql_error());
$teller = 0;
while($obj = mysql_fetch_array($sql_query)) {
echo "<b>{$obj["omschrijving"]}</b><br>";
switch ($obj["type"]) {
case 'intern':
echo "<a href=\"$siteurl/adbeheer/clicks.php?banner_id={$obj["banner_id"]}\" target=_new ><img src=\"$siteurl/adbeheer/impressies.php?banner_id={$obj["banner_id"]}\" border=0></a><br>";
break;
case 'extern':
echo "<a href=\"$siteurl/adbeheer/clicks.php?banner_id={$obj["banner_id"]}\" target=_new ><img src=\"$siteurl/adbeheer/impressies.php?banner_id={$obj["banner_id"]}\" border=0></a><br>";
break;
case 'flash':
echo $obj["flash"];
break;
}
}
?>
</div>
<br /><br /><br /><br />
<table width="200" border="0" valign="top" cellpadding="0" cellspacing="0" align="right">
<td style="margin-right: 0px;">
<table cellspacing="0" cellpadding="0" width="100%" style="border: solid <?=$primaire_kleur;?> 1px;">
<tr>
<td bgcolor="<? echo $primaire_kleur ?>">
<br>
<center><b><? echo $taal[57] ?></b></center>
<br>
<table cellspacing="1" cellpadding="2" width="100%" border="0">
</tr>
</table>
</td></tr>
<?php
$omschrijving = array();
$banner_id = array();
//maurice
// $sql_query = mysql_query("SELECT * FROM banner WHERE positie = '1' AND(`categorie_id` LIKE '%$categorie_id%' OR alles = '1')")or die(mysql_error());
$sql_query = mysql_query("SELECT * FROM banner WHERE positie = '1' AND(`categorie_id` like '%, $categorie_id,%' OR alles = '1')")or die(mysql_error());
//maurice
$teller = 0;
while($obj = mysql_fetch_array($sql_query))
{
$contract = $obj["contract_id"];
$query = mysql_query("SELECT banner_id FROM clicks WHERE banner_id = '$obj[banner_id]'");
$clicks = mysql_num_rows($query);
$obj2 = mysql_fetch_array(mysql_query("SELECT maximpressies FROM contract WHERE contract_id = '$contract'"));
$max = $obj2["maximpressies"];
if($max < $clicks)
{
}
else
{
$omschrijving[$teller] = $obj["omschrijving"];
$banner_id[$teller] = $obj["banner_id"];
//maurice
$ad_type[$teller] = $obj["type"];
$flash[$teller] = $obj["flash"];
//maurice
$teller = $teller + 1;
}
}
if ($teller == 0)
{
echo "<tr bgcolor=$secundaire_kleur><td>$taal[56]<br></td></tr>";
}
else
{
$teller = 0;
$error = 0;
while($error != 1)
{
//maurice
// echo "<tr bgcolor=$secundaire_kleur><td><b><center>$omschrijving[$teller]</b><br>
// <a href=\"$siteurl/adbeheer/clicks.php?banner_id={$banner_id[$teller]}\" target=_new ><img src=\"$siteurl/adbeheer/impressies.php?banner_id={$banner_id[$teller]}\" border=0></a><br>";
echo "<tr bgcolor=$secundaire_kleur><td><b><center>$omschrijving[$teller]</b><br>";
$source_pic = $siteurl . "/adbeheer/impressies.php?banner_id=" . $banner_id[$teller];
switch ($ad_type[$teller]) {
case 'intern':
list($width, $height) = getimagesize($source_pic);
if ($width > 200)
$width_txt = "width=\"200\"";
echo "<a href=\"$siteurl/adbeheer/clicks.php?banner_id={$banner_id[$teller]}\" target=_new ><img src=\"$siteurl/adbeheer/impressies.php?banner_id={$banner_id[$teller]}\" border=0 $width_txt></a><br>";
break;
case 'extern':
list($width, $height) = getimagesize($source_pic);
if ($width > 200)
$width_txt = "width=\"200\"";
echo "<a href=\"$siteurl/adbeheer/clicks.php?banner_id={$banner_id[$teller]}\" target=_new ><img src=\"$siteurl/adbeheer/impressies.php?banner_id={$banner_id[$teller]}\" border=0 $width_txt></a><br>";
break;
case 'flash':
echo $flash[$teller];
break;
}
//maurice
$teller++;
if(isset($omschrijving[$teller]))
{
$error = 0;
}
else
{
$error = 1;
}
}
}
echo "</table>";
?>
<br /><br />
<?
$site = $siteurl;
$site = "/index.php";
$sql = mysql_query("SELECT * FROM link ");
$result = mysql_query($sql);
echo "<table cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" style=\"border: solid $primaire_kleur 1px;\">";
echo "<tr>";
echo "<td bgcolor=\"$primaire_kleur\" class=\"klein\" width=200>";
echo "<br>";
echo "<center><font color='#08000C'><b>$taal[575]</b></font></center>";
echo "<br>";
echo "<table cellspacing=\"1\" cellpadding=\"2\" width=\"100%\" border=\"0\">";
echo "</tr>";
echo "</table>";
echo "</td>";
echo "</tr>";
$sql_partner = mysql_query ("SELECT * FROM link ORDER by onder, omschrijving");
while($object2 = mysql_fetch_object($sql_partner))
{
$omschrijving_link = $object2->omschrijving;
$adres = $object2->adres;
echo "<tr bgcolor=$secundaire_kleur>
<td ><br><center><a href=$adres target=_new>$omschrijving_link</a></center></td></tr>";
}
$sql_prijs = mysql_query ("SELECT * FROM site");
while($object2 = mysql_fetch_object($sql_prijs))
{
$prijs_link = $object2->prijs_link;
$soort = $object2->soort_betalen;
}
if($prijs_link=="")
{
}
elseif($prijs_link=="0")
{
echo "<tr bgcolor=$secundaire_kleur>
<td ><br><center><a href=$siteurl/betalingen/link_plaatsen.php>$taal[58]</a></center></td></tr>";
}
else
{
if($soort=="0")
{
echo "<tr bgcolor=$secundaire_kleur>
<td ><br><center><a href=$siteurl/betalingen/link_plaatsen.php>$taal[58]</a></center></td></tr>";
}
else
{
echo "<tr bgcolor=$secundaire_kleur>
<td ><br><center><a href=$siteurl/betalingen/pay.php?advertentieid=0&actie=link>$taal[58]</a></center></td></tr>";
}
}
echo "</tr></table>";
?>
</center>
</td>
</tr>
</td>
</tr>
</table>
<br>
</table>
</center>
</td>
</tr>
</table>
</div>
</div>
</body>
</html>
--------------einde script--------------
2.718 views
