Please help me with some SQL

Please help me with some SQL

am 07.07.2006 06:49:08 von patrick finger

Hi there folks.. :)
I've got some troubles here, The man that can, dont give a S..., with others
problems.. I tried to ask for a solution but nothing helped..

Here is what he said i should do :

Simply put the SQL-Statement and take out all the filter-stuff. That should
do it.

And how do i do that..lol
I hope some of you guys or Girls can help me with this...
The code is :

function addUnCategorized($categories)
{
$weapons = array();
$res = SQL_query("select distinct weapon from selectbf_kills_weapon order
by weapon ASC");
while($cols = SQL_fetchArray($res))
{
array_push($weapons,$cols);
}

for($i = 0; $i {
$members = $categories[$i]["members"];

$uncategorized = array();

for($j = 0; $j {
$found = false;
for($k = 0; $k {
if($weapons[$j]["weapon"]==$members[$k]["member"])
{
$found = true;
}
}
if($found == false)
{
array_push($uncategorized,array("weapon"=>$weapons[$j]["weap on"]));
}
}

$categories[$i]["uncategorized"] = $uncategorized;
}

return $categories;
}

Best Regards
Ulle

Re: Please help me with some SQL

am 07.07.2006 15:34:31 von Techie123

Why wont the boss man let you simply use the code you already have if
it does the same thing? I mean, why should they/he/she care if it
really does the same thing....That may not be the case though...in
which you may need to convert it to sql, which shouldn't be hard if
your just trying to find entries with specific key words in specific
fields (which most people are....) then again I could be way off.