RE: [PHP-DB] imap problem

2001-06-21 Thread Tom Hodder
Hi, It's likely that you need to enable imap support, if you are using win32 this is relatively simple, all you have to do is get the dll from the php website and uncomment the lines from the extensions section of the php.ini file. If you are using unix, then you have to recompile php with the

[PHP-DB] concatenation

2001-06-21 Thread DanielW
Greetings. Can anyone tell me how to concatenate text to the value of a cell pulled out of a table in a while loop? I'm trying to add mailto:; to an email address value. Thanks, Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] Date field

2001-06-21 Thread Dobromir Velev
Hi, it depends on the the MySQL date type you are using. Here are the formats for the different types. DATE - '-MM-DD' DATETIME - '-MM-DD HH:MM:SS' TIMESTAMP(14) - MMDDHHMMSS TIMESTAMP(12) - YYMMDDHHMMSS TIMESTAMP(8) -MMDD TIMESTAMP(6) -YYMMDD

Re: [PHP-DB] flush privileges

2001-06-21 Thread Russ Michell
what kind of privileges i should have if i want to run 'flush privileges' ? You need to be the MySQL superuser, this is the user who has permission to grant privileges to other users and set them up as such. You use 'flush privileges' when you want to instruct MySQL to 'refresh' it's

Re: [PHP-DB] Date field

2001-06-21 Thread Russ Michell
Hi, Can someone tell me how do stote date field in MySQL DB ? This is the dump from my phpMyAdmin: use this SQL from the command line and adapt it for your own needs: # Table structure for table 'item' # CREATE TABLE item ( id smallint(4) DEFAULT '0' NOT NULL auto_increment, name

RE: [PHP-DB] concatenation

2001-06-21 Thread Beau Lebens
$mailto_link = mailto:; . $result[email_address]; // -Original Message- // From: DanielW [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 21 June 2001 1:06 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] concatenation // // // Greetings. // // Can anyone tell me how to concatenate

Re: [PHP-DB] concatenation

2001-06-21 Thread Russ Michell
U I might be missing something but isn't it something like: $emailVal = a href=\mailto:; . $email . \ . $email . /a; HTH :-) Russ On Thu, 21 Jun 2001 00:05:46 -0500 DanielW [EMAIL PROTECTED] wrote: Greetings. Can anyone tell me how to concatenate text to the value of a cell pulled

[PHP-DB] How do I backup my MySQL database? asks a Newbie.

2001-06-21 Thread Dan Eskildsen
*** NEWBIE ALERT! *** I am only new at this, but I have discovered one thing: I love php and mysql! I now have a couple of tables of information in a MySQL database. The site is run by my ISP so I don't have control of the server. My question is: how do I via

[PHP-DB] Interbase blob

2001-06-21 Thread Enrico Comini
I have many problem to view image stored like blob in interbase6. Is impossible. I Use ibase_blob_echo(). my php is 4.0.5

Re: [PHP-DB] Informix question

2001-06-21 Thread Christian Haul
Bård Farstad [EMAIL PROTECTED] wrote: Hi all, I'm writing an application which uses the PHP interface to informix. I'm having trouble with newlines in char/varchar or lvarchar fields. How can I store newlines (\n) to an informix database without using blobs? You need to escape newlines or

Re: [PHP-DB] Informix Question how to put data from query into variables

2001-06-21 Thread Christian Haul
wflow [EMAIL PROTECTED] wrote: Hi All, What I want to do is create another query from some of the data from another one. The question is how do I take the data I get back from my first query and put that into variables so I can build my second query. The example I have in mind is: I a do

[PHP-DB] passing db persistent connections through different pages

2001-06-21 Thread boltthrower
hello, I've this silly question: how can I pass a db persistent connection from a script to another? (it seems there's no way: but what's the use then of them?) eg, I tryed this 2 scripts (with Oracle 8.1.6) ?php set_time_limit(0); $conn = ociplogon('user','pass','testdb'); echo Server

RE: [PHP-DB] imap problem

2001-06-21 Thread Thomas
Did you compile php with the --with-imap option ? Because generally, this type of message happens when the function is not installed. - Mensaje original - De: vipin chandran [EMAIL PROTECTED] Para: [EMAIL PROTECTED] Enviado: mercredi 20 juin 2001 14:54 Asunto: [PHP-DB] imap problem

[PHP-DB] raw file header in http

2001-06-21 Thread [EMAIL PROTECTED]
I' ve a file in a directory(/tmp) out from http root of web server. I need to open a page that send this file when it is opened (es.: opening page.php under netscape it opens a request to save file to disk, but the file is out of www root), i think i t is possible using command header and a raw

