ho installato un guestbook con mysql su xyz...
però mi da errore....
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Inetpub\webs\rosannatursiit\public\guestbook\in dex.php on line 76
lo script index è il seguente
<?php
require('inc/config.php');
$result = mysql_query('SELECT `id`, `name`, `message`, `time` FROM `posts` ORDER BY id DESC');
++$queries;
function splitString($string) {
$stringArray = explode(' ', $string);
foreach ($stringArray as $word) {
$newString .= chunk_split($word, 50);
}
return $newString;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ajax PHP/MySQL Guestbook</title>
<link href="inc/style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
function toggle(str, str2) {
document.getElementById(str).style.display = 'none';
document.getElementById(str2).style.display = 'block';
}
function checkPost() {
var ajax = new XMLHttpRequest();
ajax.onreadystatechange=function() {
if (ajax.readyState==4) {
var buffer = document.getElementById('messageWrap').innerHTML;
if (ajax.responseText.search('&&error') != -1) {
document.getElementById('error').innerHTML = ajax.responseText;
} else {
document.getElementById('messageWrap').innerHTML = ajax.responseText + buffer;
document.getElementById('error').innerHTML = '';
}
}
}
ajax.open('GET', 'check.php?name=' + document.getElementById('name').value + '&message=' + document.getElementById('message').value, true);
ajax.send(null);
}
</script>
</head>
<body>
<div id="header">
Ajax PHP/MySQL Guestbook
</div>
<div id="main">
<div id="addMessage">
Add a message!</p>
</div>
<div id="inputBox">
<form action="" method="post" name="go">
<input id="name" name="name" type="text" /> <label for="name">Name</label>*</p>
<textarea id="message" name="message" type="textarea" cols="60" rows="3"></textarea> <label for="message">Message</label>*</p>
<input type="button" value="Post" onclick="javascript:checkPost()" /> * = Required <div id="notice"></div></p>
</form>
</div>
<div id="error"></div>
<div id="messageWrap">
<?php
if (mysql_num_rows($result) == 0) {
?>
<div class="messageBox" style="padding: 10px 10px;">
No messages have been posted. Why not post one!
</div>
<?php
} else {
while ($row = mysql_fetch_assoc($result)) {
?>
<div class="messageBox">
<div class="name">
Posted by <?php echo stripslashes(htmlentities($row['name'])) ?> on <?php echo date('d/m/Y', $row['time']) . ' at ' . date('H:i:s', $row['time']) . ($_SESSION['admin'] === 1 ? ' [Delete]' : '') ?>
</div>
<div class="message">
<?php echo splitString(stripslashes(htmlentities($row['message']))) ?></p>
</div>
</div>
<?php
}
}
?>
</div>
</div>
<div id="footer">
Ajax PHP/MySQL Guestbook | Log in | Execution time: <?php echo (microtime() - $start) ?> seconds. MySQL Queries: <?php echo $queries ?>
</div>
</body>
</html>
dove sto sbagliando????
chi può controllarmi lo script??? dove devo fare delle modifiche????
grazie per l'aiuto....
Rispondi quotando
:master: 
