[PHP-DB] Re: NEXTVAL(serial)

2001-09-27 Thread Steve Brett
nextval is a function found in postgres databases and is used to seed the value of a serial(auto increment) that is normally used as a key. other uses are select currval(serial) to get the current value and select setval(serial,value) to set the vlaue on the fly. much more info can be found in t

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

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 serve

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

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

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 w

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 PROTECTE

[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() . "MySQL Error String: " . mysql_error() . "Query: " . $sql_q

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 o

[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: dbase_open(

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

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 .= "array(\"".$row['TextVal

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 die(mysql

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

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

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

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

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 sendi