RE: [PHP-DB] How do I backup my MySQL database? asks a Newbie.

2001-06-21 Thread Steve Brett
get mysql front, install it and then choose export tables to file. i've found mysql-front to be a really good tool for adminisrating mysql dbs Steve -Original Message- From: Dan Eskildsen [mailto:[EMAIL PROTECTED]] Sent: 21 June 2001 10:15 To: [EMAIL PROTECTED] Subject: [PHP-DB]

Re: [PHP-DB] mysql client compression with php?

2001-06-21 Thread Shriram Chaubal \(Personal\)
Is there anyone who can help with this? Or is there a paid support option I could use to help resolve this issue? Regards, Shriram Shriram Chaubal (Personal) [EMAIL PROTECTED] wrote in message 9gntu2$ng8$[EMAIL PROTECTED]">news:9gntu2$ng8$[EMAIL PROTECTED]... Hi, I have to connect my php

[PHP-DB] Connecting to MySQL

2001-06-21 Thread Keith Whyman
Can anyone help with this problem ! user name should just be keith but the @localhost gets added and then I can't connect ??? Warning: MySQL Connection Failed: Access denied for user: 'keith@localhost' (Using password: YES) in /usr/var/www/www.happy.de/html/cms/test.php on line 23 Problem

Re: [PHP-DB] How do I backup my MySQL database? asks a Newbie.

2001-06-21 Thread Andre P.
Install phpMyAdmin and this will give you a web interface to manage your DB. You can do a dump of your database using it. Andre Dan Eskildsen wrote: *** NEWBIE ALERT! *** I am only new at this, but I have discovered one thing: I love php and mysql! I now have a

Re: [PHP-DB] raw file header in http

2001-06-21 Thread Dobromir Velev
Hi, I think you could use something like this $file_name=/tmp/your_file_name; Header ( Content-Type: application/octet-stream); Header ( Content-Length: .filesize($file_name)); Header( Content-Disposition: inline; filename=$file_name); readfile($file_name); If you want instead of using

[PHP-DB] Fatal error: Call to undefined function: mssql_connect()

2001-06-21 Thread Spiro Katerinis
Hello All. I'm trying to connect to MS SQL Database but I receive Fatal error: Call to undefined function: mssql_connect() error. Anyone know what could be causing this? I have configured the PHP.INI file in the System32 folder and placed all necessary .DLL's. I still get this error.

[PHP-DB] changing field size

2001-06-21 Thread Adv. Systems Design
hello *: I have initially set a field named title to be varchar(50)...I am finding that it is not long enough...can I change the size without adversely affecting existing data? Thanks Luis __ Do You Yahoo!? Get personalized email addresses from

[PHP-DB] 1 is not a valid PostgreSQL link resource

2001-06-21 Thread Carlos Estala
! Hi ¡ i have redhat 7.1 and php 4.0.4 but i have a problem with conections becose send me this messages 1 is not a valid PostgreSQL link resource, how i cant fix this problem someone friend say me that rebuild source code php 4.0.4 , is true o someone have a solution Thanks ::: -- PHP

RE: [PHP-DB] Connecting to MySQL

2001-06-21 Thread Jonathan Hilgeman
Sounds like either: 1) You don't have your correct username/password info in the mySQL/user table or 2) Your server is bound to an IP address or something (a frequent problem on Win machines, but it looks like you're using Linux or something) The localhost part isn't really the username that is

Re: [PHP-DB] raw file header in http

2001-06-21 Thread Andre P.
Try the following: create a link to a script download.php which will read the file (from anywhere on the disk) and send it to the user like this: header(Content-Type: application/force-download); header(Content-Length: .filesize($filename)); header(Content-Disposition: attachment;

[PHP-DB] ORACLE JOB

2001-06-21 Thread Fernando Ferreras
I need to do a select or a insert based in a variable Something like this $select = SELECT * FROM TABLE1 and after i do the select above with is in the variable... All help is important... Thanks Fernando -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] Does PHP work with MSSQL 2000?

2001-06-21 Thread Chris Cowan
Does PHP work with MSSQL 2000? Chris Cowan -- 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 administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-21 Thread wflow
Chris, Thanks for the advice, of course I already did rtfm and the ifx_fetch_rows entry did not really help me. It, in fact does NOT return an enumerated array, as the top line of the page states. It ONLY returns an associative array. If there was an ifx_fetch_array like the one for MySQL, I

[PHP-DB] MySQL connection: Change on syntaxis?

2001-06-21 Thread Tomás García Ferrari
Hello, I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on lines like this: $rows = mysql_num_rows($result); and noticed that this is a solution: $rows = @mysql_num_rows($result); Is this a new use of the function mysql_num_rows? +--