css and php problem...

[MDanz]

when i do this, the whole page become blank, when i remove it the page functions again.. i can't spot whats wrong...

 

 <style type="text/css">
.stacktemp a {
display: block;


width: 101px;
height: 57px;

background: url("<?php 

mysql_connect("localhost", "Master", "pword");
mysql_select_db("Login");

$salute = mysql_query("SELECT * FROM messages WHERE to_user = '$_SESSION[username]' ORDER by id DESC LIMI 1")or die(mysql_error());
while($record = mysql_fetch_array($salute))
{ 
$new = $record['new'];
}
if ($new=="0") {

$template = "http://www.testing.com/templatesmallnew.jpg";
} else

{
$template = "http://www.testing.com/templatesmall.jpg";
}


echo "$template"; ?>");
}</style>

[Goldeneye]

It's simple -- you can't put an entire PHP script inside a CSS background-property.

 

You have to do something like this instead:

<?php 

mysql_connect("localhost", "Master", "pword");
mysql_select_db("Login");

$salute = mysql_query("SELECT * FROM messages WHERE to_user = '$_SESSION[username]' ORDER by id DESC LIMI 1")or die(mysql_error());
while($record = mysql_fetch_array($salute))
{ 
$new = $record['new'];
}
if ($new=="0") {

$template = "http://www.testing.com/templatesmallnew.jpg";
} else

{
$template = "http://www.testing.com/templatesmall.jpg";
}
?>

<style type="text/css">
.stacktemp a {
display: block;


width: 101px;
height: 57px;

background: url(<?php $template; ?>);
}
</style>

[MDanz]

thanks found the problem... its with LIMIT.. missed the T