[Resolved] ??? what the ........

qrt123

This should be a simple query. But it only shows 3 items, and there are 5.

When I run the exact same query in my hosts PHP MYAdmin, I get 5 items, but on the website only 3.
What is wrong???

$foresp = mysql_query("SELECT id, navn, type FROM products WHERE godkendt = 'n'");
while($data = mysql_fetch_array($foresp)){
extract ($data);

echo "<table border=0 width=100%><tr>";
echo "<td width=5% class=table>$id</td>";

echo "<td width=60% class=table>$navn</td>";
echo "<td width=20% class=table>$type</td>";
echo "<td width=15% class=table><a href='rediger_produkt.php?id=$id>Godkend</a> </td>";
echo "</tr></table>";
}

Any suggestions???

Sincerely
qrt123

tomhath

Try to come up with a more descriptive subject for your threads. Some peoplewon't read the post if the subject doesn't make sense.

Regarding the problem you are having, the first thing to check is whether you are connected to the same database you had in phpmyadmin. Do you have a test database perhaps?

qrt123

Hi tomhat

Okay, you are right about the subject. Sorry, it was just an expression of total confusion.

No, I have no test database. Don't know what is going on.

Ther are 10 items in the database, and when I try to extract them all, I end up with only 5.

I'm really lost here.

bpat1434

Well, first the stupid stuff you probably have checked:

-- Have you checked the database for the queriable stuff? Like the column godkendt has the value of "n".
-- Have you checked what the number of rows that get returned are?
-- Have you tried printing what $data includes as far as the values are concerned?

Other than those few minor things, I don't see what would be going wrong. My guess would be it's in the extract($data); line. Have you tried nixing the extract() and using:
$id = $data['id'];
$navn = $data['navn'];
$type = $data['type'];
to see what the results are?

~Brett

qrt123

Thanx for the replies, and Your time.

Don't no what went wrong. But rewrote the echo-part of the code. Again!!!

And now everything is OK. :-)

Shit happens. I can't explain what I was doing wrong.

btw
thx again

qrt123