RE: [PHP-DB] Mail Function

2002-08-27 Thread Russ
Oops! wrong order of arguments... I meant: $mailTo = "[EMAIL PROTECTED]"; $mailFrom = "From:[EMAIL PROTECTED]"; $mailSubject = "This is an email..."; $mailBody = "This is a message"; @mail($mailTo,$mailSubject,$mailBody,$mailFrom); Russ -Original Message- From: Manoj Japher [mailto:[EM

RE: [PHP-DB] Mail Function

2002-08-27 Thread Russ
$mailTo = "[EMAIL PROTECTED]"; $mailFrom = "From:[EMAIL PROTECTED]"; $mailSubject = "This is an email..."; $mailBody = "This is a message"; @mail($mailTo,$mailFrom,$mailSubject,$mailBody); Try this, it works for me ;-) Russ -Original Message- From: Manoj Japher [mailto:[EMAIL PROTECTED]]

Re: [PHP-DB] connectivity problem

2002-08-27 Thread Cornelia Boenigk
Hi Brian > $sql_result=pg_exec($conn.$sql) or die ("Couldn't Execute Query."); should be $sql_result=pg_exec($conn,$sql) or die ("Couldn't Execute Query."); pg_exec($conn *comma not period* $sql)... Regards Conni -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] connectivity problem

2002-08-27 Thread Adam Williams
In your connect statement, you aren't selecting a password and TCP port to connect to. You made need to specify those. Adam On Tue, 27 Aug 2002, Brian Noecker wrote: > Hey everyone, got a problem here. I'm using php4.2.1, postgres 7.2. I'm > trying to do a simple data

Re: [PHP-DB] connectivity problem

2002-08-27 Thread Adam Williams
look at http://www.php.net/manual/en/function.pg-connect.php do you have postgresql starting with the -i paramater so that it is listening on a TCP port? PHP needs this to be able to connect to postgresql. Adam On Tue, 27 Aug 2002, Brian Noecker wrote: > Hey everyone,

[PHP-DB] connectivity problem

2002-08-27 Thread Brian Noecker
Hey everyone, got a problem here. I'm using php4.2.1, postgres 7.2. I'm trying to do a simple database connect with the following small php script: -- PHP Test http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] login won't work for Internet Explorer

2002-08-27 Thread Adam Williams
View the source in mozilla, it might just be suppressing the output for whatever reason. Adam On Wed, 28 Aug 2002 [EMAIL PROTECTED] wrote: > > > Hi there, > > I am experiencing a peculiar problem. I have recently moved a PHP / MySQL driven > website I have been developin

[PHP-DB] login won't work for Internet Explorer

