php mysql query question. - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

thegrandwazoo · 02-12-2010, 03:32 PM

How would I go about using php to query a database row, in a table.

For instance, I have a dynamic page setup now, lets say this one page has 20 different articles, and when you select an article from the left hand side, the article appears on the page (loads from the database).

So if you choose article A, article A's content appears on the page.
You choose article B, article B's content appears on the page

..so on and so forth.

Back to the question, how would I set this up in php so when article A is chosen, it selects article A's metadata (title, page desc, keywords) information, same with article B, C, etc? I already have a table set to go, just need a little help creating the code?

Thanks!

swg · 02-14-2010, 03:47 PM

Connect to the MySQL server using mysql_connect

Select the correct database with mysql_select_db

execute the query using mysql_query, something like SELECT * FROM `artiles` WHERE `id` = '$id' - be sure to escape/clean any inputs

Then use mysql_fetch_object to load the data into an object so you can use $obj->column_name

thegrandwazoo · 02-16-2010, 05:20 PM

Yes I have gotten that far, what I am stuck on is how do I tell PHP to query a specific row from the table?

masud7827 · 02-20-2010, 01:43 PM

thanks swg, really gr8

novintabligh · 03-28-2010, 05:19 PM

you should select the specific row by "where" in query

Foresee2010 · 03-28-2010, 11:17 PM

You can choose the CMS is pretty nice and simple operation