[PHP] mysql table speed

[Bas Jochems]

i've got a mysql table with about 150.000 record.
i'm getting data out of this table to generate statistic overviews

it seems that this is a problem, cause it takes a long time to generate
these overviews

q:   how can i speed up this table cause 150.000 records is not that
much i suppose?




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] Regex error

[Bas Jochems]

use
 $rgTemp = split('[|]',$szTag);

instead of
 $rgTemp = split("|",$szTag);

on line 2


PHP List wrote:

> Hi,
> Can someone please tell me why the this is happening:
>
> 1)   $szTag = "test|3";
> 2)   $rgTemp = split("|",$szTag);
> 3)   $szTag = $rgTemp[0];
> 4)   $nItemID = $rgTemp[1];
> ^line numbers for ref only, not in actual code.
>
> Will give me the error:
> PHP Warning:  unexpected regex error(14) in /test.php on line 2
>
> What is an error 14 ?
>
> Thanks,
> Chris
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] Arrat question

[Bas Jochems]

Hello,

Suppose i've got the following array

$a = array(
 "color" => "red",
 "taste" => "sweet",
 "shape" => "round",
 "name"  => "apple",
 3   => 4
);

Now I would like to remove the "color" field and  value. Whats the best
way to do this?

Thanks




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Array question

[Bas Jochems]

Hello,

Suppose i've got the following array:

$a = array(
 "color" => "red",
 "taste" => "sweet",
 "shape" => "round",
 "name"  => "apple",
 3   => 4
);

Now I would like to remove the "color" field and  value. Whats the best
way to do this?

Thanks.





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php