De PHPhulp kroeg
foutmelding hulp:Warning: mysql_query() expects parameter 1 to be string, resource given
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>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?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;
}
}
?>
$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
Code (php)
1
<?=$primaire_kleur;?>
<tr>
<td bgcolor="">
<br>
<center><b></b></center>
<br>
<table cellspacing="1" cellpadding="2" width="100%" border="0">
</tr>
</table>
</td></tr>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
<?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>";
?>
$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 />
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<?
$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>";
?>
$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--------------
Nu wordt het gokken naar de fout.
$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;\">";
Code (php)
1
2
3
4
5
6
2
3
4
5
6
<?php
$sql = mysql_query("SELECT * FROM link");
while($result = mysql_fetch_assoc($sql)) {
print_r($result);
}
?>
$sql = mysql_query("SELECT * FROM link");
while($result = mysql_fetch_assoc($sql)) {
print_r($result);
}
?>
Als je de code hierboven kopieerd zou je de data die je uit de database probeert te halen in een array moeten zetten.
gr Jan
Toevoeging op 24/10/2012 15:20:04:
Nog even een vraagje Rick... zoals ik schreef had ik die foutmelding vroeger niet... zou dit zijn ontstaan omdat mijn hosting bedrijf onlangs zijn PHP versie op de server heeft geupdated?
Jan de vries op 24/10/2012 15:09:13:
zoals ik schreef had ik die foutmelding vroeger niet... zou dit zijn ontstaan omdat mijn hosting bedrijf onlangs zijn PHP versie op de server heeft geupdated?
Misschien zag je niks op het scherm aan foutmelding.
Maar dit:
$sql = mysql_query("SELECT * FROM link ");
$result = mysql_query($sql);
Gaat in elke versie fout en heeft niets met een update te maken.