Display database contents within HTML

Archeyreece · 07-16-2011, 12:12 AM

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
????: NamePros.com http://www.namepros.com/programming/723335-display-database-contents-within-html.html

and this is the PHP portion of my code

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** · 07-16-2011, 05:06 AM

Try this.

PHP Code:

  
????: NamePros.com http://www.namepros.com/showthread.php?t=723335
<?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 · 07-18-2011, 05:52 AM

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

Code:

ORDER BY id DESC

to my query

**Ray** · 07-18-2011, 10:36 AM

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

07-16-2011, 12:12 AM	THREAD STARTER #1 (permalink)
Archeyreece NamePros Regular Join Date: Jan 2009 Location: Canada Posts: 237	Display database contents within HTML 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 ????: NamePros.com http://www.namepros.com/programming/723335-display-database-contents-within-html.html and this is the PHP portion of my code 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

07-16-2011, 05:06 AM	#2 (permalink)
Ray CEO Join Date: Jun 2005 Location: Tennessee Posts: 1,894	Try this. PHP Code: `????: NamePros.com http://www.namepros.com/showthread.php?t=723335 <?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 __________________ GIFTARD.com \| CSDATE.com \| INVOLVEX.com \| SYATCH.com

07-18-2011, 05:52 AM	THREAD STARTER #3 (permalink)
Archeyreece NamePros Regular Join Date: Jan 2009 Location: Canada Posts: 237	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 Code: ORDER BY id DESC to my query Last edited by Archeyreece; 07-18-2011 at 06:02 AM.

07-18-2011, 10:36 AM	#4 (permalink)
Ray CEO Join Date: Jun 2005 Location: Tennessee Posts: 1,894	Not a problem.. if you need help with anything else just hit me up __________________ GIFTARD.com \| CSDATE.com \| INVOLVEX.com \| SYATCH.com

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
50,000 human reviewed links database - built to order	CrackFeed.Com	Content For Sale	1	06-24-2011 04:09 PM
World Hotels Database with 208,065 Hotels - Very Comprehensive Fields & Images	immediate	Content For Sale	0	06-04-2011 04:24 AM
wordpress readymade database for Sell	yengkok	Content For Sale	0	05-22-2011 12:44 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)