Jump to content
Larry Ullman's Book Forums

Ms Access Criterion Query In Php & Mysql?


Recommended Posts

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

 

 

Link to comment
Share on other sites

 Share

×
×
  • Create New...