now this is a bit confusing for me:

i have a search form which sends words searched for to a php script that executes the search in the mysql database. this works fine. now i have added user and password to that form- so the user- if they want to use the form- they will have to fill in three fields: username- password and search terms. works fine.

now i wish to do the following:

have the search form on my front page on the website- and when the user types the search criteria- they invoke another form asking for username and password. this should then invone the php script to process the search data. here- the action = must be of the $PHP_SELF type?

when i do an the if $_post[submit] in the php script- how can i both refer to submit from both forms? the one on the main page asking for search criteria and the other asking for username and password?

thanks a bunch.
please think of it as a yahoo search. ok yahoo doesnt need a password- now what if it did. you search for "mysql" and then u are asked for username and password then after that you get the search results. my database isnt free thats why :-)
guys thanks a lot- i m reposting the question with the code- could you please be specific- im a beginner :-) thanks a lot.

http://answers.yahoo.com/question/index?qid=20080604111643AAVday7&r=w

I ve been googling and yahooing this for some time now but it s all in vain..so Ill give it a shot here..

Is it possible to run a php script stored in a MySql database?

Here s the scenario: I have <?echo hello world ?> stored on a row of mySql databse. Now when I query that database how can I make <?echo hello world ?> to execute? Is this possible? I tried experimenting but the php script stored on the database isn t executing.

Guys enlighten me up and thnx you all look great

Is this possible?

insert into hostname.database.table (select * from hostname.database.table)

Anyone know of any reliable webhosts with PHP and MySQL? Im going to host a text based game on it and I can t find any good ones.

Thnx
Looking for FREE webhosts..

I am wondering if anyone knows how or if I can have a dropdown menu on a form of table entries.

EXAMPLE: Form asks what kind of home you want to build?

Table Homes has: Ranch- Cape- SaltBox- Two-Story- etc.

those choices would be in the drop down of choices.

This way if ever a new type of home is available then it could just be added to the table of homes instead of the page recoded to add another option?

Thank you in advance :)

I m using PHP5 and MySQL BTW

Hello-
What open-source LMS would you recommend?

I am currently using Moodle but find it very limited. It loads slowly- the code is bloated and design options are limited (tricky at best).

Thanks :D

P.S. Something based on PHP+MySQL would be preferred- but not necessary.
Purpose: use within a University for students to see (only) their schedule- special events and study fees. It will serve as a presentation site for non-registered users as well (a WYSIWYG editor will be needed).

A good forum- if available- would be nice- otherwise phpBB (3) will be used.

I would prefer something not Java-based- thanks.