Display database contents within HTML

[Archeyreece]

Alright so I've been trying to get PHP to display some data from a table in my database. I want it to look like this: http://i53.tinypic.com/2hzjo5i.png

but all im getting is this: http://i56.tinypic.com/1znoc45.jpg

and this is the PHP portion of my code

<?php

$queryTitle = mysql_query("SELECT title FROM posts");
$queryDate = mysql_query("SELECT date FROM posts");
$queryBody = mysql_query("SELECT body FROM posts");

while($rowTitle = mysql_fetch_array($queryTitle)){
  echo "<h2>" . $rowTitle['title'] . "</h2>";
  echo "<br />";
  }
while($rowDate = mysql_fetch_array($queryDate)){
	echo "<h4>" . $rowDate['date'] . "<h4>";
	echo "<br />";
}

?>

Thanks,
Archey

 

[Ray]

Try this.

<?php

$query = mysql_query("SELECT * FROM posts");

while($row = mysql_fetch_array($query)){
  echo "<h2>" . $row['title'] . "</h2>";
  echo "<br />";
  echo "<h4>" . $row['date'] . "<h4>";
  echo "<br />";
  }

?>

PHP processes code from top to bottom unless a class or function is called thus creating a block effect for your code. Also the way you were requesting to pull info from the database is by calling specific information, or in other words ordered data. Using the * denote allows you to pull any information at request without the need for extra coding. if you need more help with this pm me

 

[Archeyreece]

nice, that worked, but they are displaying Ascending from 1-## i want them to descend from ##-0. Anyone know what i have to do?

EDIT: nvm, i found it, just had to add

ORDER BY id DESC

to my query

 

[Ray]

Not a problem.. if you need help with anything else just hit me up