[PHP-DB] Help needed - SELECT query optimization

2008-10-26 Thread Nitsan Bin-Nun
Hi, I have a mysql database with one table in it, currently it contains 36,807 records and it costs 6.8MB of space, every night another thousand~ of rows are being added to the table. The scheme (as taken from phpmyadmin) is like follows: CREATE TABLE IF NOT EXISTS `search` ( `id` int(11) NOT

Re: [PHP-DB] using database without mysql installed

2008-10-25 Thread Nitsan Bin-Nun
Umm you can convert it to files-based database (for instance - .sq3 - sqlite) and work with it, and yes, installing mysql after php is possible. HTH, Nitsan On Sat, Oct 25, 2008 at 4:32 PM, YVES SUCAET [EMAIL PROTECTED] wrote: Well, *technicaly*... you could open a socket to the MySQL server

Re: [PHP-DB] Help in concatenation

2008-06-07 Thread Nitsan Bin-Nun
1. a class=?php print($class);? href=?php print($thispage.($y0?(?start=).$y:));??php print($pg);?/a 2. a href=?php print($thispage.($next0?(?start=).$next:));?/a turns into: ?php $string = 'a class=' . $class . ' href=' . $thispage; if ($y 0) $string .= \$start= . $y; $string .= '' . $pg