MySQL return one result ..not top result

maxl_stylee

K. Here's how it's going down.
What I would like to be able to do, is to access an article by tagging "id=23" at the end of the url. Example:

http://gaffle.net/first/index.php?i=22

Displaying article number 22 somewhere on the page.

Code:

$connect = mysql_connect("localhost", $user, $pass);
$query = "SELECT id FROM ladies_man WHERE id='$i'";
$result = mysql_db_query("gaffle_net", $query);
while($r = mysql_fetch_array($result)){

$title = $r["title"];
$article = $r["article"];

echo "$title";
echo "<img src=\"images/gun.gif\" border=\"1\" align=\"left\">$article";

}
?>

I'm pretty sure i'm far off here. I'm not too grand with MySQL and PHP yet, however, I gotta learn somewhere. So please, if I'm far fetched here, go ahead and say so, and help me out some. 🙂

Thanks.

Alex

Anon

my selecting "id" from instead of selecting * from, you are returning only the id column as opposed to all, so the information you're trying to get as well is being omitted.

methinks.

maxl_stylee

Ah. Thanks 🙂

I didn't recall the syntax.

worked like a charm. 🙂

maxl