[Resolved] mysql help question ?

[acey]

itsa a question i have been wondering about for a while an i cannot seem to find an answer for , an im just wondering you any of you would know

i have the following query an loop

$sql = "Select * from ign where whos='$uid'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$ign=$row["users"];

$Ignore = explode (",", $ign);

}

if ignore equals multiple names

such as ralph, freddy , chucky , angelica, ace

how can i use the mutiple result in a query like

if ($option!==send){
$sql = "Select theNick, theText from chatScript where thenick!='$Ignore'

TIA 😃

[TheIceman5]

explode()

[Weedpacket]

I'm just wondering why so many people here appear to have trouble with the English language.

I'm pretty sure MySQL has an "IN" construct, where you can see if something is IN a list of values, or NOT IN the list.

WHERE thingy IN ('foo', 'bar', 'baz')

[acey]

can someone explan this ?

[LordShryku]

$sql = "Select theNick, theText from chatScript where thenick!='$Ignore'

Ok, so what Weed is saying is that instead of using !=, use NOT IN.

For instance...

$Ignore = array("One", "Two", "Three");
/* 
  now you'll want to format it to 
  use in the query. you probably 
  never should've exploded it in
  the first place, but oh well, here
  we are with an array
*/

$this = "('".implode("','",$Ignore)."')";
/* This makes a string that looks like
   ('One','Two','Three')
*/
$sql = "Select theNick, 
               theText 
        FROM   chatScript 
        WHERE  theNick NOT IN ".$this;

Now you're doing it all in one query

[acey]

thank you very much!!!! i cant explain how thankfull i am LordShryku