how would i code a page to retrieve data

[AJC]

hi, i have a DB setup and im having problems retreiving the data from a table to a php page, can anyone help me at all? any help will be greatly appreciated, thanks! the table is setup and it has info put into it, its just im having trouble with the page that will show the data in a browser.

[Erkilite]

here is a sample script i use to check for images in a products db. it has connect, and a select statement. this might help.

<?php
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'username');
define('DB_SERVER_PASSWORD', 'password');
define('DB_DATABASE', 'dbname');

$dblink=mysql_connect(DB_SERVER,DB_SERVER_USERNAME,DB_SERVER_PASSWORD) or die('Database server unavailable. '.mysql_error());
mysql_select_db(DB_DATABASE,$dblink) or die ('Database server unavailable. '.mysql_error());


$query='SELECT * FROM products ORDER BY id';

$i=0;
if($result=mysql_query($query,$dblink)){
	while($row=mysql_fetch_array($result,MYSQL_ASSOC)){
		if(file_exists(stripslashes($row['thumbnail']))==false){
			echo stripslashes($row['id']).' missing thumbnail.<br />';
			$i++;
		}
		if(file_exists(stripslashes($row['image']))==false){
			echo stripslashes($row['id']).' missing image.<br />';
			$i++;
		}
	}
} else {
	echo mysq;_error();
}

echo '<br />missing '.$i.' image(s)';
?>