Howto php?

[1r0l3]

Hello guyse, again

I got this problem, i want a "overview" system of some articles, and it to print all the articles there is in my database, i want to do it with a sql query like:
$show = mysql_query("SELECT * FROM news") or die(mysql_error());
then i want it to show whats in news, with a while loop are something like that, but anyone could give me an example how to do it ? what mysql_fecth should i choose and how to do it?

Thanks from 1r0l3, again

[Gogeta70]

I would do something like this:

Code: Select all

if(!@$query = mysql_query("SELECT * FROM news"))
{
    echo mysql_error();
    die();
}

while($row = mysql_fetch_assoc($query))
{
  // handle the database output here
}

I hope that helps.

[1r0l3]

Thanks alot gogeta, got it working now !

[Gogeta70]

No problem ^_^