MySQL query problem

[icd_lx]

When I entered the same queries into MySQL manually as are in the 2nd FOR loop, I got results.

But the PHP script won't show anything. What is wrong?

---

for($count=$first; $count<=$last; $count++)
{
$dummy = mysql_query("SELECT FROM posts WHERE number='$count' AND thread ='$topic'", $connect);
$check = mysql_fetch_array($dummy);
if($check[thread] = $topic && $check[number] == $count)
{
$postdata[$count] = $check;
}
}
for($count=$first; $count<=$last; $count++)
{
echo "<TR>";
$sql=mysql_query("SELECT FROM users WHERE username='$postdata[$count][user]'", $connect);
$profile=mysql_fetch_array($sql);
$sql2=mysql_query("SELECT number FROM posts WHERE user='$postdata[$count][user]'", $connect);
$totalposts=mysql_num_rows($sql2);
echo "<TD WIDTH='30%'>".$postdata[$count][user]."<BR>".$profile[status]."<BR>".$totalposts."<BR>".dconvert($postdata[$count][date]);
echo "</TD><TD WIDTH='70%'>".$postdata[$count][post]."</TD></TR><BR>";
if($count == $last)
{
echo "</TABLE>";
}
}

[Anon]

Whenever I get stuck with the queries, I copy the query code to a print statement and put it on screen. Often you'll find a key component missing on screen when it looks fine in the code.

e.g.
$query="select x, y, z from table1 left join table2 on ww=zz where x>1 and t!='$var'";
$result=mysql_db_query("DB",$query);
print $query;
print mysql_error();

This will build the query, run it, then show you what it ran and then any errors is hit.