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: Ma

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 progr

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

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

[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 I'm

[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] 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] 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); A

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

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

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.

[PHP-DB] Re:[3] [PHP-DB] MSSQL error codes :/

Great sounds like a winner :) "Frank M. Kromann" <[EMAIL PROTECTED]> wrote on 10/1/2001 2:32:27 PM: > >Hi Charles, > >I useally disable all magic quotes in php.ini and handle everyting in my scripts. >This way I only get single quotes when I need them and I dont have to do a stripslashes() ! >

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

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

Also, ensure that this is a System DSN. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Frank M. Kromann [mailto:[EMAIL PROTECTED]] > Sent:

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 Univers

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

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

RE: [PHP-DB] problem with WHILE loop

$list = mysql_query("select id,title from table1"); while ($row = mysql_fetch_array($list)) { echo("$row[title]\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 WHIL

[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

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] 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 l

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

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

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: Mond

[PHP-DB] filtered searches

Hi all, I could use some advice, here is my problem: I need to run filtered searches on my database (mysql) and return records that fall within the bounds, not hard! I need to be able to select sporting stats of athletes (goals, assists, etc)in a table stats as well as their personal stats (hei

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

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 PROTE

[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

Scott, That is what ODBC is for. Compile --with-iodbc as per the howto at www.iodbc.org and you can use ODBC drivers for multiple database platforms at the same time. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access &

[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] Find a way around it.

Never mind the problem. I found that PHP won't use both the "--with-ibm-db2" option and "--with-iobc" option, it only can use one of them. So, I am creating 2 seperate apache with 2 seperate PHP and that will fix the problem. Unless PHP is willing to change the design to make it work with both

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

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, Se

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

RE: [PHP-DB] username/password db query

thanks for the help. with the suggestions, this is what finally resulted, i figured i'd post it in case it's help to any one else. http://www.some.com/badlogin.php";); } $db = pg_connect("dbname=some_com user=some_com"); $query = "SELECT * FROM userinfo WHERE firstname='$username'"; $authresult =