Codice PHP:
<div align="center">
<?
include 'cfg.php';
mysql_connect($dbaddress,$username,$password);
@mysql_select_db($database) or die( "Errore con la connessione al DataBase");
$query="SELECT * FROM f_posts WHERE title='".$_GET['post']."' ORDER BY id DESC";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();
$i=0;
while ($i < $num) {
$po_title=mysql_result($result,$i,"title");
$po_from=mysql_result($result,$i,"from");
$po_mess=mysql_result($result,$i,"txt");
//prende l'avatar e i posts totali
$db = mysql_connect($dbaddress, $username, $password);
@mysql_select_db($database, $db) or die( "Errore con la selezione del DataBase");
$query="SELECT posts,avatar FROM f_users WHERE username='".$po_from."'";
$result=mysql_query($query, $db);
$row=mysql_fetch_array($result);
$us_posts=$row['posts'];
$us_avatar=$row['avatar'];
?>
<table width="400" border="0" cellpadding="0" cellspacing="0">
<tr bgcolor="#0066FF">
<td colspan="2" scope="row"><font face="verdana" size="1"><? print $po_title ?></td>
</tr>
<tr>
<td width="100" scope="row" bgcolor = #00CCFF><font face="verdana" size="1">
<div align="center"><? print $po_from ?></div>
[img]avatars/<? print $us_avatar?>[/img]
Messaggi: <? print $us_tmess ?></font></td>
<td bgcolor = #0099FF><font face="verdana" size="1"><? print $po_mess ?></td>
</tr>
<tr bgcolor="#0066FF">
<td colspan="2" scope="row"><div align="right">[url="index.php?ind=add&title=<? print $po_title ?>"]Rispondi[/url]</div></td>
</tr>
</table>
<?
$i++;
}
?>
</div>
Warning: mysql_result(): Unable to jump to row 1 on MySQL result index 22 in /web/htdocs/www.fodlers.org/home/pub/post.php on line 19
Warning: mysql_result(): Unable to jump to row 1 on MySQL result index 22 in /web/htdocs/www.fodlers.org/home/pub/post.php on line 20
Warning: mysql_result(): Unable to jump to row 1 on MySQL result index 22 in /web/htdocs/www.fodlers.org/home/pub/post.php on line 21
per informazioni http://www.fodlers.org/pub/index.php...t&post=lollete lol