*Solved My Self* thanks for the help >_<

[flame_211]

Ok, i want to know how to do a get from the database its my sql, I know how to do a simple one

<?php
include("header.php");
mysql_connect( "my host >_<", "blah", "blah" );
mysql_select_db( "test" );
$rsResult = mysql_query( "SELECT id, username, saying FROM test;" );
echo "<center><b>Members</b></center><p><ul>";
while( list( $id, $username, $saying ) = mysql_fetch_row( $rsResult ) ){
 echo "<li>$id- $username says: $saying</li>";
}
echo "</ul>";
include("footer.php");
?>

All of that works, but now i want to put something in the footer, (I.E. add more variables, but only from one row in the database) right now, that code gets all the rows in the database, and thats fine, but i want to know how to only get one row from the databse in my footer... Any help?

[chrisjk]

execute the query again but with a WHERE clause specifying which row you want

Or, during that while loop, when you get to the row you want, store the values in some variables for use later on in the footer