How to display messages from mysql database in rows?

[ashfaqbinnazar]

Dear friends,
How can i display messages from mysql database in each rows with delete and reply button.
Thanks in advance.
Here is my code.
i have created a page like scrapbook.
and splitted the scrapbook into two,ie my scrapbook and my friends scrapbook.
$toid is active only when i visit others profile.
if $toid is blank then display my scrqapbook otherwise my friend scrapbook.

<td><table width="100%" height="99" border="1">
             <?php 
                if($toid=="" or $toid==$id)
                {
                $rst = mysql_query("SELECT * FROM messages where toid='$id' ORDER BY id DESC")
                or die(mysql_error());  
                  $count=mysql_num_rows($rst);
                while($count>0)
                {
                $count--;
                $row = mysql_fetch_array($rst);
                 $delid=$row['id'];
                 $x=$row['msg'];
                  $from=$row['fromid'];
                  $row7=fromname($from);
                 $fromname=$row7['username'];
                 $row4=userdata($id);
                 ?>
                <?php 
                  echo "<table width='100%' border='1'>
                  <tr>
                  <td width='10%'><a href='scrapbook.php?toid=$from'>$fromname</a></td> 
                  <td width='75%'>$x<br>
                  <input name='delete' type='submit' id='delete' value='Delete'>
                 <input name='reply' type='submit' id='reply' value='Reply'>
                  </td>
                  </tr>
                  </table>";
                  $delid=$row['id'];
                   $delete_query = "DELETE FROM messages WHERE id = '$delid'";
                    if($delete){
                    mysql_query($delete_query) or die(mysql_error());
                    }
                  $msg="Done";}} 
                else
                {
                $id=$toid;
                {
                $rst3 = mysql_query("SELECT * FROM messages where toid='$id' ORDER BY id DESC")
                or die(mysql_error());  
                  $count2=mysql_num_rows($rst3);
                while($count2>0)
                {
                $count2--;
                $row3 = mysql_fetch_array($rst3);
                 $delid2=$row['id'];
                 $y=$row3['msg']; 
                 $from=$row3['fromid'];
                 $row6=fromname($from);
                 $fromname=$row6['username'];
                 echo "<table width='100%' height='109' border='1'>
                  <tr valign='bottom'><td width='14%' height='103'>$fromname</td> 
                  <td valign='top' width='86%'>$y</td>
                  </tr></table>";
                  }}}?></table>
      *</td>
 

[dlite922]

Where are you stuck?
Which line of the code isn't working?

I can't write the entire code for you. I can help yo answer /specific/ questions.

Let us know,





Dan