|
|
Posted by Martie on 07/06/06 23:54
On Thu, 6 Jul 2006 23:08:35 +0200, Ulle wrote...
>
>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...
You can design your SQL queries lots of ways, depending on the type of
information you need and their relation to each other.
Not sure what you need as a result, but when you add statements similar to
"WHERE some_id > 0" to your query, it will narrow down the results. Using ORDER
will just change that, the order the result display in, so it won't expand or
lessen the number of results you get back.
Based on the available information it looks like you don't have any WHERE
clauses limiting your result.
Martie
--
Newsguy Express $9.95 monthly
http://newsguy.com/overview.htm
>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<count($categories); $i++)
> {
> $members = $categories[$i]["members"];
>
> $uncategorized = array();
>
> for($j = 0; $j<count($weapons); $j++)
> {
> $found = false;
> for($k = 0; $k<count($members) && $found==false; $k++)
> {
> if($weapons[$j]["weapon"]==$members[$k]["member"])
> {
> $found = true;
> }
> }
> if($found == false)
> {
> array_push($uncategorized,array("weapon"=>$weapons[$j]["weapon"]));
> }
> }
>
> $categories[$i]["uncategorized"] = $uncategorized;
> }
>
> return $categories;
>}
>
>Best Regards
>Ulle
>
>
Navigation:
[Reply to this message]
|