hi i need some more help

Evan_Morgan

i recently started a small practise project where the user can store any get paid to read sites that they know of in a database. The adding part works fine but displaying it is not working.
This is the code i already have.

include ('dbconnect.php');

$selectall = mysql_query(" select * from sites ");

$count = mysql_fetch_row( $selectall );

?>
<html>

<head>

</head>

<body>

<table border="0" width="100%" align="center">
<tr><td>Link to site</td>
<td>Signup bonus</td>
<td>Minimum Payout</td>
<td>Average earnt per day</td>
<td>Average time till first Payout</td>
<td>Levels of referral commission</td>
</tr>
<?
while($count = mysql_fetch_array($selectall))
{
echo "<tr><td><h href='$count[0]'>$count[6]</a></td>
<td>$$count[1]</td>
<td>$$count[2]</td>
<td>$$count[3]</td>
<td>$count[4] days</td>
<td>$count[5]</td>
</tr>";
}
?>

</table>
</font>
</body>

</html>

I dont know whats wrong, i know i write it a bit funny, with the html outside the php but i find it clearer for me then.

Any ideas?

Evan

petitduc

First you call mysql_fetch_row and do nothing with it, then mysql_fetch_array.
You have 2 $ signs in some of your variable names which is incorrect in this context.
Remove mysql_fetch_row and use $count[1], ... instead of $$count[1]

Evan_Morgan

Originally posted by petitduc
First you call mysql_fetch_row and do nothing with it, then mysql_fetch_array.
You have 2 $ signs in some of your variable names which is incorrect in this context.
Remove mysql_fetch_row and use $count[1], ... instead of $$count[1]

o rite, the $$ i thought i could use because i wanted a dollar sign before the number that comes from the database (its a monetry value)

What do you mean with the fetch row and fetch array

Evan

petitduc

If you want to put a dollar sign in a string I suggest you use string concatenation, for example :

$dollars = "$".$count[1];
echo "<td>$dollars</td>";

Originally posted by Evan Morgan
What do you mean with the fetch row and fetch array

Evan [/B]

You first assign to a variable a resultset obtained through mysql_fetch_row, then reassign the same variable without having used the previous assignment to do anything.
So this first assignment is useless in your code.