[PHP-DB] Join causing Error?

2001-02-25 Thread Keith Spiller
Can anyone tell me why this: Line 282mysql_select_db("centraldb",$db); Line 283$qorder++; Line 284$result = mysql_query("SELECT q.questid, q.question, q.answer, q.qorder, q.depart, q.catid, q.active, q.global, q.adate, q.author, q.authoremail, q.askemail, c.

Re: [PHP-DB] PHP + interbase connection problem

2001-02-25 Thread Meir Kriheli - MKsoft
Looks like your PHP installation is not compiled with interbase support. Can you guve us some more details ? What is the OS you're using and the code the caused you problems. Meir Kriheli MKsoft computer systems 'There's someone in my head but it's not me" - Pink Floyd - Original Message

[PHP-DB] No same username

2001-02-25 Thread Brandon Feldhahn
how do i make somthing with my database that knows it the username entered is already a name in use? -- 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

[PHP-DB] Re: [PHP-DEV] No same username

2001-02-25 Thread André Langhorst
Brandon Feldhahn wrote: > how do i make somthing with my database that knows it the username > entered is already a name in use? please do not cross-post!!! it is sufficient to post it to _one_ mailing list (php-general) thanks -- · André Langhorstt: +49 331 5811560 · · [EMAIL PROTEC

[PHP-DB] Re: [PHP] No same username

2001-02-25 Thread Web Admin
define a UNIQUE field :) - Original Message - From: Brandon Feldhahn To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Sunday, February 25, 2001 4:03 PM Subject: [PHP] No same username how do i make somthing with my database that knows it the username

Re: [PHP-DB] Server side or client side?

2001-02-25 Thread Forsfot
It seems to me that there are a lot of people who believe PHP can be executed on the client side. It cannot. For this, you would use JavaScript. PHP and JavaScript go REALLY well together. They are best friends because they help each other out. There is a way to do what you want to do. I have se

Re: [PHP-DB] Join causing Error?

2001-02-25 Thread Bob Hall
Sir, I don't see anything wrong with the syntax in your query. If I haven't over looked something, and if you haven't misspelled anything, then you have a data problem. Since your first query returns a Cartesian product, you should get something if the WHERE clause returns >= 1 row for each ta

RE: [PHP-DB] Server side or client side?

2001-02-25 Thread Scott Bernard
I think that you can create a hidden frame, where you can work with the values. For example when you select something from the list, you are submiting a form to the hidden frame, populating a hidden list there, then all you have to do y just, with javascript, populate the visible list with the hid

RE: [PHP-DB] Join causing Error?

2001-02-25 Thread Scott Bernard
Where is the join condition on that quey? (the field in common on the to tables, to make the join). idsarts -Mensaje original- De: Keith Spiller [mailto:[EMAIL PROTECTED]] Enviado el: Domingo, 25 de Febrero de 2001 05:30 a.m. Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: [EMAIL PROTECTED

[PHP-DB] novice forms question

2001-02-25 Thread Frank Carotenuto
If this is the right forum, can anyone tell me if I can post a form to two addresses. I'd like to submit the results of a form to both a mailing list and a MySql table. Thank you. Frank Carotenuto, D.D.S. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECT

Re: [PHP-DB] novice forms question

2001-02-25 Thread Forsfot
This is very crude, but is one way you can do this. Form Page- ... post_page- $body = "$form_field1, $form_field2"; mail(sdf, sdf, $body, sdf); query = "insert into table table_name (field1, field2)

[PHP-DB] cookies, email and passwords

2001-02-25 Thread Matthew Cothier
Sorry for putting three topics in one but they all go together so I thought I would. I am setting up a user login/members area! * Firstly how do I generate a random password? * Then how do I email it to the user? * And now I need to know how to set a cookie with their username and password s

RE: [PHP-DB] cookies, email and passwords

2001-02-25 Thread Matt Williams
> Sorry for putting three topics in one but they all go together so > I thought > I would. > > I am setting up a user login/members area! > > * Firstly how do I generate a random password? > > * Then how do I email it to the user? > > * And now I need to know how to set a cookie with their

[PHP-DB] cookies, email and passwords

2001-02-25 Thread Matthew Cothier
Thanks! Is there anyone who can actually give me little bits of code that I need cause I am in a rush with this _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing L

RE: [PHP-DB] Re: [PHP] No same username

2001-02-25 Thread Scott Bernard
There is something called constraints in the database (generally). You have to set that field in the database, to unique, or make a "unique" index on that field. regards. idsarts. -Mensaje original- De: Web Admin [mailto:[EMAIL PROTECTED]] Enviado el: Domingo, 25 de Febrero de 2001 10:2

Re: [PHP-DB] cookies, email and passwords

2001-02-25 Thread Miles Thompson
Matthew, Aren't we all. There's code at www.zend.com which deals with user logins, mailing form information, cookies, storing data etc. Have a look at www.thickbook.com, also WeberDev, DevShed and www.phpbuilder.com Sessions are pretty easy to use, and you may want to consider them rather tha

[PHP-DB] Interbase + PHP

2001-02-25 Thread Duky
I am using a Unix/Linux server. How can I recompile my php to use interbase?? Where can I find that, to recompile? what do I need to recompile and what do I have to include into that file? I am new to this. so if somebody can help me out.. really thanks. Duky -- PHP Database Mailing List (http:

Re: [PHP-DB] Interbase + PHP

2001-02-25 Thread Duky
my own OS is win98. Duky wrote: > > I am using a Unix/Linux server. How can I recompile my php to use > interbase?? Where can I find that, to recompile? what do I need to > recompile and what do I have to include into that file? I am new to > this. so if somebody can help me out.. really thanks.

Re: [PHP-DB] authentication in a browsing directory

2001-02-25 Thread Helmut Tessarek
Hi, This sounds good, but I thought it could be easier to use the browsing function of the Apache Webserver, since this function is already implemented. I just don't know, how to access this function, if there is an index file present. If there is no way to do that, I will try to use the filesyst

FW: [PHP-DB] SQL Server 2000, annoying msg : Changed database context to 'xxx'.

2001-02-25 Thread Jeroen ten Berge
Anyone has some info ?!? -Original Message- From: Jeroen ten Berge [mailto:[EMAIL PROTECTED]] Sent: dinsdag 20 februari 2001 13:29 To: PHP Database Subject: [PHP-DB] SQL Server 2000, annoying msg : Changed database context to 'xxx'. Hello people :) Anyone had problems with the annoyin