[PHP-DB] Join causing Error?
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.catid, c.category, c.under,
c.corder, c.active FROM central_groupfaqq q, central_groupfaqcat c
WHERE q.active = '1' AND
q.global = '1' AND c.active = '1' ORDER BY c.under, c.order,
q.qorder",$db);
Line 285while ($myrow = mysql_fetch_row($result))
Would cause this error:
Warning: Supplied argument is not a valid MySQL result resource in faqbody.php3 on
line 285
When changing the same SELECT statement to:
Line 284$result = mysql_query("SELECT * FROM central_groupfaqq WHERE active =
'1' ORDER BY
qorder",$db);
Works perfectly?
Keith Spiller
a.k.a. Larentium
Re: [PHP-DB] PHP + interbase connection problem
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 - From: "Duky" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 23, 2001 7:53 PM Subject: [PHP-DB] PHP + interbase connection problem Can somebody help me out? I have some problems with connecting my gdb file with PHP. it is giving me this error: Fatal error: Call to undefined function: () in /home/sites/site156/web/columbus/ibconnect.php on line 9 What can I do now? Thnx, Duky -- 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 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: [PHP-DEV] No same username
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 PROTECTED] m: +49 173 9558736 * PHP Quality Assurance http://qa.php.net * -- 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: [PHP] No same username
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 entered is already a name in use? -- PHP General 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] Server side or client side?
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 seen it before. But it's gonna take some creative thinking. My advice is take this question to a JavaScript discussion forum. In a nut shell, what you will probably end up doing, is creating javascript variables from your php/database. Then, you will have some JavaScript onClicks on the page to access these javaScript variables. I hope this sets you on the right path to your answer. I know it's a little generic but hopefully, when someone searches for clientside in the archive, this email will help them as well. Good luck! jeremy - Original Message - From: "Sridhar Ranganathan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 24, 2001 11:15 PM Subject: [PHP-DB] Server side or client side? Hi I have a list that is populated by a table. when an item is selected, i want to show another list populated from antoehr table WITHOUT form submission. possible?? i think this kinda mixes client side and server side does it now?! regards sridhar ranganathan _ 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 additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- 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] Server side or client side?
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 hidden values. Hope to be helpfuly. idsarts. -Mensaje original- De: Forsfot [mailto:[EMAIL PROTECTED]] Enviado el: Domingo, 25 de Febrero de 2001 12:33 p.m. Para: [EMAIL PROTECTED] Asunto: Re: [PHP-DB] Server side or client side? 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 seen it before. But it's gonna take some creative thinking. My advice is take this question to a JavaScript discussion forum. In a nut shell, what you will probably end up doing, is creating javascript variables from your php/database. Then, you will have some JavaScript onClicks on the page to access these javaScript variables. I hope this sets you on the right path to your answer. I know it's a little generic but hopefully, when someone searches for clientside in the archive, this email will help them as well. Good luck! jeremy - Original Message - From: "Sridhar Ranganathan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 24, 2001 11:15 PM Subject: [PHP-DB] Server side or client side? Hi I have a list that is populated by a table. when an item is selected, i want to show another list populated from antoehr table WITHOUT form submission. possible?? i think this kinda mixes client side and server side does it now?! regards sridhar ranganathan _ 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 additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- 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 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] novice forms question
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 PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] novice forms question
This is very crude, but is one way you can do this.
Form Page-
Form Action = "post_page"
input type = "text" name = "form_field1"
input type = "text" name = "form_field2"
...
input type = "submit"
/Form
post_page-
$body = "$form_field1, $form_field2";
mail(sdf, sdf, $body, sdf);
query = "insert into table table_name
(field1, field2)
values
('$form_field1', '$form_field2')";
run query;
- Original Message -
From: "Frank Carotenuto" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 25, 2001 12:37 PM
Subject: [PHP-DB] novice forms question
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 PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
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] cookies, email and passwords
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 so that when they log in they don't have to keep entering their username and password for the hour that the cookie is active? * How do I also call the cookie into each page? If anyone can help with any of these I would be really grateful! _ 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 additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] cookies, email and passwords
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 so that when they log in they don't have to keep entering their username and password for the hour that the cookie is active? * How do I also call the cookie into each page? If anyone can help with any of these I would be really grateful! Hi have a look at phplib http://phplib.netuse.de It may be a bit more than you need but it's good M@ -- 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] cookies, email and passwords
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 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] Interbase + PHP
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. Duky -- 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 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]
FW: [PHP-DB] SQL Server 2000, annoying msg : Changed database context to 'xxx'.
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 annoying msg "Changed database context to 'xxx'." ? Running IIS5 with SQL Server 2000 on Win2K Adv. Svr. in CGI mode. Thanks in advance, Jeroen. -- 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 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]
