[Resolved] Display data from database

kekke

Hi!

Still a noob at this whole php-thingy but I think I´m learning more and more. 😉

Now I really need some help. I´m trying to make a newsscript (sort of) and now I´m stuck...

I have a html-page with a form with 3 fields. title, ingress and article. When I hit the "publish" button the data from the three formfields is sent to a file that I have named addnews.php and this file sends the data to my mysql database. I works like I want it to. I checked the db-table and the data is there.

Now my problem is how to display the data on a page. I have looked on a lot of places but not found a solution. I know this is probably the most basic and easiest thing to do...but where can I learn it?

Here is the code for a file called "view.php". I cant see what is wrong with it. Note that I do not get any errors on the page.

<?
mysql_pconnect("my-db","user","pass");
mysql_select_db("the_db");
$result = mysql_query("SELECT title, ingress, article FROM news WHERE title='$title' AND ingress='$ingress' AND article='$article'");
while($r=mysql_fetch_array($result))
{	
	$title=$r["title"];
	$ingress=$r["ingress"];
	$article=$r["article"];
	echo "$title, $ingress, $article";
}
?>

Would be grateful if I could get some help on this one.

Shrike

Where are you getting the links for the MySQL query from? If it is from a link on a page it is likely that you would need to use $_GET['title'] etc.

Also, you should be able to access a complete database row from one column. It is common practice to give each database table an id field, and make it the primary key. Giving it an auto_increment attribute also ensures that it remains unique.

This would then allow SQL queries such as

"SELECT title, ingress, article FROM newstable WHERE id = '".$_GET['id']."'";

kekke

Thanks for the answer!

I feel like a complete moron at this so could you explain more in detail the steps that I need to do.

I want to get the data from the sql table called "news" and display it on the page called view.php or whatever.

Do I need to add something to the code I posted? Is there some kind of tutorial for this?

Shrike

I'm sure there will be numerous examples and tutorials on this forum, and within the Articles section.

kekke

Ehh...it worked...i´m speechless! This is awsome!

Shrike...you´re the best! 😃

Now I just need to learn how to edit the articles and how to format them! 😉

Super thanks!