array needed to compare to other values

[mdburton]

$row = mysql_fetch_array(mysql_query("SELECT enemies FROM $tab[crew] WHERE id='$cid'"));
$array = explode (",", $row[0]);

$crewupdate = mysql_query("SELECT id,name,founder FROM $tab[crew] WHERE id>0 AND id!=$array[] ORDER BY name ASC;");




This doesn't yeild anyresults since you cant use '[]' in query, however i have tried just the name but that doesnt work, when i try [0] it only uses the first array space to compare not the others

when i print the array after explode I get this

Array ( [0] => 8 [1] => 2 [2] => 14 [3] => 10 )

Basically I want to desplay all the information of the crews that are not 'enemies'

i know php fairly well but im not to familiar with more advance query formats

[mdburton]

help = ( (10characters))

[devsusen]

hi,

you need to run the 2nd query within a for loop and and you need to pass the loop counter in the query as -

$crewupdate = mysql_query("SELECT id,name,founder FROM $tab[crew] WHERE id>0 AND id!=$array[$counter] ORDER BY name ASC;");

susen

[mdburton]

ok ill try that out later today lol

hopefully i can get it working otherwise if anyone else can explain this in more details go ahead otherwise i think i understand what susen said

[mdburton]

i couldnt get what i thought you said lol

<td id="crewList">
<div><b>Crews </b></div><select name="crew_idz" id="crew_id" size="10" width="20">
<?
$row = mysql_fetch_array(mysql_query("SELECT enemies FROM $tab[crew] WHERE id='$cid'"));
$row['array'] = $row[0];
$array = explode (",", $row[0]);
$sizeof= count($array);
for($counter = 0; $counter< $sizeof; $counter++){
$crewupdate = mysql_query("SELECT id,name,founder FROM $tab[crew] WHERE id>0 AND id!=$array[$counter] ORDER BY name ASC;");
}
//$crewupdate = mysql_query("SELECT id,name,founder,city,icon,networth,members,rank,wo rth,crewthug,crewmoney FROM $tab[crew] WHERE id>0 AND id!=explode(",", $row[0]) ORDER BY name ASC;");
while ($t10 = mysql_fetch_array($crewupdate))
{?><option value="<?=$t10[0]?>"><?=$t10[1]?></option>

<?}?></select>
</td>


I want it to display all the ones that arent enemies, but it doesnt work

ill do more edits later tonight to see if i can do it myself but if anyone has a clue = )

[mdburton]

alright well i got it to work but i think the coding is horrible lol

also some of the code might not be needed persay lol i used most of it for troubleshooting

<td id="organizationList">
<div><b>Crews <?=$array[6]?></b></div><select name="crew_idz" id="crew_id" size="10" width="20">
<?
$row = mysql_fetch_array(mysql_query("SELECT enemies FROM $tab[crew] WHERE id='$cid'"));
$row['array'] = $row[0];
$array = explode (",", $row[0]);
$sizeof= count($array);
$sizeof2= count($array);
$all= mysql_query("SELECT count(*) FROM $tab[crew]");
$total = mysql_result($all, 0, 0);
$sizeof= $sizeof;
$sizeof = $total-$sizeof;

$counterplus= $counter+1;

$crewupdate = mysql_query("SELECT id,name,founder FROM $tab[crew] WHERE id!='$cid' ORDER BY name;");


while ($t10 = mysql_fetch_array($crewupdate))
{
//$t10 = mysql_fetch_array($crewupdate);
$error=0;
for($counter2 = 0; $counter2< $total;$counter2++){
if($array[$counter2] == $t10[0]){
$error=1;
}
}
if($error==0){
?>

<option value="<?=$t10[0]?>"><?=$t10[1]?></option>

<?

}
}?></select>
</td>
<td id="enemyList">
<div><b>Enemies</b></div><select id="enemy_id" size="10">
<?
$sizeof= count($array);

for($counter = 0; $counter< $sizeof; $counter++){
$crewupdate = mysql_query("SELECT id,name,founder FROM $tab[crew] WHERE id>0 AND id=$array[$counter] ORDER BY name ASC;");
while ($t10 = mysql_fetch_array($crewupdate))
{?><option value="<?=$t10[0]?>"><?=$t10[1]?></option>
<?}}?></select>
</td>

[gypsygal]

$row = mysql_fetch_array(mysql_query("SELECT enemies FROM $tab[crew] WHERE id='$cid'"));
$array = explode (",", $row[0]);

$crewupdate = mysql_query("SELECT id,name,founder FROM $tab[crew] WHERE id>0 AND id!=$array[] ORDER BY name ASC;");

hmm..i m not sure if this is wat u want, but i think u might not need to create an array to compare.

if ur id in first query is equal to the enemies in second query.


SELECT id,name,founder FROM $tab[crew] WHERE id>0 AND id NOT IN (SELECT enemies FROM $tab[crew] WHERE id='$cid')
ORDER BY name ASC;