[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

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] 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] 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 in

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(

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] 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

[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] 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] D

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

2003-12-12 Thread JeRRy
Hi, Okay I don't want any code here, well not yet, I am just wondering if this is possible. And: - Is it secure/safe ? - Will it use alot of resources ? - Will it harm my system or create security holes ? - Will it do anything bad ? :P - Should I do it or should I not ? (if it is possible) Okay

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:

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

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

2003-12-12 Thread Griffiths, Daniel
you have the GET var in the hyperlink down as just 'id' not 'tutor_id', so change the hyperlink to echo "Modify"; or the the get var to $tutor_id = $_GET['id']; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 10:02 To: Griffiths, Daniel Cc: [

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

2003-12-12 Thread irinchiang
Yes I'm using a hyperlink to access this page (see below) echo "Modify"; 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 /usr/local/apache/htdocs/tutor/edit.php " WHat could be the problem?;(

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 hyperlink

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

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

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 do

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 session_register("