What would be the best way on an online quiz- using a php/mySQL framwork to make a person - once they ve started the quiz have to finish or get zero s? Zend? Ajax? Ruby? Perl? Just sessions / cookies? (something else?)

(I d like it if they close the browser that it would submit a call as well- and I m thinking that might have to be done with JavaScript)

i m trying to adapt this code to create a search engine for my database- but it just is not working. I first tested it by creating the "users" database. The following bit probably needs space after LIKE- i tried that as well:

$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE %$find% ");

Could someone be kind enough to check it for any errors?. That would be greatly appreciated. Thanks a lot people.

http://php.about.com/od/phpwithmysql/ss/php_search.htm

and yes- i tried both the action $PHP_SELF- putting the html and php codes all in one file as well as separating them by using "action=newFile.php".
"first tested it by creating the "users" database"

ok users table :-) database had another name.
"What is the error messages? Need more information. Your query looks OK."

no error messages. When i press search- it returns nothing. tried jim- pizza et was supposed to find something.

Any step by step procedure to make it work. Also how do i downgrade my Browser to IE 6.Any help

i am creating a table with the following data types:

article_Id---> int
title_of_article--->varchar
URL--> varchar
content_summary-->varchar
Date-->date

is this good selection nof data types or should i have gone with BLOB and Text as well? thanks.
article_Id is also auto_increment and a primary key
mailbox: which is better as a datatype for text- blob or varchar? or text?
for an id = integer
or an article s title: varchar or text?
etc.
ah you are a robot :-) cuz you always ask that question- it seems :-)))
ADD:

Seco- thanks a lot: "for content_summary - set it as text (allows for lots and lots of text)".

great that s what i was wondering about because the content summary can be large and i couldnt figure out a good limit. No im not using Unix- windows based accessing MySQL through PHP. Thanks man.

i want to upload my php web application to a domain server that support PHP but i can t see if the have support for phpMyAdmin and mysql- what files or folder should I upload to their web server in order for my web app to work?

I m an Engineering(Mechatronics)/Computer Science student.
I need to choose 2 of the following for my electives:

1. Database Applications
Database System Architectural Principles
Data models
Theory of database design
Query Optimization
Storage Strategies
Query Processing
Transaction Processing

2. Web Application Development
HTTP
HTML and XML
JavaBeans
Design Patterns (e.g.- Abstract Factories and Model-View-Controller)
Tag Libraries (JSTL)
Relational Databases (MySQL/JDBC)
Object-Relation Mapping tools (BeanFactory)
Security (including SSL)
Web Services (SOAP/WSDL/UDDI)
Frameworks (Struts)
Internationalization
Scalability and Performance Issues

3. Computer Graphics
basic image processing
geometric transformations
geometric modeling of curves and surfaces
animation
3-D viewing
visibilit

All of them looks quite interesting to me. Please explain to me which subject is more important/useful to me as a Mechatronics student towards my future career.
ps:Mechatronics=mecha+tronics

Thanks!