Get values from a DB.

[joefox]

Thanks everyone for your help..

Ok 2 questions.
When a page loads up, i wanted it to search my DB, and give me how many (count) of an item there are.
or better yet, just display all the records.
But when i run this code

<?php 
require_once ('mysql_connect.php');
$query = "SELECT dss(MBlock_Part_Number, MBlock_Ref) FROM dss ORDER BY MBlock_Part_Number";
$result = @mysql_query ($query);

if ($result){ 
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
Echo ' <tr><td align="left">' . $row['MBlock_Part_Number'] . '</td><td align="left">' . $row['MBlock_Ref'] . '</td></tr>';
}else{
Echo ' No data retrived ';
}
}
?>

I get an error when i try to load the page.
I just wanted it to search the DB and display the results..

Is there a way i can search also, make a text box, where it inserts it into the query string, and then displays the result?

Thanks again everyone.