PHP style sheet can this be done?

[steveDD]

I have the following php code

<?php

	$sql = "select companyname, picture from onlineoffers where spare = '1'";
	$sql_run = mysql_query($sql, $conn) or die(mysql_error());

			$counter==1;
	while ($values = mysql_fetch_array($sql_run)) {
			$id = $values['id'];
			$companyname = $values['companyname'];
			$picture = $values['picture'];
			$spare = $values['spare'];



				echo "<table border=\"0\" width=\"105\" cellspacing=\"2\" cellpadding=\"1\">";
				echo "<tr><td><img src=\"{$values['picture']}\" width=\"60\" height=\"30\"></td></tr>";

				echo "<tr><td><a href=\"http://www.mysite.co.uk/mem/panies1.php?companyname={$values['companyname']}\"><font face=\"Verdana\" size=\"0\" color=\"#ff6600\">{$values['companyname']}</a></font></td>	
				</tr></table>";


			}


			?>

I have been directly inputting this on each .php page on my website I wish the results to show. This is becoming time consuming and when I need to edit something I have to edit everypage.

I am starting to use CSS style sheets and have a main style file "master.css" refered to in my index.php file.
I want to create I believe a seperate style sheet as such "phpstyle.php" and put this in the header section

<?php header("Content-type: text/css"); ?>

I want to some how put the php code as shown above into this new style sheet, and position it to the right margin. The php code will have the id and variable name "latest" but again I am not sure how I refer to this in the main page and in the php file itself.

This PHP code above produces a image and a text link below (results returned from a MYsql database).

Any advise on how I can use this code in a style sheet would be fantastic.

[ixalmida]

It sounds like you are trying to work backwards. Start with a regular CSS style sheet. Then use PHP to include the code that refers to the styles in your style sheet. For example, you'd put this in your page head:

<link href="../default.css" rel="stylesheet" type="text/css">

That would link up the styles for your page, i.e.:

body {
  margin-top: 5px;
  margin-left: 5%;
  margin-right: 5%;
  padding: 0;
  min-width: 900px;
  min-height: 700px;
  background-color: #CCCCCC;
}

table.list {
  width: 95%;
  max-width: 590px;
  border-collapse: collapse;
}

table.list td {
  margin: 0;
  padding: 0;
  font: 8pt Verdana, Arial, Helvetica, sans-serif;
  text-decoration: none;
  border-bottom: 1px dotted #BA2729;
  vertical-align: bottom;
}

img.icon {
  border: none;
  width: 60px;
  height: 30px;
}

Then you'd link your code to your style:

echo "<table class='list'><tr><td><img class='icon' src='".$values['picture']."'></td>";
// etc...
echo "</tr></table>";

You'll also find that the <font> tag is deprecated. I think the preferred code for an inline font change is something like:

<span style="font: bold 10pt Arial, sans">some words...</span>