php/mysql dentro a php/mysql...

[thelittle]

<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

[piero.mac]

quando si chiude si chiude.... (mysql_close() )

vengono tutti buttati in strada....

[thelittle]

...$db = mysql_connect($dbaddress, $username, $password); ma poi lo riapro ^^

[piero.mac]

Originariamente inviato da thelittle
...$db = mysql_connect($dbaddress, $username, $password); ma poi lo riapro ^^

si. ma perdi il result-set della prima query. Chiudendo la connessione viene anche cancellato il resource id#

A meno che tu non stia usando la versione di mysql rilasciata a Lourdes...