Formatting text on data results page.

Valdoua

Okay, I seem to be having a little trouble here formatting my text with the font I want and the size and color.

For some reason when I try to embedd a style into the page it gets all screwed up.

How do you set the type style, color and size for a results area?

Here is my code below:

<?

// Page two, search and display
$connect = mysql_connect("duke.valueweb.net", "fcg3", "dgserver");

$db = mysql_select_db("fcg3", $connect);

$sql = "SELECT *
FROM STOREDATA
WHERE State = '".$POST['state']."'
OR ZIP_Code = '".$POST['zipCode']."'";

$result = mysql_query($sql);

$rows = mysql_num_rows($result);

if($rows > 0) {

echo "<table border=\"0\">

<th align=\"center\">Name</th>
<th align=\"center\">Address</th>
<th align=\"center\">City</th>
<th align=\"center\">State</th>
<th align=\"center\">Zip Code</th>
<th align=\"center\">Sales Phone</th>";

while($row=mysql_fetch_array($result)) {  
    echo "<tr>  
            <td align=\"center\">".$row['Name']."</td> 
            <td align=\"center\">".$row['Address']."</td> 
            <td align=\"center\">".$row['City']."</td> 
            <td align=\"center\">".$row['State']."</td> 
            <td align=\"center\">".$row['ZIP_Code']."</td> 
            <td align=\"center\">".$row['Sales_Phone']."</td> 
          </tr>";  
}

}

else {

echo "No results found";

}

mysql_close($connect); ;

stolzyboy

just create a stylesheet and put a class attribute in the td tag, simple as that

put this in the head of your document

<style type="text/css">
.newstyle {
	color : #000000;
	font-family : Arial, Verdana, Helvetica, sans-serif;
	font-size : 10px;
}
</style>

then in your td to:

<td class="newstyle">

Valdoua

Okay....I did what you said but it still wont work. When I add the <td> line I keep getting an error.

Here is what I have:

<head>
<style type="text/css">
.newstyle {
color : #000000;
font-family : Arial, Verdana, Helvetica, sans-serif;
font-size : 10px;
}
</style>
<head>
<?

// Page two, search and display
$connect = mysql_connect("duke.valueweb.net", "fcg3", "dgserver");

$db = mysql_select_db("fcg3", $connect);

$sql = "SELECT *
FROM STOREDATA
WHERE State = '".$POST['state']."'
OR ZIP_Code = '".$POST['zipCode']."'";

$result = mysql_query($sql);

$rows = mysql_num_rows($result);

if($rows > 0) {

echo "<table border=\"0\">

<th align=\"center\">Name</th>
<th align=\"center\">Address</th>
<th align=\"center\">City</th>
<th align=\"center\">State</th>
<th align=\"center\">Zip Code</th>
<th align=\"center\">Sales Phone</th>";

while($row=mysql_fetch_array($result)) {  
    echo "<tr>
            <td align=\"center\">".$row['Name']."</td> 
            <td align=\"center\">".$row['Address']."</td> 
            <td align=\"center\">".$row['City']."</td> 
            <td align=\"center\">".$row['State']."</td> 
            <td align=\"center\">".$row['ZIP_Code']."</td> 
            <td align=\"center\">".$row['Sales_Phone']."</td> 
          </tr>";  
}

}

else {

echo "No results found";

}

mysql_close($connect); ;

Now where is the <td> line suppose to go?

stolzyboy

replace these types of lines

with these types of lines