if ($estado==""){
mysql_connect("localhost","irelec2_root","irleda");
mysql_select_db("irelec2_mardata");
$sql="SELECT * FROM items ORDER BY RAND() DESC LIMIT 0,5";
$rs=mysql_query($sql);
if($campo=mysql_fetch_array($rs)){
do{
?>
$cadena1 = "imgstock/";
$cadena2 = "-mid.jpg";
$texto .= $cadena1;
$texto .= $campo["OUR"];
$texto .= $cadena2;
$a= substr ($texto,-25);
if( $campo["OUR"]!= "") {
if( file_exists ( $a )) {
?>.jpg"> -mid.jpg" border="0">
} else{
?>
Image not available
} ?>
| Mfg. No.: |
if($campo["MFGNO"] != "") {
?>
|
} else{
?>
No Items were found |
} ?>
| Description: |
if($campo["DESCRIPTION"] != "") {
?>
|
} else{
?>
No Items were found |
} ?>
| Mfg. Name: |
if($campo["MFGNAME"] != "") {
?>
|
} else{
?>
No Items were found |
} ?>
| Date Code: |
if($campo["DATECODE"] != "") {
?>
|
} else{
?>
No Items were found |
} ?>
| Stock: |
if($campo["STOCK"] != "") {
?>
|
} else{
?>
No Items were found |
} ?>
| Our: |
|
}else{ ?>
No Items were found
}?>
}
while($campo=mysql_fetch_array($rs));
}
//}
}
?>