[PHP-DB] multi row handle

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

Re: [PHP-DB] old news SQL help needed

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,

[PHP-DB] Windows DLL extension for DB2 needed

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

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

[PHP-DB] Looking for a PHP/MySQL Developer for short project

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.

Re: [PHP-DB] PHP vs. 2 database softwares

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

RE: [PHP-DB] PHP vs. 2 database softwares

-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

RE: [PHP-DB] PHP vs. 2 database softwares

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:

[PHP-DB] Re: PHP vs. 2 database softwares

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

Re: [PHP-DB] PHP vs. 2 database softwares

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

[PHP-DB] MSSQL error codes :/

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

Re: [PHP-DB] problem with WHILE loop

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) {

[PHP-DB] Driver for connecting SQL server

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

RE: [PHP-DB] problem with WHILE loop

$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

Re: [PHP-DB] Driver for connecting SQL server

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

RE: [PHP-DB] MSSQL error codes :/

-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

[PHP-DB] PHP and MS Access

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

RE: [PHP-DB] PHP and MS Access

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

[PHP-DB] Trouble retrieving DATETIME info from MSSQL

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

[PHP-DB] Re: PHP vs. 2 database softwares

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.

RE: [PHP-DB] Re: PHP vs. 2 database softwares

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:

[PHP-DB] Re: PHP vs. 2 database softwares

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

[PHP-DB] DB2 Performance issue

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

[PHP-DB] How to do a dynamic UPDATE SET

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);

[PHP-DB] navigation...

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

[PHP-DB] templates page

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

[PHP-DB] Update Query?

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

[PHP-DB] select data from more database

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

[PHP-DB] Newbie But Urgent

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

RE: [PHP-DB] Newbie But Urgent

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

RE: [PHP-DB] Newbie But Urgent

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: