Help With Php/mysql

[tdktank59 0]

Hey im working on a scrip that charges a "cartel" for being at war with another "cartel" and i cant seem to get this to work just right...

 

heres what i have so far

 

$cartel = mysql_query("SELECT drugringID FROM drugringwars WHERE drugringID = {$declarer['warDECLARER']} ");while ($ids = mysql_fetch_array($cartel))	{	echo "cartel {$ids['drugringID']} has been charged for being at war with another cartel";	$cost = 1000000 * (rand(1,10));	mysql_query("UPDATE drugrings SET drugringdough=drugringdough-{$cost} WHERE drugringID={$ids['drugringID']}  ");	echo "</br>";		}

 

and these few things may help a bit when trying to help me...

the stuff in the while {} works fine just cant get an id from the db so heres a few things

 

drugrings:

 

drugringwars:

[hts 0]

$cartel = mysql_query("SELECT drugringID FROM drugringwars WHERE drugringID = {$declarer['warDECLARER']} ");

 

what is the point of getting the value of a mysql field which you already know?

[tdktank59 0]

yeah i know lol i cant figure out what to do... i just kept messing with the code till i normaly get it to work...

[tdktank59 0]

found the problem thanks for those who tried to help me