RE: [PHP-DB] password / email

2001-02-21 Thread Allsebrook_Richard/askr
BDY.RTF -- 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]

[PHP-DB] Setting cookies that are valid for two or more domains

2001-02-21 Thread Trond Erling Hundal
Hey there... I need to set a cookie with variables that will be valid for two domains with different names. In reality these two domains are on the same server, and even in the same dir we use: php4, apache, Linux -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

RE: [PHP-DB] PHP security

2001-02-21 Thread s.budd
moreover , even if they cant see the text of the page, Your password is going over the internet in plain text. -Original Message- From: Don [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 7:24 PM To: php-db list Subject: [PHP-DB] PHP security I am writing aome PHP

RE: [PHP-DB] PHP security

2001-02-21 Thread s.budd
But if the database is on another machine then the password is sent as plain text over the internet, no? -Original Message- From: Ben Cairns [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 10:06 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP security Anything

RE: [PHP-DB] Is there a PHP equivalent of DATE_FORMAT ?

2001-02-21 Thread php3
Addressed to: "Timothy Wright" [EMAIL PROTECTED] [EMAIL PROTECTED] I need to convert the input to a valid timestamp first. Any ideas?? Am I missing something really obvious...it's late and my brain is tired.. Read the MySQL manual, section 7.4.11 Date and Time Functions

RE: [PHP-DB] PHP security

2001-02-21 Thread php3
Addressed to: "s.budd" [EMAIL PROTECTED] [EMAIL PROTECTED] ** Reply to note from "s.budd" [EMAIL PROTECTED] Wed, 21 Feb 2001 10:03:33 - But if the database is on another machine then the password is sent as plain text over the internet, no? No. MySQL encrypts the password

[PHP-DB] php.mysql

2001-02-21 Thread Ramiro Radjiman
i have this code. function create_mysqltable($db_name,$table_name){ mysql_select_db($db_name); $sql_query = "CREATE TABLE IF NOT EXISTS $table_name " . "( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, " . " soort char(20), " . " aantal varchar(20) DEFAULT '0', " . " str_men

RE: [PHP-DB] retrieval of NEXT, PREV records

2001-02-21 Thread Chris Book
you have to make sure you order by Rec_id all the time too. -Original Message- From: JJeffman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 4:39 PM To: Adv. Systems Design; [EMAIL PROTECTED] Subject: Re: [PHP-DB] retrieval of NEXT, PREV records "SELECT * FROM Table WHERE

[PHP-DB] while loop driving me crazy

2001-02-21 Thread Miles Thompson
I've used a similar structure hundreds of times, but the following isn't working: $result = mysql_query($sql, $db); if( !$result ) { echo "No result code in SQL send. br"; } if( mysql_num_rows( $result ) = 1 ) { echo "Rows fetched: ", mysql_num_rows( $result ), "br"; while( $row

RE: [PHP-DB] while loop driving me crazy

2001-02-21 Thread Allsebrook_Richard/askr
BDY.RTF -- 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] while loop driving me crazy

2001-02-21 Thread Chris Andrew
Remove the semi-colon after your while() statement. -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: 21 February 2001 15:01 To: [EMAIL PROTECTED] Subject: [PHP-DB] while loop driving me crazy I've used a similar structure hundreds of times, but the

[PHP-DB] Data input

2001-02-21 Thread Matthew Cothier
I have set up a database so that users can submit news to my website. The only problem is they input their news article into the database through a form but it comes out as a continuous string of text. (a) shows what it looks like now, and (b) shows how its supposed to look. How can they

[PHP-DB] php/mysql

2001-02-21 Thread Ramiro Radjiman
i have this code. function create_mysqltable($db_name,$table_name){ mysql_select_db($db_name); $sql_query = "CREATE TABLE IF NOT EXISTS $table_name " . "( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, " . " soort char(20), " . " aantal varchar(20) DEFAULT '0', " . " str_men

RE: [PHP-DB] while loop driving me crazy

2001-02-21 Thread Miles Thompson
Richard, What can one say? Too late? Too long looking at it? Reading too quickly? or in the immortal wordsof Charlie Brow " AUUGH!" Thanks a million and love your signature. Miles Thompson At 03:30 PM 2/21/01 +, [EMAIL PROTECTED] wrote: while( $row = mysql_fetch_array( $result ) )

[PHP-DB] nl2br()

2001-02-21 Thread Matthew Cothier
Where exactly do I need to insert this? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP-DB] authentication in a browsing directory

2001-02-21 Thread Helmut Tessarek
Hi, I've got some directories that should be accessed via the browser. This works fine. To secure a directory I always used the directives in the .htaccess file. This works aswell. Now I wrote a little PHP script that looks in a table of a database if the user is allowed to access the page or

Re: [PHP-DB] retrieval of NEXT, PREV records

2001-02-21 Thread JJeffman
As far as I know, if you do not set any special order, the table is ordered by primary key, isn't it ? Jayme. -Mensagem Original- De: Chris Book [EMAIL PROTECTED] Para: JJeffman [EMAIL PROTECTED]; Adv. Systems Design [EMAIL PROTECTED]; [EMAIL PROTECTED] Enviada em: quarta-feira, 21 de

[PHP-DB] authentication in a browsing directory

2001-02-21 Thread Helmut Tessarek
Hi, I've got some directories that should be accessed via the browser. This works fine. To secure a directory I always used the directives in the .htaccess file. This works aswell. Now I wrote a little PHP script that looks in a table of a database if the user is allowed to access the page or

[PHP-DB] MySQL database transfer

2001-02-21 Thread Sridhar Ranganathan
Hi I have mysql on linux and windows on the same machine. How do i transfer data between them?? Thanks in advance _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List

RE: [PHP-DB] retrieval of NEXT, PREV records

2001-02-21 Thread Sweep the Net
It would only be ordered that way if you had not deleted any records and added new ones. IF there are ones deleted, the next ones frill in the space. Bob At 05:00 PM 2/21/01 -0500, you wrote: Perhaps it is ordered that way, perhaps not, but live by the creed "Expect nothing and you will

Re: [PHP-DB] Data input

2001-02-21 Thread CC Zona
In article [EMAIL PROTECTED], [EMAIL PROTECTED] ("Matthew Cothier") wrote: How can they input the data into the database as they typ eit in without them having to add html .br. tags? nl2br() -- CC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] retrieval of NEXT, PREV records

2001-02-21 Thread JJeffman
I'm sorry I haven't noticed that. I couldn't believe, then I tried to create and make some delete-insert operations and the primary key order has gone away. Thanks a lot. One more lesson I learned. Jayme. -Mensagem Original- De: Sweep the Net [EMAIL PROTECTED] Para: [EMAIL PROTECTED]

[PHP-DB] cancel 3A943D4B.8B7974E9@evermeet.cx

2001-02-21 Thread Helmut Tessarek
This message was cancelled from within Mozilla. -- 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]

[PHP-DB] Re: Is there a PHP equivalent of DATE_FORMAT ?

2001-02-21 Thread Phil Daintree
Timothy Wright wrote: ... so echo date("Y-n-j") would give me the output in the right format, but I need to convert the input to a valid timestamp first. You can use parse out the year, month and day and then use the mktime function - the dates I use are dd/mm/yy format: /*Make an array of

Re: [PHP-DB] MySQL database transfer

2001-02-21 Thread Andrew Apold
At 03:24 AM 2/22/01 -, Sridhar Ranganathan wrote: Hi I have mysql on linux and windows on the same machine. How do i transfer data between them?? use mysql dump to create a script, .sql file, and execute it on the other one. = "To dwell within Samsara,

[PHP-DB] Problem with IB's LEN

2001-02-21 Thread Jarek Zgoda
I have in my Interbase6 table a column defined as NUMERIC(18,2), but PHP shows it as integer value. During tests i discovered, that largest precision allowed for large exact numeric is 9 (NUMERIC(9,2)). Is there any switch that allows use larger precisions? Cheers Jarek Zgoda -- PHP Database

[PHP-DB] Can PHP read View in stead of Table?

2001-02-21 Thread WC Ip
Dear all, I have install PHP on Linux and use Openlink ODBC Driver to link to MS SQL server on Windows NT. Just now I can read data from Table on SQL server. However, when I make View on the same database, I can't use PHP to extract data from this View. When I do query on the View, error

Re: [PHP-DB] number formatting bug?

2001-02-21 Thread Lennin Arriola
I was thinking again , if you are for instance using winxxx check in start settings/control panel/regional settings decimal after point... this might be affecting, there must be something similar on unix. Check out in the help "set_locale" that should do the trick. Lennin Arriola [EMAIL

[PHP-DB] Oracle - PHP

2001-02-21 Thread Hise, Jeremy
Hi: I have PHP with mySQL compiled in. We are about to attempt to connect to Oracle. Of course we have to rebuild PHP with the added Oracle support, but I was just wondering if anyone has done this and if so, could you offer any noteworthies or comments about using PHP with Oracle. Thanks!