Gettin the data back

Anon

Ok, I've very new to Mysql and PHP.

I've got as far as getting the data into the mysql database, and I can view all the data. But I need to know how I would go about choosing the just fields I want to view.

Like say I want to view the comments from a feedback form stored in a mysql,
Is there a way to get just the comments by using something like this..
http://www.mydomain.com/comments.php?id=1
so that I can view just the comments of table?

I'm sorry if I confused you,
I bought a book on PHP but its not much help, it just teaches certin things, and leaves out allot.

thanks

Anon

here u can run the scripts as above.

www.mydomain.com/advertisement.php?id=1

u can use select statement in the below code

cheers

$result = mysql_db_query($DB, "Delelte from FROM advertisement where id = '$id'");
$row = mysql_fetch_array($result);
while ($id=$row["id"])
{
$id = $row["id"];
$adname = $row["adname"];
print "<tr><td width=\"97\">";

print "$adname</font></td>";
print "<td width=\"45\">";

print "<a href=\"advertisement.php?id=$id&action=delete\" onClick=\"if (check_del()) return true; else return false;\">delete</a></td>";

print "</tr>";

$row = mysql_fetch_array($result);
}
mysql_free_result ($result);
?>

[deleted]

First, teach yourself how to do things right with mysql.
Read this:
http://www.xs4all.nl/~vinny/index.html#4

Then, read the MySQL manual for examples of select statements.

swampy

I found this one helpful.

http://www.webmasterbase.com/article.php/228/399