Passing parameters to MySQL

[Anon]

Hi,

I'm looking for a way to pass a parameter to use in a MySQL SELECT statement.

I have three identical HTML table structures on the same page to display books. Instead of repeating the HTML code in each instance I'd like to re-use the code but pass the book ID number as a parameter in each case as I include the HTML table file into the page.

Is there a way to achieve this in PHP?

Thanks in advance,

Gary Crighton

[cordex]

Have you ever heard of functions?

[Anon]

Hi Ben,

Yes of course, but as a beginner I've yet to really work out how to use them etc.

As it turns out I've solved my problem without them.

Originally the MySQL SELECT command was contained in the same include file as the table structure I wanted to re-use, so only one ID number could be used each time I called the HTML.

Clearly taking the SELECT statement out of the include file allows me to specify numerous ID numbers throughout the page all caling in the identical HTML include file.

Simple, verbose perhaps. But it works.

One step at a time eh?

Cheers,

Gary