Code: Select all
<?
include('http://eric.madashatters.com/header.inc');
?>
<?php
// Connecting, selecting database
mysql_connect('localhost', '*******', '**********')
or die('Could not connect: ' . mysql_error());
mysql_select_db('madashat_mail') or die('Could not select database');
echo "<BR>";
$result = mysql_query("select * from pm where user = ".$_GET['user']);
echo "<table>
<tr style='border: dotted 1px'>
<td>New</td>
<td>Subject</td>
<td>Sender</td>
<td>Date</td>
<td>Delete</td>";
$subject = mysql_result($result,0,"subject");
$new = mysql_result($result,0,"new");
$message = mysql_result($result,0,"message");
$date = mysql_result($result,0,"date");
$sender = mysql_result($result,0,"sender");
$id = mysql_result($result,0,"id");
echo "<tr style='border: dotted 1px'>";
echo "<td><div class='white'>$new</td>";
echo "<td><div class='white'>$subject</td>";
echo "<td><div class='white'>$sender</td>";
echo "<td><div class='white'>$date</td>";
echo "<td></td>";
echo "</tr>";
?>
</table>
<?
include('http://eric.madashatters.com/footer.inc');
?>oh and if anybody knows how i can make the massages with the code below repeat so it shows them all that would be great (is it something to do with $i ??)
Code: Select all
$subject = mysql_result($result,0,"subject");
$new = mysql_result($result,0,"new");
$message = mysql_result($result,0,"message");
$date = mysql_result($result,0,"date");
$sender = mysql_result($result,0,"sender");
$id = mysql_result($result,0,"id");
echo "<tr style='border: dotted 1px'>";
echo "<td><div class='white'>$new</td>";
echo "<td><div class='white'>$subject</td>";
echo "<td><div class='white'>$sender</td>";
echo "<td><div class='white'>$date</td>";
echo "<td></td>";
echo "</tr>";eric