Coding Confusion

[Replicada]

well the code is below before i start my little frustrated rant.

<?php
session_start();
require ('config.php');
include('title.php');
include('resources.php');

$messages = mysql_query("SELECT * FROM messages WHERE user_id='$user'");
$messages2 = mysql_fetch_array($messages);
 ?>
 <table>
 <tr><td>From</td><td>Timesent</td><td>Subject</td></tr>
 <?php 
if($messages2){
while($row = mysql_fetch_array($messages))
 {
$sender_id = $row['sender_id'];
$sender1 = mysql_query("SELECT username FROM users WHERE id='$sender_id'");
$sender2 = mysql_fetch_array($sender1);
$sender = $sender2['username'];
$subject = $row['subject'];
$message = $row['message'];
$time = $row['time'];
$date = date('F j, Y, g:i a', $time);
echo "<tr><td>" . $sender . "</td><td>" . $date . "</td><td>" . $subject . "</td></tr>";
 }
}
else{echo "<tr><td>You have no new Messages<td></tr>";}
 
 ?> </table>

 <?php include ('suffix.php'); ?>

obviously the config, resources and other includes have within them predefined variables that are used in the script. The part that seems to be malfunctioning is the while loop, or thats what it seems.

I have read on the php website the following, and it seems to apply:

If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the same name, you must use the numeric index of the column or make an alias for the column. For aliased columns, you cannot access the contents with the original column name.

http://uk.php.net/manual/en/function...etch-array.php

I am literally blown away at this point, all my other code seems to function fine, but this seems to hault at this hurdle. The diea behind it is that it looks up in a message database a user's id and finds references to all their messages, and siaplys one message per row of a table.

The code does execute without error btw, its just it only displays the final message in the database !

Database includes the following records:

table messages
user_id, sender_id, subject, message, time
1,1,testing123,testing123,1234567890
1,2,tester123,tester123,1234567899

table users
Username=Replicada, id=1
Username=Demo, id=2

Any help would be appreciated thanks

[firmaterra]

Can you post the error message thrown??

[Replicada]

As i said its probably not a fault with my code, as it does execute without error. It's the fact that the Loop does not function as it should.

When the query searches for all messages with user id 1, it should return 2 rows(As there are two messages for user 1), not just 1. Therefore i used a while loop to hopefully produce two rows in my table, but it only retrieves 1 row still, bizarely the last one...

I was just wondering how you retrieve two rows in a query as the function mysql_fetch_array only retrieves a single row, and places it in an array for use in the script.

[QuietDean]

Try using this code

<?php
session_start();
require ('config.php');
include('title.php');
include('resources.php');

$messages = mysql_query("SELECT * FROM messages WHERE user_id='$user'");

 ?>
 <table>
 <tr><td>From</td><td>Timesent</td><td>Subject</td></tr>
 <?php 

while($row = mysql_fetch_array($messages))
 {
...

Also remove the closing } from the "if" I took out. Tell me how it goes.

[HTML]

Are my eyes playing tricks on me or did I just read a post made today by quietdean?

Welcome back stranger!

[QuietDean]

Hi Dave