I need a little help...

philvia

Okay, this is like an automated eregi_replace thing... You can buy the "Post Upgrade" in the shop and this code is supposed to check to see if you have purchased the item and then echo the regex part. but it does not. Any suggestions?

$shopitem1 = mysql_query("SELECT * FROM shopitem");
			while ($shopitem = @mysql_fetch_array($shopitem1)) {
				$itemval = ''.$shopitem['value'].'';
				$shopitem2=@mysql_num_rows(mysql_query("SELECT * FROM shopbuy WHERE userid = ".$u['userid']." AND item = '".$shopitem['id']."'"));
				if ($shopitem2 >= 1) { $itemval; }
			}

TheDefender

Pardon me while I change up the code just a little........

$shopitem1 = mysql_query("SELECT * FROM shopitem");

while ($shopitem = @mysql_fetch_array($shopitem1)) { 

  $itemval = $shopitem['value']; // Change this line to what I have here

  $shopitem2=@mysql_num_rows(mysql_query("SELECT * FROM shopbuy WHERE userid = '".$u['userid']."' AND item = '".$shopitem['id']."'"));   // Where is the $u['userid'] being defined?  Also note the addition of the single quotes around that variable.

  if ($shopitem2 >= 1) echo $itemval;  // Don't need the curly braces here in your IF statement. 
}