sql/php question

[anfetienne]

i have coding to select a certain row and then echo/print all values onto a page.....but when everything is echoed all it shows is the values from the 1st column which is tempID.....how can i change the results code to make it show all values....or is there a sql code that does this?

here is my code

<?
$errorM = 'TEMPLATE NOT FOUND - Please make sure that you have saved your template before trying to preview or get your html code';
 
$username="tempsUser";
$password="auction";
$database="auctionTemps";
 
mysql_connect(localhost,$username,$password);
 
@mysql_select_db($database) or die( "Unable to select database");
 
// Select column 1 from table name where column name = $your_var.
$sql = "SELECT * FROM savedTemps WHERE tempID = '{$tempID}'";
// If mysql_query returns false, we'll die with the error.
$result = mysql_query( $sql ) or die( mysql_error );
 
// If a there is a match
if ( mysql_num_rows( $result ) > 0 )
{
 
$htmlcss=mysql_result($result,"htmlcss");
$header=mysql_result($result,"header");
$nav=mysql_result($result,"nav");
$titleWrap01=mysql_result($result,"titleWrap01");
$title=mysql_result($result,"title");
$titleWrap02=mysql_result($result,"titleWrap02");
$subheadWrap01=mysql_result($result,"subheadWrap01");
$subheading=mysql_result($result,"subheading");
$subheadWrap02=mysql_result($result,"subheadWrap02");
$flashWrap01=mysql_result($result,"flashWrap01");
$flashWrap02=mysql_result($result,"flashWrap02");
$flash01=mysql_result($result,"flash01");
$flashVar=mysql_result($result,"flashVar");
$flash02=mysql_result($result,"flash02");
$flashWrap03=mysql_result($result,"flashWrap03");
$descriptionWrap01=mysql_result($result,"descriptionWrap01");
$description=mysql_result($result,"description");
$descriptionWrap02=mysql_result($result,"descriptionWrap02");
$generalWrap01=mysql_result($result,"generalWrap01");
$general=mysql_result($result,"general");
$generalWrap02=mysql_result($result,"generalWrap02");
$aboutWrap01=mysql_result($result,"aboutWrap01");
$about=mysql_result($result,"about");
$aboutWrap02=mysql_result($result,"aboutWrap02");
$paymentWrap01=mysql_result($result,"paymentWrap01");
$payment01=mysql_result($result,"payment01");
$payment02=mysql_result($result,"payment02");
$paymentWrap02=mysql_result($result,"paymentWrap02");
$termsWrap01=mysql_result($result,"termsWrap01");
$terms=mysql_result($result,"terms");
$termsWrap02=mysql_result($result,"termsWrap02");
$footer=mysql_result($result,"footer");
 
 
echo $htmlcss; 
echo ($header);
echo ($nav);
echo ($titleWrap01);
echo ($title); 
echo ($titleWrap02);
echo ($subheadWrap01);
echo ($subheading);
echo ($subheadWrap02); 
echo ($flashWrap01);
echo ($flashWrap02);
echo ($flash01);
echo ($flashVar); 
echo ($flash02);
echo ($flashWrap03);
echo ($descriptionWrap01);
echo ($description); 
echo ($descriptionWrap02);
echo ($generalWrap01);
echo ($general);
echo ($generalWrap02); 
echo ($aboutWrap01);
echo ($about);
echo ($aboutWrap02);
echo ($paymentWrap01);
echo ($payment01);
echo ($payment02);
echo ($paymentWrap02);
echo ($termsWrap01); 
echo ($terms);
echo ($termsWrap02);
echo ($footer);
}
 
else{
echo $errorM;
}
 
mysql_close();
?>
 
 

[Markus]

Hello again.

Check out this tutorial.

- mark.