not looping

[pinehead18]

<?php

    $name = $HTTP_COOKIE_VARS['user'];
    $con = mysql_connect("localhost","","") or die(mysql_error());
    $db = mysql_select_db("pinehead",$con) or die(mysql_error());
    $sql = "SELECT * FROM we where user='$name'";
      $result =  mysql_query($sql) or die(mysql_error());
    while ($row =  mysql_fetch_array($result)) {
    $body = $row['body'];
    $subject = $row['subject'];
    $table = "<table border=0 cellpadding=1 cellspacing=1 width=90%>

    <tr>
            <td bgcolor=#eeeeee>".$subject."</td><td bgcolor=#eeeeee
align=right>Delete&nbsp;-&nbsp;Edit</td>
        </tr>
        <tr>
                <td bgcolor=lightblue>".$body."</td>
        </tr>
</table>";


}

Ok this is my code.. It is suppose to loop all the conents in the db but it only does one row.

Any suggestions?
Thank you
Anthony

[drag0n]

u do know that ur creating a new table for each record right?

[pinehead18]

That is what i want to do, but it iisn't working.

[laserlight]

For debugging, try something like:

<?php

$name = $HTTP_COOKIE_VARS['user'];
$con = mysql_connect("localhost","","") or die(mysql_error());
$db = mysql_select_db("pinehead",$con) or die(mysql_error());
$sql = "SELECT * FROM we where user='$name'";
$result = mysql_query($sql) or die(mysql_error());
//for debugging
echo 'Result Count: "' . mysql_num_rows($result) . '"<br>';
//end debugging
while ($row = mysql_fetch_array($result)) {
	$body = $row['body'];
	$subject = $row['subject'];
	$table = '<table border="0" cellpadding="1" cellspacing="1" width="90%">
<tr>
<td bgcolor=#eeeeee>' . $subject . '</td>
<td bgcolor="#eeeeee" align="right">Delete&nbsp;-&nbsp;Edit</td>
</tr>
<tr>
<td bgcolor="lightblue">' . $body . '</td>
</tr>
</table>';
}

[pinehead18]

I'm echoing the table where i want it to display in the html...

[laserlight]

I suspect that your query is only returning 1 row, hence check with mysql_num_rows() as I suggested in my code snippet.

[Sharif]

You have a WHERE in your query which makes it so that only rows where the WHERE statement is valid will be returned. Your current WHERE is WHERE user='$name'. Are you trying to return all the records for a certain user? Maybe you need to add anothe WHERE condition...

[pinehead18]

Yes I want it to display all records which the user field = $uname.

So far i have 4 records that equal that.. Yet still only posts one feild.. Not all of them..

Ideas?

Thanks
Anthony

[drag0n]

so u want to fetch all rows which have "$name" as the field/column "name" you said something about $uname in ur previous post... so maybe u should check ur query like laserlight pointed out

[pinehead18]

Nah it works just fine.. It just doens't loop.. or post all the rows with the user.

[Sharif]

Pinehead18,

The variable that contains that table code, instead of having a variable. Use "echo". I mean you should just use echo to output the table code, I'm pretty sure that should work.

[pinehead18]

Then i cannot put the output where i want...

Anthony

[laserlight]

I know the problem :o

Your loop assigns the string to $table on each iteration.
You actually want the loop to concatenate, or append, the current data retrieved to the data from previous iterations.

As such, you should use:

$table .= '<table border="0" ...

[pinehead18]

that doesn't work.. Just gives me a parse error....

any other ideas?

[laserlight]

parse error?

all you need to do is to change the assignment operator to the concatenation assignment operator.

I presume you took my code wholesale, which um, is a little silly.

The resultant script should be:

<?php
$name = $HTTP_COOKIE_VARS['user'];
$con = mysql_connect("localhost","","") or die(mysql_error());
$db = mysql_select_db("pinehead",$con) or die(mysql_error());
$sql = "SELECT * FROM we where user='$name'";
$result = mysql_query($sql) or die(mysql_error());
//for debugging
echo 'Result Count: "' . mysql_num_rows($result) . '"<br>';
//end debugging
while ($row = mysql_fetch_array($result)) {
    $body = $row['body'];
    $subject = $row['subject'];
    $table .= '<table border="0" cellpadding="1" cellspacing="1" width="90%">
<tr>
<td bgcolor="#eeeeee">' . $subject . '</td>
<td bgcolor="#eeeeee" align="right">Delete&nbsp;-&nbsp;Edit</td>
</tr>
<tr>
<td bgcolor="lightblue">' . $body . '</td>
</tr>
</table>';
}

[pinehead18]

It still will only display the last row. and not all of them...

Any other ideas ?

[pinehead18]

ok.. i think i found the prob.. it is just replacing the row.. Let me work on something and get back with you..

/me slaps himself

[pinehead18]

Slight problem now.. THat modified code you gave me doesn't post anything at all..

Suggestions?