[PHP-DB] Load balancing and SQLite

2004-05-15 Thread Andy Ladouceur
Hey everyone, Currently planning out the databases for a large project, and have decided to use separate SQLite database files for each users hit statistics. The problem is, there are two webservers, with a load balancer. I'm wondering what suggestions people might have on accessing the sqlite

[PHP-DB] Re: passing var array

2004-04-26 Thread Andy Ladouceur
You can pass arrays via GET using the syntax: http://localhost/index.php?val[1]=oneval[2]=2...val[key]=value Andy Pete M wrote: http://localhost/index.php?val_one=oneval2=2 on index.php print_r($_GET) will show the array echo val l=.$_GET['val_one']; echo val 2=.$_GET['val2']; its CAse

[PHP-DB] Re: stuck on stupid...can't find the bloody error...

2004-04-25 Thread Andy Ladouceur
Dan Bowkley wrote: else { $query_insert = INSERT INTO boards (wo_num, name, phone, email, date, board_type, last_three, weight_in, weight_out) VALUES (\'$wo_num\', \'$name\', \'$phone\', \'$email\', \'$date\', \'$board_type\', \'$last_three\', \'$weight_in\', \'$weight_out\'); No need to

[PHP-DB] Re: How to display table columns

2004-04-25 Thread Andy Ladouceur
I think what you may be looking for is the DESCRIBE command. It allows you to get information about table columns. http://dev.mysql.com/doc/mysql/en/DESCRIBE.html Andy Andy Amol wrote: hi, I want to display the table coulumns along with those values below it. I am only able to display the

[PHP-DB] Re: Regular Expression

2004-04-19 Thread Andy Ladouceur
A regexp like this should work: /^([a-zA-Z]|\s)+$/ Cheers, Andy Ladouceur Andy Amol wrote: Hi, I would like to test whether a given sting contains only character, it should also support spaces. eg Course Book String. I am able to test CourseBookString. Also I would like to know how can we

[PHP-DB] Re: insert data in mysql table

2004-04-11 Thread Andy Ladouceur
From what I can see, the order that you created the table with and the order of the fields in the query do not match up. Changing the query to: $add_all = INSERT INTO $table values('','$name','$day','$question','$email',''); Should make things run just fine. Cheers, Andy Charalambos Nicolaou

[PHP-DB] Re:*FIX* insert data in mysql table

2004-04-11 Thread Andy Ladouceur
Oops. I left a field in. Change it to: $add_all = INSERT INTO $table values('','$name','$day','$question','$email'); Andy Andy Ladouceur wrote: From what I can see, the order that you created the table with and the order of the fields in the query do not match up. Changing the query

[PHP-DB] Re: br appear in Text file

2001-08-27 Thread Andy Ladouceur
Hi Jack, The 'black box' you see is a newline, which can be removed by doing this: $string=str_replace(\n,,$string); $string=str_replace(\r,,$string); That will replace \n (The newlines) and \r (The returns) with nothing, getting rid of your problem. Hope this helps, -Andy Jack [EMAIL PROTECTED]