[MySQL][PHP] Gdzie robię błąd ? Opcje

[tofik1778983]

Witam
Chcę zapisać do bazy wpis ktorego jeszcze nie ma.. jeśli juz jest ma sie wyświetlić komunikat.. oto kod:

[PHP] pobierz, plaintext 
			$min = 1;
			$max = $lvl -> fields['level'] +15;
 
			$plan = $db -> Execute("SELECT * FROM `smith` WHERE owner=0 && level between ".$min." and ".$max." && (type='A' || type='S' || type='H' || type='W' || type='L') ORDER BY RAND() LIMIT 1");
			echo'wylosowano:  '.$plan -> fields['name'];
			//$smith = $db -> Execute("SELECT * FROM `smith` where owner>0");
			$spr = $db -> Execute("SELECT count(*) as name FROM smith WHERE name=".$plan->fields['name']." && type=".$plan->fields['type']." && level=".$plan->fields['level']." && owner=".$player->id);
			//echo'<br><br>'.$spr->fields['name'].'<br><br>';
			if($spr->fields['name'] > 0)
			{
				echo'ten już jest w bzaie';
			}
			else
			{
				$db -> Execute("INSERT INTO smith (owner, name, type, cost, amount, level, lang) VALUES(".$player -> id.", '".$plan -> fields['name']."', '".$plan -> fields['type']."', ".$plan -> fields['cost'].", ".$plan -> fields['amount'].", ".$plan -> fields['level'].", '".$plan -> fields['lang']."')");
			}
[PHP] pobierz, plaintext 

Ten post edytował tofik1778983 1.12.2010, 02:08:49