Baking...
--------------------------------------...
Name: app
Path: C:\easyphp\www\cakephp\app
--------------------------------------...
[M]odel
[C]ontroller
[V]iew

What would you like to Bake? (M/V/C)
> C
--------------------------------------...
Controller Bake:
--------------------------------------...

Fatal error: Call to undefined function mysql_connect() in

C:\easyphp\www\cakeph
p\cake\libs\model\dbo\dbo_mysql.php on line 100

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