I have a database and i want to fetch all the information from each row of the db besides the primary key. for example, i have a table named jobs with fields jobid, company name, summary, requirements, responsabilities, and salary. I want to make a page that will display all the company names and then when they click a name it shows all the info that was submitted for that company.

no such thing as a dumb question :P

the query:

SELECT `company name`, `summary`, `requirements`, `resposibilities`, `salary` FROM jobs

I take it jobid is the primary key?

PHP Code:

$query = "SELECT jobid, companyname, summary, requirements, responsabilities,salary FROM jobs ORDER BY id DESC";
$result = mysql_query ($query);
while ($row = mysql_fetch_assoc ($result)) {

$jobid = $row['jobid'];        
$companyname = $row['companyname'];
$summary = $row['summary'];

echo "Job ID: $jobid"; 


Like that? Im not sure if it works.

I figured this out before i read the topic again. thank you for the replies though

I have another question i'm going to post if you wanna help with that one