[PHP-DB] attach file

2001-09-27 Thread Sommai Fongnamthip
Hi, How I retrieve data from DB and make it to mail attachment? I've been read PHP function about mailto but It did not contain any suggestion. SF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [PHP-DB] mysql_fetch_array() doesn't work

2001-09-27 Thread Jason G.
echo a href='$PHP_SELF?offset=$i*$step' target='_top' Missing end quote and semicolon on this line may be the reason... Try properly indenting and formatting your code. Also take advantage of going in and out of php mode to seperate your code from your display of content... Ex: instead of

[PHP-DB] create data array

2001-09-27 Thread Sommai Fongnamthip
Hi, If I need to use data array like this $data_array = array ( array(text,1,2,3), array(text,4,5,6), array(text,7,8,9) ); all array element are contain in my database. How could I write PHP

Re: [PHP-DB] Can't connect Mysql using php

2001-09-27 Thread Jae
I already use ./configure--with-mysql. Is it need to install again? thx Lars B. Jensen [EMAIL PROTECTED] ¼¶¼g©ó¶l¥ó [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... you need to install your PHP using ./configure --with-mysql rather than ./configure --without-mysql / LJ -Original

RE: [PHP-DB] mail() - is there a limit?

2001-09-27 Thread Luke Muszkiewicz
olinux: I do not know the answer to your question. However, I would alternatively suggest that you send the email to each person individually. That is to say, loop through your recipient array and use mail() to send the message to each recipient, as opposed to creating a bcc array and then

RE: [PHP-DB] PHP and ms Access

2001-09-27 Thread olinux
www.phpbuilder.com has a few decent articles on this that will help you. olinux -Original Message- From: François PERROT [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:19 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP and ms Access Hi, You need

[PHP-DB] howto craete a stored procedure in DB2?

2001-09-27 Thread Thies C. Arntzen
hi, i'm working on OUT paramter support in the ODBC module when calling stored procedures. to start playing with it i need to create a stored procedure in DB2 (this is the db my customer is using). me -the stupid oracle guy- does not know how to load a stored procedure

[PHP-DB] MSSQL and BLOBs

2001-09-27 Thread gus
Hi! Does anybody get it working to extract/insert BLOBs from/into a MSSQL (7 or 2000) database with PHP4? What is the best way to do it? COM objects and ADO, mssql functions or ODBC functions? I tried it with the ODBC functions. It works but there's the 1MB limit and I need to access BLOBs with

[PHP-DB] php and Oracle database

2001-09-27 Thread GEORGINA ELAINE BAILEY
I am very new to PHP and databases and have not really had very much programming practice. However, I am trying to create a Web page that retrieves data from an Oracle database and uses php to display the content in a HTML format. For some reason though my script just doesn't seem to work,

Re: [PHP-DB] php and Oracle database

2001-09-27 Thread Anthony Carlos
Georgina: Based on your 2 enclosures, it appears that you have an html file called search1.html. When the user hits the submit button, it calls search1.php4. My question, therefore, is do you have output from search1.php4? Do you see any error messages? Thanks, Anthony Carlos From: GEORGINA

RE: [PHP-DB] mysql_fetch_array() doesn't work

2001-09-27 Thread Rick Emery
change coding to (note, each line is enclosed in quotes and ends withn .): $query=select user_id, user_name, time, status, comment from users. where sign=1. order by user_name. limit $offset, $step; print $query; //sanity check...contents of $query $res=mysql_query($query) or

RE: [PHP-DB] create data array

2001-09-27 Thread Rick Emery
the following assumes you've opened database. $query = SELECT TextVal,Val1,Val2,Val3 FROM mytable WHERE some_condition; $result = mysql_query($query) or die(mysql_error()); $mycmd = \$data_array = array (; while( $row = mysql_fetch_array($result) ) { $mycmd .=

[PHP-DB] Re: delete multiple entries from a database using PHP

2001-09-27 Thread David Tod Sigafoos
A little more info would be helpful .. Is this one table or multiple tables .. what are the columns and relationships .. DTSig David Tod Sigafoos On Wed, 26 Sep 2001 21:36:39 +0545, [EMAIL PROTECTED] wrote: how can I delete multiple entries from a database using PHP . I need to make a

[PHP-DB] Hellllp DBF

2001-09-27 Thread Marcelo Ramos Souza
I need HELP, I can´t open a DBF, I using this: $dbf = dbase_open('/public/dados/clientes.dbf',0); $drec = dbase_get_record_with_names($dbf,1); // ITEM must be in all caps, otherwise // you get nothing echo $drec['ITEM']; But result this error: Fatal error: Call to undefined function:

RE: [PHP-DB] Hellllp DBF

2001-09-27 Thread Rick Emery
sounds like database manipulation was not compiled into PHP when it was installed on your server. -Original Message- From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 8:25 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Hep DBF I need HELP, I can´t

[PHP-DB] Re: how do I update fields in a mysql database with php?

2001-09-27 Thread David Tod Sigafoos
Try something like this ... $sql_query = SELECT newscat_id,newscategory,newscat_status FROM dvd.news_categories WHERE newscat_id='$newsid' $res = mysql_query( $sql_query) or DIE (MySQL gave error: . mysql_errno() . brMySQL Error String: . mysql_error() . brQuery: .

RE: [PHP-DB] attach file

2001-09-27 Thread Rick Emery
Follow this link which describes how to create attachments for email: http://www.phpbuilder.com/columns/kartic2807.php3 Use these techniques after retrieving the data from the database to be formed into an attachment -Original Message- From: Sommai Fongnamthip [mailto:[EMAIL

Re: [PHP-DB] Hellllp DBF

2001-09-27 Thread Marcelo Ramos Souza
Who I do ? - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'Marcelo Ramos Souza' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 27, 2001 10:27 AM Subject: RE: [PHP-DB] Hep DBF sounds like database manipulation was not compiled into PHP when it was

RE: [PHP-DB] Hellllp DBF

2001-09-27 Thread Rick Emery
You need to talk to the server's owner to ask that PHP be installed with the database capabilities you need. Does your company own the server; if so, speak to the admin. If you are using web-hosting, talk to them. -Original Message- From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]]

[PHP-DB] (poss OT) mail() function

2001-09-27 Thread Dave Watkinson
hi all We have a web based employment site, running on PHP and MySQL (to all those didn't know!). Whenever a candidate sees a job they're interested in they click a button and an email is sent to our consultants for them to act on. The problem, little as it is, is that I've written a function

Re: [PHP-DB] Hellllp DBF

2001-09-27 Thread Marcelo Ramos Souza
Using PHP 4 installed and the phpdbase.dll disable. - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'Marcelo Ramos Souza' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 27, 2001 10:41 AM Subject: RE: [PHP-DB] Hep DBF You need to talk to the server's owner

RE: [PHP-DB] Hellllp DBF

2001-09-27 Thread Rick Emery
if phpdbase.dll is disabled, then you can't use dbase_open() -Original Message- From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 8:55 AM To: Rick Emery; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Hep DBF Using PHP 4 installed and the phpdbase.dll