[RESOLVED] display data on particular field Options

[fasmy98]

I have one web pages which will be the main page.
I want to display certain field from the database into main page.
I don't have any ideas on how to display the particular fields.
I don't have any problem to display it in table. 😕

<TABLE cellSpacing=0 cellPadding=3 border=0>
<TBODY>
<TR><TD vAlign=top colSpan=2><? display title from news table?></TD></TR>
<TR><TD vAlign=top width=80 rowSpan=2><? display image from news table?></TD></TR>
<TD class=announcedate vAlign=top> <P align=justify>
<? display description from news table?></P></TD></TR>
</TBODY></TABLE>

[vertmonkee]

where will you be getting the information from to display?

if it is a database then you can just seelct the required fields in your call to the database.

[mikawhat]

this will display all the contents of your table:

$query = @mysql_query("SELECT name, image, description FROM table");
while ($row = mysql_fetch_array($query)) {
echo "<TABLE cellSpacing=0 cellPadding=3 border=0>
<TBODY>
<TR><TD vAlign=top colSpan=2>$name</TD></TR> 
<TR><TD vAlign=top width=80 rowSpan=2><img src=\"$image\" /></TD></TR> 
<TD class=announcedate vAlign=top> <P align=justify>
$description</P></TD></TR> 
</TBODY></TABLE>";
}

if you want specific contents then you have to modify the sql query.

[fasmy98]

It was selected from the database.
I only want it to display the selected news for example the news fro the whole week only.
that's mean, the will be 7 news to be display.

All the news were insert using form into database.

[fasmy98]

<TABLE cellSpacing=0 cellPadding=3 border=0>
<TBODY>
<TR><TD vAlign=top colSpan=2><? display title from news table?></TD></TR>
<TR><TD vAlign=top width=80 rowSpan=2><? display image from news table?></TD></TR>
<TD class=announcedate vAlign=top> <P align=justify>
<? display description from news table?></P></TD></TR>

<TR><TD vAlign=top colSpan=2><? display title from news table?></TD></TR>
<TR><TD vAlign=top width=80 rowSpan=2><? display image from news table?></TD></TR>
<TD class=announcedate vAlign=top> <P align=justify>
<? display description from news table?></P></TD></TR>

<TR><TD vAlign=top colSpan=2><? display title from news table?></TD></TR>
<TR><TD vAlign=top width=80 rowSpan=2><? display image from news table?></TD></TR>
<TD class=announcedate vAlign=top> <P align=justify>
<? display description from news table?></P></TD></TR>

<TR><TD vAlign=top colSpan=2><? display title from news table?></TD></TR>
<TR><TD vAlign=top width=80 rowSpan=2><? display image from news table?></TD></TR>
<TD class=announcedate vAlign=top> <P align=justify>
<? display description from news table?></P></TD></TR>

</TBODY></TABLE>