[PHP-DB] RE: [PHP-WIN] Passing Logined in Name form One Form to other Page

2001-12-19 Thread Svensson, B.A.T. (HKG)
>From: Jack >Dear all >I had create the Login Page for the User to login before they >can open the WebPage. What i want to do is to: > >When the User had type the Username into the Inputbox, and click the submit >button, this Username will be memorized, and pass to other PHP Page.Then >when he g

[PHP-DB] Passing Logined in Name form One Form to other Page

2001-12-19 Thread Jack
Dear all I had create the Login Page for the User to login before they can open the WebPage. What i want to do is to: When the User had type the Username into the Inputbox, and click the submit button, this Username will be memorized, and pass to other PHP Page.Then when he go to some page which

[PHP-DB] Re: Problem with PHP4 and dba_open

2001-12-19 Thread Yasuo Ohgaki
Juffe ÅBerg wrote: > When I try to open a file, ex. using command: > $db = dba_open("newfile", "c", "db3"); > > and run script from the command line, it only says: > "driver initialization failed in test.php line 50." > > why? i have extension php_db and php_dba (and some others) included in as

[PHP-DB] Re: PHP Extensions

2001-12-19 Thread Yasuo Ohgaki
[EMAIL PROTECTED] wrote: > Where I can get PHP Library Extensions for linux redhat 7.1, i need > dbase library > > Thanks > > Accoding to config.m4, dbase extension does not require external lib. I might be worng, though. -- Yasuo Ohgaki -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] PHP/Mysql web hosting: who's best?

2001-12-19 Thread Indioblanco
I signed-up for a trial with Aletia.com after Jonathan wrote a similar glowing review about 6 weeks ago. Great service-- so far it has worked as advertised. I also think they have the best $9.95/mo package around. PHPMyAdmin is already setup for you to manage your dbs. -ib Jonathan Hilgeman w

Re: [PHP-DB] Mysql result resource error

2001-12-19 Thread Bas Jobsen
$sql = "select Minor_Category FROM main where Page = 'wines' order by Minor_Category"; Op donderdag 20 december 2001 01:19, schreef Shannon Doyle: > Hi People, > > I am getting a Not a valid Mysql result resource error with the > following code, can someone take a look at this for me and see if

[PHP-DB] Mysql result resource error

2001-12-19 Thread Shannon Doyle
Hi People, I am getting a Not a valid Mysql result resource error with the following code, can someone take a look at this for me and see if there is anything that stands out Thanks, Shannon ".$cattyname.""; $catname = ""; $sql = "select Category,Code,Description,Pack,Unit,Price from main w

RE: [PHP-DB] PHP/Mysql web hosting: who's best? [worth to read]

2001-12-19 Thread Nagasea
My friend do the webhosting company, maybe you intrested with this : BEWARE WITH WEBHOSTING WITH UNLIMITED BANDWITH / SPACE, THEY'RE SCAM !! READ THEIR POLICY & AGREEMENT BEFORE SIGN UP !! At that time your site is growing you'll be doom ! Monthly Price is 13$ Setup fee is $15 Diskspace 300mb Ban

Re: [PHP-DB] PHP/Mysql web hosting: who's best?

2001-12-19 Thread Matt Nigh
check out www.darkscape.net, good quality hosting for cheap. http://www.darkscape.net/?x=services for pricing which ranges from $7 to $25 - Original Message - From: "Gormley, Robert" <[EMAIL PROTECTED]> To: "'Matthew Crouch'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, Decem

[PHP-DB] Problem with PHP4 and dba_open

2001-12-19 Thread Juffe Åberg
When I try to open a file, ex. using command: $db = dba_open("newfile", "c", "db3"); and run script from the command line, it only says: "driver initialization failed in test.php line 50." why? i have extension php_db and php_dba (and some others) included in as modules. so.. what's wrong? - Ju

RE: [PHP-DB] PHP/Mysql web hosting: who's best?

