Re: [PHP-DB] Shift_JIS Character Set

2003-12-12 Thread Jason Wong
On Friday 12 December 2003 14:47, Ng Hwee Hwee wrote: i'm doing a form (form.php) 1) user comes to form.php 2) user enters details and press submit 3) details get passed to form action verify.php 4) verify.php puts all the $_POST into an array $formVars 5) verify.php

Re: [PHP-DB] Shift_JIS Character Set

2003-12-12 Thread Ng Hwee Hwee
yes, and that's why i'm appealing for help on how to stripslashes when it comes to the Shift_JIS character set... will really appreciate advises! thanx lots! - Original Message - OK, if you *know* that the data has been through addslashes() (or equivalent eg magic_quotes_gpc) then

RE: [PHP-DB] NEXTVAL Question

2003-12-12 Thread N . A . Morgan
put the schema name before the sequence object you need to increment, i.e. $sql = select SCHEMA.TEAM_SEQ.NEXTVAL as \nextval\ from sys.dual; Regards, Neil Morgan -Original Message- From: Paul Miller [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 00:05 To: [EMAIL PROTECTED] Subject:

[PHP-DB] Need help!!!

2003-12-12 Thread irinchiang
Hi.. Anyone can help me with this script???I kept getting error saying i did not define the variable $tutor_id and whenever I define it as $tutor_id = $_POST ['tutor_id'], I got error saying there was an Undefined index! What was exactly the problem?? Need help desperately , greatly

RE: [PHP-DB] Need help!!!

2003-12-12 Thread Griffiths, Daniel
how are you getting the $tutor_id var?, in your script you are using $action = $_GET[action]; so you will need to define $tutor_id like $tutor_id = $_GET['tutor_id'], or just use $_GET['tutor_id']. a form can only put variables in the POST array OR the GET array, and if your using hyperlinks

RE: [PHP-DB] Need help!!!

2003-12-12 Thread irinchiang
Yes I'm using a hyperlink to access this page (see below) echo tda href=\edit.php?id=.$row [tutor_id].action=edit\Modify/a/td; and so I defined my variable $tutor_id as $tutor_id = $_GET['tutor_id']; but i still got the error: Undefined index: tutor_id in

[PHP-DB] Thanks alot Griffiths!=)

2003-12-12 Thread irinchiang
Thanks alot for your help! That was very careless of me..;p I was stil quite a newbie to php-db coding... By the way one last favour to ask of u hope u dun mind... I have a script which was used to INSERT data into the database: (See script below): But everytime when I execute it I got the

Re: [PHP-DB] pg_result_error()

2003-12-12 Thread Martin Marques
El Vie 12 Dic 2003 00:09, Gerard Samuel escribió: What good is this function? A quick example of the wall Im running into - $sql = 'INSERT INTO .'; $result = pg_query($conn_id, $sql); if ($result === false) { var_dump( pg_result_error( $result ) ); I would use here this:

Re: [PHP-DB] More of a question rather than seeking code. :)

2003-12-12 Thread Jason Wong
On Friday 12 December 2003 20:15, JeRRy wrote: [snip] I just recently added a flag in the database so if the email bounces I manully flag the account as a bad email so in future emails won't be sent to that users email unless they correct their email. This is time consuming. [snip] Do

[PHP-DB] anyone trickier than 'LIKE' ?

2003-12-12 Thread Hadi
Hi all, I have this data (eg.) ..big fat buddy... on the database . If a person enter big buddy in the search form , the ...big fat buddy. data will not be found . Any suggestion ? Thanks in advance. select * from table where data like %keywords%; -- PHP Database

Re: [PHP-DB] anyone trickier than 'LIKE' ?

2003-12-12 Thread Larry E . Ullman
I have this data (eg.) ..big fat buddy... on the database . If a person enter big buddy in the search form , the ...big fat buddy. data will not be found . Any suggestion ? select * from table where data like %keywords%; You can break up the search terms into words and do

RE: [PHP-DB] anyone trickier than 'LIKE' ?

2003-12-12 Thread N . A . Morgan
$keywords = str_replace(' ','%',$keywords); select * from table where data like %keywords%; -Original Message- From: Hadi [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 13:21 To: [EMAIL PROTECTED] Subject: [PHP-DB] anyone trickier than 'LIKE' ? Hi all, I have this data (eg.)

Re: [PHP-DB] pg_result_error()

2003-12-12 Thread Gerard Samuel
Im going to CC this to the PostgreSQL list also. On Friday 12 December 2003 06:44 am, Martin Marques wrote: El Vie 12 Dic 2003 00:09, Gerard Samuel escribió: What good is this function? A quick example of the wall Im running into - $sql = 'INSERT INTO .'; $result = pg_query($conn_id,

Re: [PHP-DB] pg_result_error()

2003-12-12 Thread Martin Marques
El Vie 12 Dic 2003 11:19, Gerard Samuel escribió: Im going to CC this to the PostgreSQL list also. On Friday 12 December 2003 06:44 am, Martin Marques wrote: El Vie 12 Dic 2003 00:09, Gerard Samuel escribió: What good is this function? A quick example of the wall Im running into -

[PHP-DB] MSSQL Error message

2003-12-12 Thread Liana Cristine Leopold
Hi I´m using a connection using php 4.3.3 with sql server ... and i´m having a error message : mssql error: [: Connection error to server '192.0.0.6\binotto' with user 'LUA'] .. The user 'LUA' is the dbowner ... anyone can help me??? Sorry my bad english ... Liana Cristine Leopold

RE: [PHP-DB] Cronjob

2003-12-12 Thread Daevid Vincent
One thing I might suggest is to queue up your inserts, then use the extended insert syntax to populate several records at once in a single INSERT instead of 12 separate ones. I believe you can alter the /etc/my.cnf file to play more 'nice' as far as priorities and memory, but I've never touched it

[PHP-DB] Re: [PHP] [PHP-DB] pg_result_error()

2003-12-12 Thread Gerard Samuel
On Friday 12 December 2003 10:24 am, Martin Marques wrote: That is fine and all, but my original example was just an example of the non functionality of pg_result_error(), not how to handle errors when a query fails. But for arguement sake, lets use your example in some dummy code[0].