Hola a toda la comunidad foros del web, es mi primera visita y mi primera consulta
.
Pues la cosa es que necesito mostrar en mi sitio en la pagina de inicio lo mas reciente insertado a la base de datos, pero en una forma especifica es decir 4 fotos y la informacion y abajo otras cuatro con su info.
Hasta ahora solo lo puedo hacer por renglones y ni idea de lo ke debo hacer.
Este es mi codigo:
Código PHP:
<?php
// required variables
require("config.php");
$maingroup = mysql_escape_string($_REQUEST['maingroup']);
$secondgroup = mysql_escape_string($_REQUEST['secondgroup']);
$sort = mysql_escape_string($_REQUEST['sort']);
if( $sort == "item") {
$sort_link_item= "item DESC";
} else {
$sort_link_item= "item";
}
if( $sort == "price") {
$sort_link_price= "price DESC";
} else {
$sort_link_price= "price";
}
if( $sort == "price") {
$sort = "price + 0";
}
if( $sort == "price DESC") {
$sort = "price + 0 DESC";
}
?>
<html>
<head>
<TITLE><?php echo $maingroup ?> / <?php echo $secondgroup ?></TITLE>
<link rel="stylesheet" HREF="master_style.css">
<script type="text/javascript" src="overlib.js"><!-- overLIB (c) Erik Bosrup --></script>
</HEAD>
<BODY TEXT="#000000" BGCOLOR="#FFFFFF" LINK="#000000" VLINK="#000000" ALINK="#F70404">
<div id="overDiv" style="Z-INDEX:1000; VISIBILITY:hidden; POSITION:absolute"></div>
<FORM NAME="itemsform">
<CENTER>
<span class="normal"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Tipo de Hecho:</FONT></span><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<?php echo $maingroup ?>| <span class="normal">Número de A.P.:</span> <?php echo $secondgroup ?></FONT>
<HR align="center" WIDTH=100% size=1 COLOR="#000000">
<table cellpadding="2" cellspacing="1" border="0">
<TR>
<TD BGCOLOR="#C4DBE8"><B><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="item_list.php?maingroup=<?php echo $maingroup ?>&secondgroup=<?php echo $secondgroup ?>&sort=<?php echo $sort_link_item ?>">Foto</a></font></B></TD>
<TD BGCOLOR="#C4DBE8"><B><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="item_list.php?maingroup=<?php echo $maingroup ?>&secondgroup=<?php echo $secondgroup ?>&sort=<?php echo $sort_link_item ?>">Nombre del Occiso </a></font></B></TD>
<TD BGCOLOR="#C4DBE8"><B><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="item_list.php?maingroup=<?php echo $maingroup ?>&secondgroup=<?php echo $secondgroup ?>&sort=<?php echo $sort_link_item ?>"><?php echo $txt_item ?></a></font></B></TD>
<TD BGCOLOR="#C4DBE8"><B><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="item_list.php?maingroup=<?php echo $maingroup ?>&secondgroup=<?php echo $secondgroup ?>&sort=<?php echo $sort_link_price ?>"><?php echo $txt_price ?> <?php echo $txt_currency ?></a></font></B></TD>
</TR>
<?php
// database connection
$database_link = mysql_connect("$host","$user","$pass");
if (!$database_link) {
die('Could not connect: ' . mysql_error());
}
// database selection
mysql_select_db("$database");
// database query to select the categories
$result = mysql_query("select distinct * from demo WHERE maingroup = '$maingroup' AND secondgroup = '$secondgroup' ORDER BY $sort") ;
// counter for how many iterations have been done
$i=0;
while($row = mysql_fetch_row($result)) {
$color = ($coloralternator++ %2 ? "FBFCFD" : "F2F7FA");
echo "<TR BGCOLOR=\"#$color\"><TD><a href=\"item_show.php?code_no=$row[3]\" TARGET=\"main\"><IMG SRC=\"images/$row[27]\" BORDER=\"0\" WIDTH=\"$thumbs_width\" HEIGHT=\"$thumbs_height\" onmouseover=\"return overlib('<img src=\'images/$row[27]\'>',VAUTO,HAUTO,WIDTH, 0);\" onmouseout=\"return nd();\"></A></TD>";
echo "<TD ALIGN=\"LEFT\"><font size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\"><a href=\"item_show.php?code_no=$row[3]\" TARGET=\"main\">$row[3]</A></font></TD>";
echo "<TD><font size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\"><a href=\"item_show.php?code_no=$row[3]\" TARGET=\"main\">$row[4]</A></FONT></TD>";
echo "<TD ALIGN=\"LEFT\"><font size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\">$row[6]</font></TD>";
echo"</TD></TR>";
}
mysql_close($database_link);
?>
</TABLE>
<HR align="center" WIDTH=100% size=1 COLOR="#000000">
<font size="-2" face="Verdana, Arial, Helvetica, sans-serif">
<?php echo $txt_click_details ?></FONT>
<P>
</CENTER>
</FORM>
</body>
</html>
Gracias por leer esto.
