Dear,
I would like to make a program which can display data in multi row to
maintain it with update value, delete row or add new row. How could I
handle multi row of data record in web page?
SF
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
Try this instead:
Delete league_news FROM leagues
where news_date + interval 7 day = now();
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: Larry Linthicum [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday,
Does anyone have a dll extension to enable access to DB2 from PHP 4? I don't
have access to a Windows compiler.
TIA
Mark
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
Hi!
I found that PHP can be compiled and work with only one database
software. You won't be able to have PHP to work with 2 seperate database
softwares. (You can compile it but it will work only with one databse
software, not both, no matter what). I checked the php ./configure file
and
Folks,
I am relatively new to PHP MySQL. I took on a side project some months
ago which I now realize is over my head. The project is a real estate
catalog. I adapted the catalog system from Welling and Thomson's PHP
MySQL Web Development from SAMS.
I really need to wrap this project up.
Do you meant to say that it took me several days to figure out that PHP
doesn't support multiple databases? PHP said it will work with almost any
databases but it failed to meant to say that only with one databases, but
not multiple databases at the same time.
Scott
Andrew Hill [EMAIL
-Original Message-
From: Scott Fletcher [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 11:11 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP vs. 2 database softwares
I found that PHP can be compiled and work with only one
database software. You won't be able to have
Scott,
I didn't know that you couldn't use multiple database protocols at once, and
this does surprise me to.
ODBC is a way around this problem, however, abstracting the protocol for
you.
Cheers,
Andrew
-Original Message-
From: Scott Fletcher [mailto:[EMAIL PROTECTED]]
Sent:
I have connected simultaneously to interbase, mysql, postgresql, oracle,
mssql, microsoft access, foxpro in one script.
You just configure PHP to be compiled with multiple database options.
Simple.
- John
Scott Fletcher [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
On Mon, 1 Oct 2001, Scott Fletcher wrote:
Date: Mon, 1 Oct 2001 12:11:12 -0400
From: Scott Fletcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP vs. 2 database softwares
Hi!
I found that PHP can be compiled and work with only one database
software. You won't be
I'm getting funky error codes, even with doing addslashes($variable); but its not
escaping the 's, I have even resorted to str_replace() and still nothing
below is error output.
Warning: MS SQL message: Line 1: Incorrect syntax near 'b'. (severity 15) in
\jtron\home\admin\functions.php on
Thanks to everyone who replied either here or via e-mail... I got a lot of
great suggestions. I ended up solving the WHILE problem by changing this:
$list = mysql_query(select id,title from table1);
$list_row = mysql_fetch_array($list);
$title = $list_row[title];
while($list_row) {
Hi:
I'm trying to establish a connection with SQL 7.0.
My system runs W2000, Apache, PHP4. I created a DNS odbc file (with MS
Access) and checked that the connection can be established.
Then, my php script is as follow:
$conn=odbc_connect(DNS=dnsname,userid,password);
When I execute the
$list = mysql_query(select id,title from table1);
while ($row = mysql_fetch_array($list)) {
echo($row[title]br\n);
}
-Original Message-
From: Eric J Schwinder
[mailto:[EMAIL PROTECTED]]
Sent: den 1 oktober 2001 20:18
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] problem with WHILE
Hi
Try to remobe 'DNS=' from the connect
$conn=odbc_connect(dnsname,userid,password);
should do the trick.
- Frank
Hi:
I'm trying to establish a connection with SQL 7.0.
My system runs W2000, Apache, PHP4. I created a DNS odbc file (with MS
Access) and checked that the connection
-Original Message-
From: Charles Butler [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 12:56 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MSSQL error codes :/
I'm getting funky error codes, even with doing
addslashes($variable); but its not escaping the
's, I have
I apologize if this is a redundant post. I did do a search and could not
find the answer.
I'm swimming in ignorance as I build a website for a friend. The hosting
service says they support MS Access and PHP. However, they are telling me
that in order for PHP to get to that database, I would also
On Windows, PHP can access Access via ODBC.
On Linux, PHP can also hit a Windows Access server via ODBC, but a two-tier
connection is needed whereby a Linux DSN talks to a Windows DSN.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Hello,
I am having trouble getting data from a DATETIME field in MSSQL 7.0.
The data in a general select query look like this:
2001-09-25 14:23:17.000
I can do this in MSSQL:
select * from INTERNETLOG where Datetime like %2001%
but not this:
select * from INTERNETLOG where Datetime like
Well, I did that. I typed in
./configure --with-iodbc=/usr/local/odbcsdk --with-ibm-db2=/usr/lp/db2_06_0
1 and it can compile without a problem. However, I checked the result of
the configure and it didn't display the iodbc for some reason. So, that's
why the iodbc was not compiled with PHP.
When i was switching back and forth between those 2 environments, I had to
remove the config.cache file before doing a 'configure' in order to make it
compile correctly.
-Original Message-
From: Scott Fletcher [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 1:50 PM
To:
Hi Ya All! I tried every option and it doesn't seem to work. So, for now,
I'm going to stick with the iodbc and download the driver to get the iODBC
to work with DB2 as well. Don't want to spend a lot of time on it right
now. It's been a few days already.
Thanks,
Scott
P.S. Maybe someone
This was posted on the newsgroup a couple of months ago:
Christian Szardenings wrote:
Hi Andrew,
thanks a lot for your help. Today we discovered what
our real problem was:
After playing a little bit with the php-scripts that try
to connect to the IBM DB2, we set the optional
I'm having a REALLY hard time with something that's probably easy to do (for
someone :-)...
Normally, to perform an update on a table with data from a submitted form, I
would use something like:
$sql = UPDATE $table SET pet='$pet', name='$name' WHERE id=$id;
$result = mysql_query($sql);
I'm trying to solve a problem... I have a site divided in areas. Each
area has it's own id, and may have it's own sub-areas. Each sub-area has
it's own sub-areas, etc...
My will is to return the areas in some cascade order... I can do it
recursively, but it generates too many queries. I
I have been working with PHP for a little bit, but still consider myself a
newbie. I am trying to redesign one of your sites with a templatized setup,
so that images and whatnot are loaded pretty much once, and I can quickly
keep the look and fee of the site.
Im working with tables only pretty
Hello-
I'm trying to run an update query in an application I'm making. I keep
getting a MySQL error however when I try and print out the mysql_error()
nothing is returned. I run the same query in phpMyAdmin and the query runs
fine. Below is the update query I'm running and the php code that
Hi,
I have data on more than 1 database with same schema. How could I use SQL
statement in PHP code to retrieve it for display in 1 time?
thanks
SF
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
HELLO,
I am finished working with the html and css levels and want to take my
design to the next level. I realize that JS is getting outdated and many new
technologies have started popping up. I do want a database driven site. I am
running Windows and have both the 98 and 2000 versions. There's
ASP list members will tell you ASP is better/easier for this, PHP list
members will tell you PHP is better/easier for this.
You're asking a pretty loaded question...
I, personally, believe that PHP is much better/easier, but I learned PHP
coming from a C/C++ background.. If you have done
My bad... I just realized this -WAS- posted to the PHP-DB list, and not
PHP-General...
So yes... These people are ninjas at solving database problems with PHP.
I have yet to post a request for help to them, but just following the
list is quite educational.
-Original Message-
From:
31 matches
Mail list logo