Does Anyone Know About Prepared Statements in MySQL? (Need help and explanation)

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Does Anyone Know About Prepared Statements in MySQL? (Need help and explanation)

Hello everyone. I'm trying to wrap my head around the concept of prepared statements and how to write them. Any assistance is much appreciated.

Let's say that I want to inner join a table on a common column name and I want that first query to return column names only. then I want to run a query on that first query that looks for any blank values on those previous rows returned and I want that second query to return those rows that have a blank value.

It's basically looking for blank values in matching rows returned without having to write those column names. Here's my attempt.

Go to phpmyadmin, open your database, click on the sql panel(the panel that gives us a textbox to enter SQL queries and execute them).
Type your query there and click on execute. Eg : SELECT * FROM employees ORDER BY lastname, firstname

If you want to run prepared queries there, its not possible(as far as I know).