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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
$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
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]
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
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))
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
//--- 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?
Hi.
I have a problem with a mysql query!
after the query the result variable is "resource id 2"
what is wrong!
Thanks!
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:
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
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
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"
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(!
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"
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
29 matches
Mail list logo