Ms Access Criterion Query In Php & Mysql?

[wesmith4]

I am new to using PHP and MySQL.  Previously used MS Access.

One ability in creating a query in Access was very helpful to me.

I am asking if something like it is available in PHP-MySQL.

 

Here is a query designed for use in  MS Access:

------------

SELECT tblCourses.[ClassID], tblCourses.[Coursename], tblCourses.[TeaLastname], tblCourses.[TeaFirstname]
FROM tblCourses
WHERE (((tblCourses.[TeaLastname])=[Enter teacher's last name:]));
------------

This query allowed the user of the query to input a teacher's last name and then receive all the data for the courses taught by that teacher.

 

Can anyone tell me how to accomplish this using PHP and MySQL?

 

I would appreciate any guidance or assistance.

Thank you.

Wes Smith

 

 

[HartleySan]

Log in to phpMyAdmin, select the table you want to perform the query on, and then click the SQL tab. You should have the option to use query templates.