Calling from MySQL database

Anon

I need help with calling data from MySQL. I was able to put data into it and now I need to call it. What I am doing is making an admin panel for a site and having it so that you can input text and what-nots, and it will update the main page of the site. Im pretty sure you can use MySQL to do this, if not can someone tell me how. Thanx.

junebug

well, i would suggest going to mysql.com and reading the manual. that will tell you what it can do, how to do it, and if it will suit your needs.

Anon

Well, I went there before I came here and I wasn't able to find anything. Thats why I posted in here.

brandonschnell

take a look at the articles on this page.

http://www.phpbuilder.com/columns/joe20010104.php3
http://www.phpbuilder.com/columns/jesus19990308.php3

Anon

Thank, but that really doesnt help too much. Does anyone know about like "phpnuke" and thoes kinds of site? Well i want to create a script that will update a page by user input. It doesnt matter how as long as it only used MySQL database or txt files and php4.

Anon

I have the MySQL database all setup and stuff, I just want to know if there is like an easy way just to call from it to get something from lets say:

Database latin - table news

+--+-------------+---------------+
|id|news_headline|news_body |
+--+-------------+---------------+
|1 |Programming |News here. |
+--+-------------+---------------+
|2 |Gaming |In the news... |
+--+-------------+---------------+

Say I had a mainpage.php and I wanted to call id 2 so that I could get Programming as a $headline and the News here as $news_body so that when I input them into a table on my site they show up. All I need to know is how to call from MySQL to be able to print.