[PHP-DB] PHP, MySQL and WML!

2001-01-25 Thread Kevin Connolly
Hi, I am trying to update a MySQL database using a PHP script embeded in a WML page. Here is my code: The following is register2.php: wml template do type='prev' label='Back' prev/ /do do type='accept' label='Accept' go

[PHP-DB] header-ache

2001-01-25 Thread Leo Kuiper
Ok I'm kinda new to this list so I'm very sorry for those who've heard this question a million times. How to get binary data (jpg file?) AND text from a database, BUT display it on the same page? I know the header-content-type blocks all this (either display text or jpg), but there must be some

Re: [PHP-DB] PHP, MySQL and WML!

2001-01-25 Thread Andrew Apold
INSERT INTO employees (first,last,address,position) VALUES ('$(first)','$(last)','$(address)','$(position)') is because in WML variables are stored as $(first) and not just $first like in HTHML. Somewhere between $sql = "INSERT INTO employees (first,last,address,position) VALUES

[PHP-DB] failure notice

2001-01-25 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. [EMAIL PROTECTED]: ezmlm-manage: fatal: message already has a Mailing-List header (maybe I should

[PHP-DB] failure notice

2001-01-25 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. [EMAIL PROTECTED]: ezmlm-manage: fatal: message already has a Mailing-List header (maybe I should

[PHP-DB] failure notice

2001-01-25 Thread Mike
Hi. This is the qmail-send program at toye.php.net. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. [EMAIL PROTECTED]: ezmlm responseezmlm-send: fatal: message already has a Mailing-List header

[PHP-DB] Call to undefined function: pg_connect(

2001-01-25 Thread Sean Weissensee
After I had to rebuild my linux server I started getting this error while trying to connect to postgres. This worked fine before, I first installed the stock RPM`s i.e PHP and postgres from the Redhat 6.2 Distribution. After getting this error I thought now is a good opportunity to upgrade to

Re: [PHP-DB] header-ache

2001-01-25 Thread php3
Addressed to: "Leo Kuiper" [EMAIL PROTECTED] [EMAIL PROTECTED] ** Reply to note from "Leo Kuiper" [EMAIL PROTECTED] Thu, 25 Jan 2001 13:06:53 +0100 Ok I'm kinda new to this list so I'm very sorry for those who've heard this question a million times. How to get binary data

[PHP-DB] Problems with character sets

2001-01-25 Thread magor
Hello everybody, I have problems concerning character sets.I use InterBase database. I have data in columns with character set NONE, but the data is in fact in win1250 coding. I have other columns with character set WIN1250. I want to from these NONE columns to these WIN1250 columns, but

[PHP-DB] MEMO field in ACCESS

2001-01-25 Thread Monika Jurczak
I've got an Access dbase and one of the field is memo. Before showing on web side, I want to convert the memo field from Windows-1250 codding to ISO-8859-2. With text fields I do it with below script, but with memo it doesn't work SCRIPT language="VBSCRIPT" RUNAT="SERVER" const WIN = "" const

Re: [PHP-DB] failure notice

2001-01-25 Thread JJeffman
The last time I sent a message to php-list-admin asking for stop this kind of messages they took the email address off but I was fired of the list too. Jayme. http://www.conex.com.br/jjeffman -Mensagem Original- De: Jon Niola [EMAIL PROTECTED] Para: [EMAIL PROTECTED]; [EMAIL

[PHP-DB] Limit number of persistent oci8-connections?

2001-01-25 Thread Karsten Dambekalns
Hi! I am using PHP to connect to an Oracle 8.1.5 database. Everything works fine, but the load on the oracle server is insanely high. So I would like to limit the number of connections. Is there something like the mysql max_persistent_connections statement? TIA, Karsten BTW: Has some used

AW: [PHP-DB] Limit number of persistent oci8-connections?

2001-01-25 Thread Matthias Kopolt
Are you useing persistent connections (I had no real luck with them)? How do you connect to your DB over Multi Threaded Server (MTS) or Dedicated Server ? I think Oracles NET8 Config has a Parameter to limit this. Check out the MasterIndex at

[PHP-DB] Help with loop

2001-01-25 Thread Robert
Why does this spit out the same part over and over until it times out? I have 2 tables in the same database 1: bruindba ---Parts database specific_p Part Number manufactur ---Manufacturer package ---Package in 2: ecomm

Re: [PHP-DB] Limit number of persistent oci8-connections?

2001-01-25 Thread Karsten Dambekalns
On Thu, Jan 25, 2001 at 08:22:07PM +0100, Matthias Kopolt wrote: Are you useing persistent connections (I had no real luck with them)? How do you connect to your DB over Multi Threaded Server (MTS) or Dedicated Server ? I am just using phplib for the dirty stuff :) So I don't know exactly

RE: [PHP-DB] Help with loop

2001-01-25 Thread Mark Newnham
$res = mysql_query("SELECT * FROM ecomm where ID ='$sid'",$db)) if(!$res){echo("error preforming query: " . mysql_error());exit();} //error trap while( $row=mysql_fetch_array($res)){ $pno=$row["part"]; # Mark Newnham Application

[PHP-DB] query error

2001-01-25 Thread Randy Johnson
When I run any kind of query this is the value of result Resource id #2 Example $result= mysql_query (" Select * from ACCT_TBL ") or die ("Error".mysql_error()); print result; any ideas? randy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Limit number of persistent oci8-connections?

2001-01-25 Thread George Schlossnagle
MaxClients inyour httpd.conf is a nice way to limit it. :) Karsten Dambekalns wrote: On Thu, Jan 25, 2001 at 08:22:07PM +0100, Matthias Kopolt wrote: Are you useing persistent connections (I had no real luck with them)? How do you connect to your DB over Multi Threaded Server (MTS) or

Re: [PHP-DB] Help with loop

2001-01-25 Thread Robert
Thanks a million, works great now. - Original Message - From: "Mark Newnham" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 1:41 PM Subject: RE: [PHP-DB] Help with loop $res = mysql_query("SELECT * FROM ecomm where ID ='$sid'",$db))

RE: [PHP-DB] query error

2001-01-25 Thread Mark Newnham
Looks fine, now retrieve the rows from the query. -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 12:46 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] query error When I run any kind of query this is the value of result

[PHP-DB] insert into mysql

2001-01-25 Thread Robert
//--- Add part -- if($act=="ADD"){ $sql="INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp'),$db"; if(! @mysql_db_query("$sql")){echo("Unable to add part.");mysql_close($db);exit();} } Why does this not work?

[PHP-DB] Problem with query!

2001-01-25 Thread Adrian Pitulac
Hi. I have a problem with a mysql query! after the query the result variable is "resource id 2" what is wrong! Thanks!

Re: [PHP-DB] Problem with query!

2001-01-25 Thread Mage
Hello! I have a problem with a mysql query! after the query the result variable is "resource id 2" what is wrong! Nothing. Read the manual, even the mysq_fetch_array($result) function. Mage -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

RE: [PHP-DB] insert into mysql

2001-01-25 Thread Dave Fudge
try this: $db = mysql_connect(host,uid,pwd); if($act=="ADD"){ $sql="INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')"; $res = mysql_db_query($dbname,$sql,$db); if(!$res){ echo("Unable to add part."); mysql_close($db); exit(); } } you didn't specify $dbname -Original

Re: [PHP-DB] insert into mysql

2001-01-25 Thread Darryl Friesen
It still didn't work. just says unable to add part Remove the @ from @mysql_db_query and it will spit out the SQL error explaining why the query fails. That should help for debugging. - Darryl -- Darryl Friesen,

Re: [PHP-DB] insert into mysql

2001-01-25 Thread Darryl Friesen
It still didn't work. just says unable to add part $sql = "INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')"; Another thought: Are ID and part character data of some sort? If not (i.e. if ID is an int) then remove the single quotes. - Darryl

Re: [PHP-DB] insert into mysql

2001-01-25 Thread Robert
They are both set as text they store numbers and letters from this link ( it's my local development machine ) http://tech2000/rfq.php?spp=MC68020RC12Epkg=PGAmfc=MOTact=ADDsid=583607b a7b565b6d699da58d7c7fe9ab - Original Message - From: "Darryl Friesen" [EMAIL PROTECTED] To: "Robert"

[PHP-DB] insert into mysql

2001-01-25 Thread Robert
Warning: Supplied argument is not a valid MySQL-Link resource in c:\inetpub\wwwroot\rfq.php on line 16 Unable to add part //--- Add part -- if($act=="ADD"){ $sql="INSERT INTO ecomm (ID,part) VALUES $sql.="('$sid','$spp')"; if(!

[PHP-DB] insert in mysql

2001-01-25 Thread Robert
ignore that last one :) I goofed... Still not working right though if($act=="ADD"){ $sql="INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')"; if(! mysql_query('$sql')){echo("Unable to add part.");mysql_close($db);exit();} } just gives me "Unable to add part"

[PHP-DB] insert in mysql

2001-01-25 Thread Robert
This link is passed to the shopping cart type script where I want to put the spp and the sid into the database. http://tech2000/rfq.php?spp=MC68020RC12Tpkg=PGAmfc=MOTact=ADDsid=583607ba7b565b6d699da58d7c7fe9ab script language='php' // Connect to Database