2002-08-27 Thread Ben . Westgarth
Hi there, I am experiencing a peculiar problem. I have recently moved a PHP / MySQL driven website I have been developing from my linux box on to a live host. Everything seemed to go smoothly apart from one peculiar problem. When I access the site using Internet Explorer (so far I have tried 5.

Re: [PHP-DB] Create database

2002-08-27 Thread Adam Williams
The database was created successfully"; } else { echo "The database was not created ".mysql_error().""; } ?> If it still gives you the same error, try connecting to mysql from the console with mysql -u user -ppasswd Adam On Tue, 5 Aug 2003, Russell Griechen wrote: > New

[PHP-DB] Create database

2002-08-27 Thread Russell Griechen
Newbie here, With PhpMyAdmin, What is the syntax for create database? I have: $link = mysql_pconnect("hostname", "username", "password") or exit("Could not connect"); if (mysql_create_db("Sportsmen")) { print ("Database created successfully\n"); } else { printf (

RE: [PHP-DB] Mail Function

2002-08-27 Thread Ruprecht Helms
Hi Manoj Japher, add the following (see in context) > > $toaddress = "[EMAIL PROTECTED]"; ^ addslashes(...) > $fromaddress = "[EMAIL PROTECTED]"; ^ addslashes(...) >

Re: [PHP-DB] Connecting to FileMaker Server?

2002-08-27 Thread Paul Burney
on 8/27/02 1:31 PM, Andrew Ziem at [EMAIL PROTECTED] appended the following bits to my mbox: > Unfortunately, I am not using FileMaker Pro. I am using FileMaker server, a > similar product. Also, FileMaker Server does not support XML, which is the > method fx.php uses to connect PHP and FileMak

[PHP-DB] Mail Function

2002-08-27 Thread Manoj Japher
hi, I know this question is in the wrong group, but I hope someone maybe able to help me out. I need to use the mail() function in my code to send out mails which I am able to do successfully. But I am not able to set the 'from address' in the mail I sent. It always varies. Can I set the fro

[PHP-DB] MSSQL Version

2002-08-27 Thread Gerard Samuel
I just found out today that I could find out mysql or postgresql version # using an sql select statement. 'select version() as version' It doesn't work for MSSQL. Does anyone know of a way to retrieve MSSQL's version via php or sql statement. Thanks. -- Gerard Samuel http://www.trini0.org:81

Re: [PHP-DB] AUTO_INCREMENT problemos

2002-08-27 Thread Miles Thompson
Checl your MySQL docs and redefine the table if necessary: table type of ISAM - autoincrement numbers get reused table type of MyISAM - autoincrement numbers are not reused. Many people prefer the latter and use the values as primary and foreign keys. Miles Thompson At 05:21 PM 8/27/2002 +0200

Re: [PHP-DB] Connecting to FileMaker Server?

2002-08-27 Thread Andrew Ziem
Brent, Unfortunately, I am not using FileMaker Pro. I am using FileMaker server, a similar product. Also, FileMaker Server does not support XML, which is the method fx.php uses to connect PHP and FileMaker Pro. Andrew Brent Baisley wrote: > You'll want to look into Fx.php. You'll have to se

Re: [PHP-DB] AUTO_INCREMENT problemos

2002-08-27 Thread DL Neil
Hi simon > My table has an INT column named 'member_id' which is set to AUTO_INCREMENT. > It works very well but I have inserted and deleted some test rows during the > development stage and now my incremented numbers have jumped ahead. > The deleted rows (their member_id values) have not been fo

Re: [PHP-DB] AUTO_INCREMENT problemos

2002-08-27 Thread Adam Williams
Thats how its supposed to work. It won't reuse old numbers even after you delete the entire row. Adam On Tue, 27 Aug 2002, simon wrote: > Hi > > Wondering if anybody can help with this: > > My table has an INT column named 'member_id' which is set to AUTO_INCREMENT. > I

[PHP-DB] AUTO_INCREMENT problemos

2002-08-27 Thread simon
Hi Wondering if anybody can help with this: My table has an INT column named 'member_id' which is set to AUTO_INCREMENT. It works very well but I have inserted and deleted some test rows during the development stage and now my incremented numbers have jumped ahead. The deleted rows (their member

Re: [PHP-DB] verify text entry in a textarea doesn't work

2002-08-27 Thread chip . wiegand
Thankyou Jason, the problem was indeed in the html code. The code was broken into multiple lines and indented, by moving it all onto one line with no spaces between the >< it now works. Also, when I tab or place the cursor inside the textarea, the cursor now is placed in the upper left corner, wh

Re: [PHP-DB] Connecting to FileMaker Server?

2002-08-27 Thread Brent Baisley
You'll want to look into Fx.php. You'll have to search the internet for it, but it's a free open source download. As I recall, it's a plug-in for FileMaker that allows you to use PHP to talk to FileMaker Pro. On Monday, August 26, 2002, at 07:55 PM, Andrew Ziem wrote: > Can someone recommend

Re: [PHP-DB] verify text entry in a textarea doesn't work

2002-08-27 Thread Jason Wong
On Tuesday 27 August 2002 23:26, [EMAIL PROTECTED] wrote: > I have some error checking routines for my web forms, and they are working > great except for one > field, a textarea field. I am using the following code, but it does not > give an error when the field is > empty: > > if (empty($feedback

RE: [PHP-DB] verify text entry in a textarea doesn't work

2002-08-27 Thread Ruprecht Helms
Hi [EMAIL PROTECTED], > I use the same type of checking on input type="text" boxes and it works > fine. > Any ideas why it doesn't work on a textarea field? > The crlf can be one reason. textareas are not the same like textboxes and you give them parameters how large (horizontal size) and how h

[PHP-DB] Connecting to FileMaker Server?

2002-08-27 Thread Andrew Ziem
Can someone recommend a method for connecting to FileMaker Server 5? This product doesn't seem to support XML (but later versions of the FMS do) or ODBC (I can't find drivers). Though made by the same company, it's a different product than FileMaker Pro. -- Andrew The Springs Rescue Mission +1

[PHP-DB] verify text entry in a textarea doesn't work

2002-08-27 Thread chip . wiegand
I have some error checking routines for my web forms, and they are working great except for one field, a textarea field. I am using the following code, but it does not give an error when the field is empty: if (empty($feedback)) { $errmsg .= "You might want to enter some comments\n"; } I use the

Re: [PHP-DB] Form Error Checking ?

2002-08-27 Thread Cornelia Boenigk
Hi Dave This is working for me if (!empty($HTTP_POST_FILES['updatei']['tmp_name']) AND ($HTTP_POST_FILES['updatei']['tmp_name'] != "none")) { $name = $HTTP_POST_FILES['updatei']['name']; $typ = $HTTP_POST_FILES['updatei']['type']; $size = $HTTP_POST_FILES['updatei']['size']; $tmpname =

Re: [PHP-DB] how to display tree structure from database???

2002-08-27 Thread Pierre-Alain Joye
Hello, http://membres.lycos.fr/sqlpro/Tree/SQL_tree.htm provides a good way to store trees in a DB, docs are in french, nut sql&images are universal. hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] how to display tree structure from database??? [ NEW VERSION]

2002-08-27 Thread José Moreira
adapted to your database ... for errors and more information .. let me know "; } echo "$text"; } # Main function, to be called recursively function Parse_Tree ( $level=0, $parent=0 ) { $db = mysql_connect("localhost", "root", "password");

Re: [PHP-DB] Form Error Checking ?

2002-08-27 Thread Jason Wong
On Tuesday 27 August 2002 16:49, Dave Carrera wrote: > Hi All > > I am very fed up and confused to why some simple form error checking is > not working. > > All I want to do is check if a field has something in it the its ok else > show error. > > I have a fields in my form that is for people to u

RE: [PHP-DB] how to display tree structure from database???

2002-08-27 Thread José Moreira
an example : my table : Field,Type,Null,Key,Default,Extra CATID,int(10) unsigned,,PRI,NULL,auto_increment PARENT,int(10) unsigned,,,0, TEXT,varchar(40) TYPE,set('FILE','POST','FOLDER'),YES,,NULL, code ( using ADODB ) : function PrintNode ( $level , $text) { # função para impri

[PHP-DB] Form Error Checking ?

2002-08-27 Thread Dave Carrera
Hi All I am very fed up and confused to why some simple form error checking is not working. All I want to do is check if a field has something in it the its ok else show error. I have a fields in my form that is for people to upload an image. I have tried this. If(!$_POST[img]){ Do something

[PHP-DB] how to display tree structure from database???

2002-08-27 Thread Smita Manohar
hiii im using php with mysql. i have one table for which i want to display tree structure. for eg. table is like this... person_id name parent_id 1 shyam 0 2 rohit 1 3 nikita 1 4 ram

Re: [PHP-DB] a beginner

2002-08-27 Thread Ruprecht Helms
Hi Pax, > Sorry, Ruprecht. I was talking about mSsql (miscrosoft). Ok, my mistake. I meen that SQL-Server is able to handle stored procedures. But SQL-Server is not the database normaly use with php. Default is mysql. Regards, Ruprecht --

RE: [PHP-DB] next prev links for search result

2002-08-27 Thread joakim . andersson
> -Original Message- > From: Smita Manohar [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 26, 2002 8:26 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] next prev links for search result > > > hiii.. > > i want page no. and next prev links while displaying search > result. the > scri