Help pulling data from db..

louisp

Hi.. I'd like to be able to pull data from mysql, so that it is displaying both authors, and the shortview of all the written columns.

»» $author :
$column_by_author
»» $author2 :
$column_by_author2
$column2_by_author2
»» $author3 :
$column_by_author3

If that doesn't make sense please say so. As all I want to do is something like a subquery.. that displays all the authors and below the author, the link to their column (its in the db).

tomhath

What you are trying to do should be simple, but since you'll have to give some details as far as tables, columns, etc.

louisp

They are not yet created but I'm probably going to have two tables..

Table 1:

AUTHORS

authorid
authorname
authormail

COLUMNS

columnid
columnauth
columndate
columnintro
columntext

jordy

There are lots of good tutorials about fetching data out of a mysql db. I suggest you to read them first. Second you need to know the SQL basics for creating queries..

you might want to try something like:

code to connect to db
$query = "SELECT a.authorname, a.authormail, b.columnauth, b.columndate, b.columnintro, b.columntext FROM authors a, colomns b WHERE a.authorname = b.colomnauth";

$sql = mysql_fetch_array($query);

while ($rows = mysql_fetch_array($query)) {
foreach ($rows as $row) {
echo $row."<BR>";
}
}

Note: this code may contain some errors but this is the basic way.. Have phun and you can mail me if you have some further questions..