2001-12-19 Thread Gormley, Robert
I haven't had any problems with www.phpwebhosting.com - $9.95 a month... > -Original Message- > From: Matthew Crouch [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, 20 December 2001 4:28 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP/Mysql web hosting: who's best? > > I looked at hype

[PHP-DB] Re: Decrypting PASSWORD() from MySQL

2001-12-19 Thread Fredrik Arild Takle
> I have a form for a user to request their forgotten username and password by > entering their email address. I then process this and use mail() to send > them their username and password. However, the password is stored in an > encrypted PASSWORD('password') field in the MySQL table. How can I r

Re: [PHP-DB] phpmyadmin user grants

2001-12-19 Thread Patrick Guillot
dear jtjohnston , > I have a user xyz. > I want xyz to able to see table ccl.main_table > I go to user xyz's grants > I select the database ccl > I select the table main_table > what do I grant him so he can see but not change or harm ccl.main_table You could probably use the queries below : RE

Re: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-19 Thread Paul DuBois
On Wed, Dec 19, 2001 at 12:24:02PM -0700, Zach Curtis wrote: > I have a form for a user to request their forgotten username and password by > entering their email address. I then process this and use mail() to send > them their username and password. However, the password is stored in an > encrypt

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-19 Thread Zach Curtis
Thanks for the suggestions. I guess I can try to: A) Store the password in plaintext if I need to retrieve the password. B) Store the password using PASSWORD() and then generate a new random password if needed, replacing the old password. C) Look into mcrypt, ENCODE()/DECODE(), encipher/decipher

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-19 Thread ted
Yet another example of ted's out-to-lunchness... Use the mcrypt functions on the password... -- 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 PROTE

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-19 Thread ted
Here's another approach: use MySQL's encipher/decipher function and have a super-secret password to encrypt/decrypt. -- 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 administrato

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-19 Thread ted
No. Rather, it's "computationally infeasible". On Wed, 19 Dec 2001, Zach Curtis wrote: > Fortunately, this application is still in testing, therefore the users and > passwords in the db are meaningless. However, I thought storing encrypted > passwords in a db was a good idea, that is if can ret

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-19 Thread Zach Curtis
Fortunately, this application is still in testing, therefore the users and passwords in the db are meaningless. However, I thought storing encrypted passwords in a db was a good idea, that is if can retrieve the decrypted password. Can this be done? -Original Message- From: [EMAIL PROTECT

Re: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-19 Thread ted
Well, it's (intended to be) difficult. Perhaps you can NULL it out and have them put in a new password... On Wed, 19 Dec 2001, Zach Curtis wrote: > I have a form for a user to request their forgotten username and password by > entering their email address. I then process this and use mail() to

[PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-19 Thread Zach Curtis
I have a form for a user to request their forgotten username and password by entering their email address. I then process this and use mail() to send them their username and password. However, the password is stored in an encrypted PASSWORD('password') field in the MySQL table. How can I retrieve

RE: [PHP-DB] PHP/Mysql web hosting: who's best?

2001-12-19 Thread Jonathan Hilgeman
I've been through a bunch of hosts and I've stuck with Aletia.com for a while now. Their e-mail support is excellent, and the staff is personable, friendly, and communicative with their customers. Many customers are on a first-name basis with some of the staff. I pay $9.95 a month for 200 megs of

[PHP-DB] PHP Extensions

2001-12-19 Thread pcastillo
Where I can get PHP Library Extensions for linux redhat 7.1, i need dbase library Thanks -- 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] PHP/Mysql web hosting: who's best?

2001-12-19 Thread Matthew Crouch
I looked at hypermart.net and they want $30 a month, which seems okay but their package comes with things I don't need, like 15 email addresses. I have a modest little dB -- does anyone know of good deals for plain folk? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

[PHP-DB] Re: converting extracted variables to arrays

2001-12-19 Thread Matthew Crouch
here it is: http://www.php.net/manual/en/function.explode.php [EMAIL PROTECTED] wrote: > Hi, > i have a variable which is multi valued seperated by # (say as) delimiter > > like student#name#address#college#etc... #...# > i want to seperate it into an array with index $i > can anyone suggest a

Re: [PHP-DB] SQL/PHP problem

2001-12-19 Thread Joshua Hoover
What format is $expDate in? You'll need to make sure it's in the format your database expects for a date type column. Joshua Hoover > I'm trying to delete rows from a database where the date is older then my > $expDate variable, but for some reason, no matter what I try and what > examples I us

[PHP-DB] PHP and Oracle 9i Application Server

2001-12-19 Thread Carlos Fraga
Hi Does anybody knows of a way to access an Oracle Database by the Oracle Application Server ? Thanks in advance. Carlos Alberto Fraga Leite [EMAIL PROTECTED] http://www.desenvolvedor.eti.br Porque programar nem sempre é fácil (grátis: [

[PHP-DB] Re: SQL/PHP problem

2001-12-19 Thread Fred
For some reason, dates and databases seem to cause problems for many people. Yes, you should certainly rtfm, there are many functions in php and mysql/postgresql that deal with functions and they may clarify your problem. Then again, they may not. The basic problem that most people run into is th

[PHP-DB] SQL/PHP problem

2001-12-19 Thread Brian Grayless
I'm trying to delete rows from a database where the date is older then my $expDate variable, but for some reason, no matter what I try and what examples I use for help, I can't get this to work??? I first took the $expDate string and set the var type to "integer". The datatype for the "msgCreated"

[PHP-DB] Re: MySQL: Reverse Order by???

2001-12-19 Thread Chuck Lidderdale
Brian Grayless wrote: > This is probably a really stupid question, but I'm not by any means an SQL > guru. > > How you do a reverse order by in SQL, kind of like "ORDER BY field" only > reverse the order??? > > Thanks, > Brian ... order by last_name desc; ... order by last_name asc; -- PHP

Re: [PHP-DB] MySQL: Reverse Order by???

2001-12-19 Thread Richard S. Crawford
ORDER BY field DESC At 07:27 AM 12/19/2001, Brian Grayless wrote: >How you do a reverse order by in SQL, kind of like "ORDER BY field" only >reverse the order??? Sliante, Richard S. Crawford http://www.mossroot.com AIM: Buffalo2K ICQ: 11646404 Y!: rscrawford MSN: [EMAIL PROTECTED] "It is o

[PHP-DB] MySQL: Reverse Order by???

2001-12-19 Thread Brian Grayless
This is probably a really stupid question, but I'm not by any means an SQL guru. How you do a reverse order by in SQL, kind of like "ORDER BY field" only reverse the order??? Thanks, Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addition

Re: [PHP-DB] Re: while...if statements???

2001-12-19 Thread Chris Lee
personal pref. Once I knew php and mysql better I wrote my own wrappers, I found using them easier. But there is no reason why someone couldnt do fine without one. writing a set of wrappers allowed me to better optimize my queries and write code faster without having to worry about everything e

[PHP-DB] Where i can get dbase.so library extension

2001-12-19 Thread pcastill
I need open dbf files from php. My php.ini has "extension=dbase.so" and i`m using dbase_open() function in my php script. Y have a fatal error. The error says "Fatal error: Call to undefined function: dbase_open()" I think that i need something libraries. Where i can get dbase.so library extension

[PHP-DB] Euro symbol

2001-12-19 Thread Rubanowicz, Lisa
Hi All, The Euro symbol that works in the browser IE5 is € however it doesn't work in Netscape. Anyone got any ideas ?? and when will they be updating. All the Best Lisa Lisa Rubanowicz Case ITC, Navan, Ireland Tel: #353 (0)46 77663 [EMAIL PROTECTED]

RE: [PHP-DB] Re: while...if statements???

2001-12-19 Thread matt stewart
and i always thought the best tactic was to go ugly early. seriously, this isn't really that ugly a solution, most textbooks tend to tell you to use this method to start with as its a bit simpler to understand for beginners - an if...else statement to see if an initial row is returned, then you c