Displaying a MySql table in a HTML page

How to display a MySql table in a HTML page

[SokrMan]

So I have a jobs database with the following columns: id, jobtext, jobdate, and id. This is how it looks right now: [prahan.com...]

I have another table called author. In the authorid column in need the results of this query, SELECT name FROM author WHERE id = (SELECT authorid FROM job) , to be displayed for each row.

I also want to be able to customize the header title for each column.

Thanks in advance!

[rocknbil]

Welcome aboard sokrman,

$query = "select author.name,job.jobid from author,job where author.authorid=job.authorid and author.id = $author_id order by job.jobid asc";

Should do it to select by author, change it to job.id=$job_id to select by job. Change the field names accordingly.