[PHP-DB] odbc and ibm-db2

2001-03-23 Thread Sergio Rua
Hello, I'm trying to use php with ibm-db2 but I obtain this error: bWarning/b: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in blogin.php/b on line b11/bbr This is my code:

RE: [PHP-DB] RE: [PHP] Printing MySQL into HTML Tables

2001-03-23 Thread Michael Rudel
Or try this one, its simple but more universal and very usefull for eg. testing. ... and a bit mor structured 8)=) ?php function result_all( $sql_result ) { echo "TABLE\n"; $columns = mysql_num_fields( $sql_result ); for ( $i = 0; $i $columns; $i++ )

[PHP-DB] PHP Mail - Webmail ??

2001-03-23 Thread Xsarus Internetdiensten
Huy, how to build mails in PHP with txt-mails AND HTML-mails AND visible in Webmail (like Hotmail, USANet) With the class below I can only make HTML-mails readable in Outlook etc. Why are the mails not shown in USANet? Daniel Kieviet Xsarus Internetservices Holland [EMAIL PROTECTED]

RE: [PHP-DB] odbc and ibm-db2

2001-03-23 Thread Andrew Hill
Sergio, The error indicates PHP cannot find your odbc.ini file that contains your DSNs. Try passing its location in: putenv("path/to/your/pesky/odbc.ini"); HTH Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness

[PHP-DB] SAP R3

2001-03-23 Thread Robert Sedlacek
Hi does anyone has Information about using a SAP R3 Database with PHP4? thx Robert -- C o d i t o , e r g o s u m ! I code, therefore I am! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

[PHP-DB] Interbase/Apache/Linux

2001-03-23 Thread Todd Cary
I have Interbase working on my client's WIN 2K platform with IIS as well as on mine; however, I do not have any experience with Linux/Apache (other than Apache running in DOS on my notebook for "on-the-road" programming). The client would now like to move over to a more stable environment:

[PHP-DB] delete registers..

2001-03-23 Thread Romeo Manzur
How could I automatly delete registers from a table that have a month old??? -- -- Romeo Manzur Web Application Developer iSilicom Av. 27 de Febrero 904-A Desp 1, Centro C.P.:86000 Villahermosa, Tabasco, Mexico Tel.:(52)(9)3-12-4790

[PHP-DB] diferent user passwords

2001-03-23 Thread Romeo Manzur
how could I configure diferent user password to each database on my server??? -- -- Romeo Manzur Web Application Developer iSilicom Av. 27 de Febrero 904-A Desp 1, Centro C.P.:86000 Villahermosa, Tabasco, Mexico Tel.:(52)(9)3-12-4790

RE: [PHP-DB] delete registers..

2001-03-23 Thread Cal Evans
Depends on what registers are. If they are people then I would just shoot then and get it over with. :) Seriously, if you mean how do you delete records form a table that are more than a month old (let's say 30 days to make it simply) then you need to have a timestamp field in your table. Then

Re: [PHP-DB] comparison table script

2001-03-23 Thread olinux o
You can get an idea here of what I would like to do http://www.bestbuy.com/ComputersPeripherals/DrivesStorage/CDRW.asp?m=488cat=511scat=514 So all information is displayed side by side, most of the time used to help decide between 2 or 3 products [bestbuy limits 10 selections in their

RE: [PHP-DB] diferent user passwords

2001-03-23 Thread Brunner, Daniel
Hello... What you can do is create different users tables within the Database... Then write a script that checks the username and passwords for each Database, during login. Like do a SELECT username FROM usertable if (!username) then echo .. Or stick with one user and

Re: [PHP-DB] Going bonkers again ...

2001-03-23 Thread olinux
You have to escape your "" $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id = '$m_id'"; try this $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id = \"$m_id\" "; - Original Message - From: "Martin Skjldebrand" [EMAIL PROTECTED] To:

[PHP-DB] Line Breaks

2001-03-23 Thread Shope, Glenn
Still haven't figured it out... I have read several entries about preserving line breaks when displaying text from a mySQL database, but I have had no success. How would I prevent data in a single field containing line breaks from being displayed in HTML as a single line? For example: A

[PHP-DB] Persistant Postgres Connections on the PSQL server?

2001-03-23 Thread Stan Brinkerhoff
I am running a webserver on machine A, and a postgres server on machine B. Reading the docs for PG_CLOSE it appears that a PG_CLOSE is not required, however our postgres box has the following: [sbrinker@samco sbrinker]$ ps aux | grep postgres postgres 6347 0.0 0.0 16920 ?SW

Re: [PHP-DB] Going bonkers again ...

2001-03-23 Thread Martin Skjöldebrand
olinux wrote: You have to escape your "" $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id = '$m_id'"; try this $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id = \"$m_id\" "; No that isn't the problem. It is valid to change quotation

RE: [PHP-DB] Line Breaks

2001-03-23 Thread Matt Williams
nl2br() -Original Message- From: Shope, Glenn [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 20:49 To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Line Breaks Still haven't figured it out... I have read several entries about preserving line breaks when displaying text from a

RE: [PHP-DB] Line Breaks

2001-03-23 Thread Shope, Glenn
Thanks, I have finally figured out the syntax for nl2br(), which doesn't seem very clear in the manual. I used: $data = nl2br($data); That returns just what I expect. However, now I have to get rid of the all the BRs that I have inserted into my data while I was trying to figure this out.

Re: [PHP-DB] How to sort numerically ?

2001-03-23 Thread Terry Romine
"select data_name,data_number from myTable order data_number DESC" The "DESC" is descending. HTH Terry On Friday, March 23, 2001, at 03:02 PM, Sunil Jagarlamudi wrote: I am trying to read a file which has two columns with names and numbers and I am trying to sort them numerically, with

Re: [PHP-DB] Going bonkers again ...

2001-03-23 Thread JJeffman
A good advice is put an error checker after every mysql command, this way you can track errors : ?php file://view jobs script include("../includes/connect.inc.php"); file://connect to the database $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id = '$m_id'";

Re: [PHP-DB] PHP Mail - Webmail ??

2001-03-23 Thread JJeffman
I don't know if you need a special class to send an email, the php mail function do this in a way you can read it on every browser or email program . HTH Jayme. -Mensagem Original- De: Xsarus Internetdiensten [EMAIL PROTECTED] Para: [EMAIL PROTECTED] Enviada em: sexta-feira, 23 de maro

Re: [PHP-DB] RE: [PHP] Printing MySQL into HTML Tables

2001-03-23 Thread JJeffman
Congratulations !! Very good solution ! Simple and efficient ! Cheers, Jayme. -Mensagem Original- De: Michael Rudel [EMAIL PROTECTED] Para: [EMAIL PROTECTED]; 'PHP-DB mailinglist' [EMAIL PROTECTED]; [EMAIL PROTECTED] Enviada em: sexta-feira, 23 de maro de 2001 08:29 Assunto: RE:

[PHP-DB] PHP, Flash, and MySQL.

2001-03-23 Thread Shane Aldrich
Hi. Does anyone currently work with PHP, Flash 5, and MySQL together? -- Shane Aldrich Graphic Insight 3014 N. Hayden Road Suite 114 Scottsdale, AZ 85251 480.423.3524 FAX 480.423.1987 www.graphic-insight.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] comparison table script

2001-03-23 Thread olinux
Cool! Just came across this, looks like PHP will make life simple. http://www.php.net/manual/en/function.array-flip.php Array_flip() returns an array in flip order. Example 1. Array_flip() example $trans = array_flip ($trans); $original = strtr ($str, $trans); example: $a[0]="abc";

[PHP-DB] PHP/MySQL Program

2001-03-23 Thread Angela Curtis
I have a client who would like to make some simple database-driven pages using PHP and MySQL, but he doesn't know how to use either. He asked me if there was a program that he could use to create pages that would be easier than having to learn both PHP and MySQL. I've always done everything

[PHP-DB] PHP Licencing vs Zend Licencing

2001-03-23 Thread Jason Cathcart
Just out of curiousity, say if I was to develop an e-commerce site for a client and the scripts used to execute it were written in PHP, under what circumstances, if any, am I required to pay for Zend Licencing? In other words, if I set up the client's entire server; Apache, PHP... the whole

Re: [PHP-DB] cflocation in PHP

2001-03-23 Thread codemax
Use this function: header("Location: another_script.php"); codemax. ""Miles Scruggs"" [EMAIL PROTECTED] wrote in message 000601c0b097$f72e70a0$0232000a@engr">news:000601c0b097$f72e70a0$0232000a@engr... Is there a way to jump out of one script and into another like with cflocation() in CF.

[PHP-DB] connection id

2001-03-23 Thread andrie
Hello php mania, i was connecting into mysql using mysql_connect, and i just saved the return value from this funtion. now i want to use this connection id in the other page so i dont have to connect into mysql again. is it possible for me to do that ? anybody could tell me the