[PHP-DB] IBM DB2 and php

2003-10-19 Thread Gerard Samuel
Maybe in early August, I got my code to work with DB2 8.1.3 via ODBC after a bit of teeth pulling. I played with it for about 2-3 weeks, and it seemed ok (slow but ok). Earlier this past week, I was modifying the DB drivers for my script, and now, DB2 refuses to cooperate. I don't remember changin

Re: [PHP-DB] IBM DB2 and php

2003-10-19 Thread Gerard Samuel
Gerard Samuel wrote: example script | // body is a text field $sql = 'select id, user_id, name, time, body, ip from NULLID.guestbook for read only'; $result = odbc_exec($db->_connection_id, $sql); odbc_longreadlen($result, 0); odbc_binmode($result, 0); // Trying to retrieve 2nd row out of 6

[PHP-DB] Ranges query gone wild

2003-10-19 Thread Boaz Amit
Hi. I have a MySQL table where a product price ranges are set according to quantities. For instance for a certain product you'd have (besides id columns): range_begin | range_end | range_price 0 | 35 | 1.5 36 | 70 |

[PHP-DB] Re: Ranges query gone wild

2003-10-19 Thread Hugh Bothwell
"Boaz Amit" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > I have a MySQL table where a product price ranges are > set according to quantities. > For instance for a certain product you'd have (besides id columns): > > range_begin | range_end | range_price > 0

[PHP-DB] Re: Ranges query gone wild

2003-10-19 Thread Hugh Bothwell
(repost: first try bounced) "Boaz Amit" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > I have a MySQL table where a product price ranges are > set according to quantities. > For instance for a certain product you'd have (besides id columns): > > range_begin | range_end | r

[PHP-DB] PostgreSQL, Triggers

2003-10-19 Thread Ling
Hello there. Can anybody help me with Postgresql triggers? what I need is a trigger which inrements value in field "total_rows.rows" if I insert new row in table "zzz"... CAREATE TABLE zzz ( ... ... ); CREATE TABLE total_rows ( table_name VARCHAR(32), total_rows BIGINT, CONSTRA

[PHP-DB] PHP/MySQL Help

2003-10-19 Thread conbud
From: "Conbud" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: PHP/MySQL/Server not working Date: Friday, October 17, 2003 6:17 PM Hey, just a quick question, I have a form that users can fill out to join a certain group, we can then view that info from an admin page that requires logging in

[PHP-DB] Re: PHP/MySQL Help

2003-10-19 Thread conbud
Hey, Also the webhost only allows us a direct database connection using phpMyadmin, I did notice that on the table that stores the info, it keep getting an error after someone is posting the form. The error says something about Overhead: 275 bytes, Is this just an MySQL limitation that is set by th

Re: [PHP-DB] $_POST in MySQL query issue...

2003-10-19 Thread Adam Reiswig
A couple of days ago I placed a post regarding using the $_POST[] variable in an insert sql query. Both $sql="insert into $table set Name = '".$_POST['elementName']."'"; and $sql="insert into $table set Name = '{$_POST['elementName']}'"; worked perfectly. Thanks to everyone for your help. My

[PHP-DB] $_POST in MySQL query issue...

2003-10-19 Thread Adam Reiswig
A couple of days ago I placed a post regarding using the $_POST[] variable in an insert sql query. Both $sql="insert into $table set Name = '".$_POST['elementName']."'"; and $sql="insert into $table set Name = '{$_POST['elementName']}'"; worked perfectly. Thanks to everyone for your help. My q

Re: [PHP-DB] $_POST in MySQL query issue...

2003-10-19 Thread John W. Holmes
Adam Reiswig wrote: My question now is regarding the curly brackets in the 2nd example. Can anyone describe why using the curly brackets works and/or how php processes them. I have read quite a bit about php and never come accross thier use in this way. Thanks again. http://us2.php.net/manual/e

Re: [PHP-DB] $_POST in MySQL query issue...

2003-10-19 Thread Lee Doolan
> "Adam" == Adam Reiswig <[EMAIL PROTECTED]> writes: Adam> A couple of days ago I placed a post regarding using the Adam> $_POST[] variable in an insert sql query. Both Adam> $sql="insert into $table set Name = Adam> '".$_POST['elementName']."'"; and $sql="insert into $table

Re: [PHP-DB] PostgreSQL, Triggers

2003-10-19 Thread Martin Marques
El Dom 19 Oct 2003 13:54, Ling escribió: > Hello there. > Can anybody help me with Postgresql triggers? > what I need is a trigger which inrements value in field "total_rows.rows" > if I insert new row in table "zzz"... > > CAREATE TABLE zzz ( > ... > ... > ); > CREATE TABLE total_rows ( >

Re: [PHP-DB] Variables not working within Functions

2003-10-19 Thread Colin Kettenacker
Or pass the variable $username as an argument into your function: function LoginSystem($username) { // your function code } LoginSystem($username); ck -- Cheap Domain Registration | Web Hosting | Email Packages | + more Fantastic prices -- Even better service. http://www.hosttohost.net Chris

[PHP-DB] WHERE statement used multiple times.

2003-10-19 Thread JeRRy
> Hi, > > If I was to want to use the WHERE statement multiple > times (more than once) how do I seperate each WHERE > statement? > > Would it be with a ',' (coma) or a ' ' (space) or > what? Or not possible to have multiple WHERE's in > the > one query? > > I need 2 tables checked before exe

Re: [PHP-DB] WHERE statement used multiple times.

2003-10-19 Thread Chris Wanstrath
On Mon, 2003-10-20 at 00:56, JeRRy wrote: > > Hi, > > > > If I was to want to use the WHERE statement multiple > > times (more than once) how do I seperate each WHERE > > statement? > > > > Would it be with a ',' (coma) or a ' ' (space) or > > what? Or not possible to have multiple WHERE's in >

[PHP-DB] second time: problem with LDAP support

2003-10-19 Thread zxx10
Sorry for resending the same question. Actually, I sent the following message a few days before. However, it seems that no one has the experience on LDAP. It's a headache for me. Hope this time some experts can take a look at the question. I appreciate your kind helps! ***

Re: [PHP-DB] ORA-01704: string literal too long AND PHP/PEAR

2003-10-19 Thread Christopher Jones
Roger Spears wrote: I'm using PHP/PEAR to execute my queries on an oracle table. I'm trying to store very long pieces of text into a CLOB field. Currently I'm getting a string too long error. I've tried: OCIBindByName($sql,":fieldName",&$myVariable, -1); But I'm not sure I'm using it correct