[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 t

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 na

[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 plea

[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

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'

[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 th

[PHP-DB] SQLITE

2003-11-22 Thread Bronislav Klučka
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 t