Frustrating php

[snike]

OK, so I have this code: http://pastebin.ca/320995

but it doesnt find anything in the database! it should find 3 rows that are the same!

 

[Chicken]

OK, so I have this code: http://pastebin.ca/320995

but it doesnt find anything in the database! it should find 3 rows that are the same!

//IF THEY HAVE IT
if($do == "have") {
$getitems = mysql_query("
SELECT *
FROM questsp
WHERE user = '$user'
") or die("error");
while($rowgit = mysql_fetch_array($getitems)) {
$items1 = $rowgit['items'];
$itemsn1 = split(",",$items1);
$item1 = $itemsn1[0];
$item2 = $itemsn1[1];
$item3 = "Iron Sword";
$check1 = mysql_query("
SELECT * FROM inven WHERE item = '$item1'") or die ("". mysql_error() ."");
$num1 = mysql_num_rows($check1);

print "$item1 $num1 $check1";
}

 

[TwistMyArm]

And... what is it finding?

The one thing I can think of is that your second query (the one in the loop) is probably 'killing' the original query. ie. it's probably 'overwriting' the first query, essentially stopping it from doing any looping or anything.

 

[Dan]

Add error_reporting(E_ALL); to the beginning of your code. I'm sure you'll get some notices which probably explain what's going on.