changing print line if record contains..

Anon

I would like the change the way a record displays if it contains an image (<img src="....") in the record. I would like to use <pre> tags on records without images and not use <pre> on records with images. Anyone have any ideas, I've searched all over and can't figure it out???
Here's what I 've got so far, I took out the <pre> tags since they were causing display problems...
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);
$i = 0;
if ($number < 1) {
print "<CENTER>There Were No Results for Your Search</CENTER>";
}
else {
while ($number > $i) {
$headline = mysql_result($result,$i,"headline");
$news = mysql_result($result,$i,"news");
$time = mysql_result($result,$i,"time");
$newtext = wordwrap( $news, 60 );
print "$time $headline $newtext";
$i++;
}
}
Terry

allgood2

Alright, I'll bite. Here's how I would do it.

Okay, first I'd create an array

$results=mysql_query ("SELECT * FROM table ORDER BY field");

then I'd create a loop here, then define field variables

while ($row=mysql_fetch_array($results)){
$headline = $row["headline"];
$news = $row["news"];
$time = $row["time"];

then I'd define the display formats options,

this is done within the loop statement

if.. is used for control

if($image=="")
{
$display_news .="
$headline
 $time
 $news";

else
{
$display_news .="
$image 
 $headline
 $time
 $news";
}

;

}

<? echo "$display_news"; ?>

Closing the first php query, then calling the results with a second <? php will allow the results to be formatted for each iteration, or each record. So if record a has an image, then the esle statement is used, if record b doesn't have an image then the if statement is used.

You'll have to add the extra formatting. I tend to minimalize html code in the <?php statements, so that script is more portal. This script can then be used as an include file in a larger html document, and will use style sheets and formating from that document.

In the html document I would just use the statement

<? include "displaynews.php3"; ?>

Where evr I want the file to display.

Alnisa