[PHP-DB] SQLITE

2003-11-22 Thread Bronislav Kluka
Hi, I've got questions: I've got sqlite like PHP module (under windows). I tried this: a)execute script 1 (selecting from some table), it tooks 2 minutes b)execute script 2 , it tooks 3 minutes c)execute them both at the same time (from different browser windows), both of

[PHP-DB] Re: [PHP] SQLITE

2003-11-22 Thread Chris Shiflett
--- Bronislav_Kluèka [EMAIL PROTECTED] wrote: Hi, I've got questions: I only noticed one. I've got sqlite like PHP module (under windows). I tried this: a)execute script 1 (selecting from some table), it tooks 2 minutes b)execute script 2 , it tooks 3 minutes c)execute them both at the same

RE: [PHP-DB] Re: [PHP] SQLITE

2003-11-22 Thread Bronislav Klucka
That's my code: $dbfile=db.sdb; $db=sqlite_open($dbfile); $res=sqlite_query($db,select a.*,b.* from a left join b on a.id=b.id_a where a.name like \%1%\ or b.street like \%1%\ order by cellphone); echo sqlite_num_rows($res).CRLF; sqlite_close($db); It's realy just benchmark I've done. I'm pretty

[PHP-DB] Validating a Session value

2003-11-22 Thread Aleks Kalynovych
Hi all, I am trying to figure out a way to calculate a value based on another value and then set that value in a session variable. So, if $session_ValueA = $100 set $session_fee = $10 Or If $session_ValueA $100 and $499 set $session_fee=$20 Or If $session_VAlueA $499 and $999

[PHP-DB] photos in a folder

2003-11-22 Thread elias
Hey. first of, im really new to PHP, so im still learning. The problem i have now is: i have a dir with 600+ photos, and a database with 500+ photos (due to the fact that when i deleted photos from my webpage, i apparently only deleted it from the database, and not the dir. so.. can someone

RE: [PHP-DB] photos in a folder

2003-11-22 Thread Nigel Jones
I'd personally use a SQL DB Class(PHPLib has a good one - http://phplib.netuse.de ) Also for this you need the File Class which you can get at http://www.thewebmasters.net Basicly then just use the FileClass to Produce a Dir Listing then do a 'for' statement for every file, then query that file

[PHP-DB] Re: [PHP] RE: [PHP-DB] Re: [PHP] SQLITE

2003-11-22 Thread Gerard Samuel
On Saturday 22 November 2003 06:43 pm, Bronislav Klucka wrote: It's realy just benchmark I've done. I'm pretty much aware of system sqlite is useing to store the data, and I also find obvious that if it would be runnig like web database module, users will ask the same table ata the same time