Fejl i min tagwall
Jeg har et problem, jeg har lavet en tagwall til min PHPclanwebsite, men den kommer med en fejl der hedder:Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/web/web4647/includes/sql_layer.php on line 36
Når jeg trykker ind på min tagwall, hele højre side forsvinder!
Håber der er en der kan hjælpe mig
Info:
http://www.weirdweapon.com/?mid=115
sql_layer.php:
<?php
$toplist = mysql_query("select date, subject from {$GLOBALS['prefix']}_articles order by date DESC LIMIT 0,6");
function sql_logout($id="")
{
global $dbtype;
if ($dbtype=="MySQL") {
$dbi=@mysql_close($id);
return $dbi;
}
}
function sql_query($query, $id="")
{
global $dbtype;
if ($dbtype=="MySQL") {
$res=@mysql_query($query);
return $res;
}
}
function sql_num_rows($res="")
{
global $dbtype;
if ($dbtype=="MySQL") {
$rows=mysql_num_rows($res);
return $rows;
}
}
function sql_fetch_row($res, $nr="")
{
global $dbtype;
if ($dbtype=="MySQL") {
$row = mysql_fetch_row($res);
return $row;
}
}
function sql_fetch_array($res, $nr="")
{
global $dbtype;
if ($dbtype=="MySQL") {
$row = array();
$row = mysql_fetch_array($res);
return $row;
}
}
function sql_fetch_object($res, $nr="")
{
global $dbtype;
if ($dbtype=="MySQL") {
$row = mysql_fetch_object($res);
if($row) return $row;
else return false;
}
}
function sql_free_result($res) {
global $dbtype;
if ($dbtype=="MySQL") {
$row = mysql_free_result($res);
return $row;
}
}
function translate($phrase) {
return $phrase;
}
?>
Tagwall.php:
<?php
include("config.php");
?>
<script language="JavaScript">
function openWindow(URL,name,features) {
window.open(URL,name,features);
}
</script>
<head>
<link rel="stylesheet" href="../tagwall/css.css" type="text/css"/>
<script type="text/javascript" src="../tagwall/js.js"></script>
</head>
<p align="center">
<br>
<?php
$visfra = $_GET['visfra'];
if (!$_GET['visfra']) {
$visfra = 0;
}
$query = mysql_query ("SELECT * FROM tagwall ORDER BY id DESC limit $visfra, $prside");
while ($row = mysql_fetch_array($query)) {
echo "<table class='tblmain'>";
echo "<tr><td class='cellmain'><span class='rightspan'>$row[dato]</span><span class='leftspan'>";
echo "<b>$row[navn]</b> ";
if ($row['mail']) {
echo "- <a href='mailto: $row[mail]'>@</a> ";
}
if ($row['site']) {
echo "- <a href='$row[site]' target='_blank'>$row[site]</a>";
}
if (isset($_SESSION['aid'])) {
echo "<a href='$_SERVER[PHP_SELF]?slet=$row[id]'>Slet</a>";
}
echo "</span></td></tr>";
echo "<tr><td class='cellmsg'>".nl2br(stripslashes($row['besked']))."</td></tr>";
echo "</table><br>";
}
echo "";
$antal = mysql_num_rows(mysql_query("SELECT id FROM tagwall"));
limit($visfra,$antal,$prside);
mysql_close();
if ($error == 1) {
echo $errormsgone;
}
if ($error == 2) {
echo $errormsgtwo;
}
?>
<div align="center">
<b>
<form method="post" action="<?php echo $_SERVER[PHP_SELF]; ?>" onsubmit="return check();">
<input type="text" name="navn" value="Navn" onFocus="if(this.value=='Navn'){this.value=''};" onBlur="if(this.value==''){this.value='Navn'};" value="<?php echo $_POST['navn']; ?>" size="20">
<input type="text" name="mail" value="Mail" onFocus="if(this.value=='Mail'){this.value=''};" onBlur="if(this.value==''){this.value='Mail'};" value="<?php echo $_POST['mail']; ?>" size="20"><br>
<a href http://www.weirdweapon.com/news/smilies.htm onClick="openWindow('http://www.weirdweapon.com/news/smilies.htm','vindueNavn','toolbar=no, location=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=yes, width=250, height=350')" border="0" style="cursor:pointer; cursor:hand; text-decoration: none">Smilies</a><br>
<textarea rows="6" cols="47" name="besked" input type="text" name="besked" onFocus="if(this.value=='Besked'){this.value=''};" onBlur="if(this.value==''){this.value='Besked'};">Besked</textarea><br>
<br>
<input type="submit" name="skriv" value="Shout!" style="width: 60px;">
</form>
</b>
</div>
</body>
</html>
<?php
mysql_close($con);
?>
