Can some 1 tell me what I am doing wrong? as this dont seem to be working way its ment to.

in one of my other projects simular version worked, although can not use the other as the compaibilty between the 2 scripts. any help be most greatful.



<?
require("inc/header.inc.php");
$Result = mysql_query("select id, sender, subject, date, status, NickName from Messages where NickName='$NickName'");
if($sender['sender'])
echo"
<table border=0 cellspacing=1 cellpadding=2 width=95% bgcolor=AAAAAA align=center>
<tr>
<td bgcolor=E0E0E0>&nbsp;</td>
<td bgcolor=E0E0E0>From:-</td>
<td bgcolor=E0E0E0>Subject:-</td>
<td bgcolor=E0E0E0>Date:-</td>
</tr>";
while($row = mysql_fetch_array($Result)){
$id=$row["id"];
$sender= $row["sender"];
$date=$row["date"];
$subject=$row["subject"];
echo"<tr bgcolor=#FFFFCC>
<td width=34> <div align=center>$status</div></td>
<td width=346><b><a href=read.php?id=$id>$sender</a></b></td>
<td width=314><b><a href=read.php?id=$id>$subject</a></b></div></td>
<td width=250><div align=left>".(date("d M Y / H:i"))."</div></td>"; }
echo"</table>";
} else { echo "<center><B>No messages found.</B></center><P></P>";}
include('inc/footer.inc.php');
?>

and do you have any errors posted back ?
Do you have $nickname defined ?
Whats 'not' happening ? or what is u want to happen ?

Yeah we can't really help you if we don't know what error you're getting

is it a MySQL error?

well the problem I am getting is that I want this to say that there is no messages when there are none as you can see from the code of what I am trying to do..

As soon as an entry is made into the database for username $NickName it shows the information ok, but when there is no info in the database it shows no information, when its ment to show the page as ,,, No Messages Found..

No errors posted back and what you meen $nickname defined? thats the hole page i have posted above.

Check your curly bracket pairs, seems not match.

Check your curly bracket pairs, seems not match.
Yeah seems like it:

if($sender['sender'])
{ //// <-- this bracket is missing ?

I do apoligise, I missed out that bracket wen I posted this forum, that bracket is there, was only thing I had missed out, but I still have the problem

You can view the source from your browser to see whether what part of code has been executed by the server, then you can locate where the problem is.

I checked it and it dont seem to be printing the $sender which is a vital part to make it work, im still workin on fixing it but wiv no luck

if (mysql_num_rows($Result)==0) {echo '<center><B>No messages found.</B></center><P></P>';}
That should do the trick.
also it is :
if($sender['sender'])
change to
if($row['sender'])

and the output will not work :
<a href=read.php?id=$id>$sender</a>
will give you a wrong link the right way to do it is :
<a href=read.php?id='.$id.'>'.$sender.'</a>

as well as the other rows

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dating/public_html/other/Dating/view.php on line 25
No messages found.

let me see if I can write this in a clearer way :

<?
require("inc/header.inc.php");
$Result = mysql_query("select * from Messages where NickName='$NickName'");
$num_rows = mysql_num_rows($Result);

if ($num_rows==0)
{echo '<center><B>No messages found.</B></center><P></P>';}
else {
echo '<table border=0 cellspacing=1 cellpadding=2 width=95% bgcolor=AAAAAA align=center>
<tr>
<td bgcolor=E0E0E0>&nbsp;</td>
<td bgcolor=E0E0E0>From:-</td>
<td bgcolor=E0E0E0>Subject:-</td>
<td bgcolor=E0E0E0>Date:-</td>
</tr>';
while($row = mysql_fetch_array($Result))
{
$date=$row["date"];
echo'<tr bgcolor=#FFFFCC>
<td width=34> <div align=center>$status</div></td>
<td width=346><b><a href=read.php?id='.$row["id"].'>'.$row["sender"].'</a></b></td>
<td width=314><b><a href=read.php?id='.$row["id"].'>'.$row["subject"].'</a></b></div></td>
<td width=250><div align=left>'.(date("d M Y / H:i")).'</div></td></table>';
}
}
include('inc/footer.inc.php');
?>

Do you access this file with filename.php?NickName=nickname

no, im useing _session thats passing the NickName..

Thank you for the script that made things lot clear to me and now it works :)

Sure no problem, that's what wht is all about. I really hope this works cause I did it in a hurry.

yea this works perfectly, differnt to how my other codes work but this actualy looks more professional to what I have done :)

I have another question,
How do I make it that one line shows as grey and the other pale blue? if you know what I meen

:) well not exactly - do you want your results displayed in different colors (i.e. one blue row one gray row etc.)

yup exactly what I meen

well personally I do it like that add this :
$i=1;
at the beginning of the code (right after <?php)
and modify this line :

echo'<tr bgcolor=#FFFFCC>

to this :


if ($i%2===0) {echo '<tr bgcolor=#gray>';}
else {echo '<tr bgcolor=#blue>';}
$i++;
echo '


remember to change the color codes the way you want them

that changes the colors ok :) but,
it broken the table up, the first row is ok but then the next 2 rows are showing up in place of the footer

Sorry I am not looking at the html at all :) here you go paste after the while :


while($row = mysql_fetch_array($Result))
{
$date=$row["date"];
if ($i%2===0) {echo '<tr bgcolor=#gray>';}
else {echo '<tr bgcolor=#blue>';}
$i++;
echo '<td width=34> <div align=center>$status</div></td>
<td width=346><b><a href=read.php?id='.$row["id"].'>'.$row["sender"].'</a></b></td>
<td width=314><b><a href=read.php?id='.$row["id"].'>'.$row["subject"].'</a></b></div></td>
<td width=250><div align=left>'.(date("d M Y / H:i")).'</div></td></tr>';
}
echo '</table>';
}
include('inc/footer.inc.php');
?>

Thank You :) I am becomeing so proud of this work that you sorted out for me :)
all perfect now :D

If I find anything else I need help with, is it ok to email you useing the private message or just add to this forum?

Well let's not spam the board - just PM me and if I have the time I'll certainly be happy to help. Good luck.

ermm dont meen to sound dumb but what do you meen?

send me a private message :)