1
PHP / Re: AYUDA - Funcion no imprime datos
« en: 25 de Marzo de 2008, 16:38:29 pm »
well anyway... ya lo solucione!!!
gracias!
gracias!
Noticias:
Intenta ser respetuoso con el resto de los usuarios o podrías ser sancionado.
Mostrar Mensajes
Esta sección te permite ver todos los posts escritos por este usuario. Ten en cuenta que sólo puedes ver los posts escritos en zonas a las que tienes acceso en este momento.
2
PHP / Re: AYUDA - Funcion no imprime datos
« en: 25 de Marzo de 2008, 15:39:44 pm »
deberia imprimir aqui
<?php mysql_select_db($database_flamuko, $flamuko);
<?php mysql_select_db($database_flamuko, $flamuko);
$query_Recordset3 = "SELECT * FROM linea WHERE id_sub = '$row_Recordset2[id]'";
$Recordset3 = mysql_query($query_Recordset3, $flamuko) or die(mysql_error());
$totalRows_Recordset3 = mysql_num_rows($Recordset3);
while($sub=mysql_fetch_array($Recordset3)){?>
<tr>
<td> </td>
<td> </td>
<td colspan="2" class="descPROD"><?php echo $sub[nombre]; }?>
3
PHP / AYUDA - Funcion no imprime datos
« en: 25 de Marzo de 2008, 15:25:56 pm »
Saludos debo hacer esto
se trata de una ficha de productos donde deben aparecerme los productos de la siguient manera
Categoria de los productos
Subcategoria
Linea de prod.
Producto1
Producto2
y tods los mencionados en esa rama....
Ahora bien... Relaciono en la tabla Subcategoria el id_cat con el id de la tabla categoria
Relaciono en la tabla Linea id_sub con el id de la tabla subcategoria
y asi deberia de hacer con productos donde el id_lin deba ser = al id de la tabla linea..
pero la declaracion de linea no me imprime hace esto
deberia imprimir asi
Categoria
SubCategoria
Linea
y solo imprime
Categoria
SubCategoria
en les dejo mi codigo
<?php require_once('Connections/flamuko.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_flamuko, $flamuko);
$query_Recordset1 = "SELECT * FROM categoria";
$Recordset1 = mysql_query($query_Recordset1, $flamuko) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<link href="css/estilos.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
a {
}
a:link {
}
a:visited {
}
a:hover {
}
a:active {
}
body {
}
-->
</style>
<p class="tituloPROD"> </p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td scope="col"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td colspan="2" class="tituloPROD"><?php
</tr>
<?php mysql_select_db($database_flamuko, $flamuko);
<td> </td>
<td width="8%"> </td>
<td width="87%" colspan="2" class="descPROD">
</tr>
<?php mysql_select_db($database_flamuko, $flamuko);
</table>
</td>
</tr>
<tr>
<td scope="col"> </td>
</tr>
</table>
<p class="tituloQUIENES">
<?php
mysql_free_result($Recordset1);
?>
se trata de una ficha de productos donde deben aparecerme los productos de la siguient manera
Categoria de los productos
Subcategoria
Linea de prod.
Producto1
Producto2
y tods los mencionados en esa rama....
Ahora bien... Relaciono en la tabla Subcategoria el id_cat con el id de la tabla categoria
Relaciono en la tabla Linea id_sub con el id de la tabla subcategoria
y asi deberia de hacer con productos donde el id_lin deba ser = al id de la tabla linea..
pero la declaracion de linea no me imprime hace esto
deberia imprimir asi
Categoria
SubCategoria
Linea
y solo imprime
Categoria
SubCategoria
en les dejo mi codigo
<?php require_once('Connections/flamuko.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_flamuko, $flamuko);
$query_Recordset1 = "SELECT * FROM categoria";
$Recordset1 = mysql_query($query_Recordset1, $flamuko) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<link href="css/estilos.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
a {
font-family: Verdana, Arial, Helvetica, sans-serif;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: none;
}
body {
margin-left: 12px;
}
-->
</style>
<p class="tituloPROD"> </p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td scope="col"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td colspan="2" class="tituloPROD"><?php
echo $row_Recordset1['nombre']; ?> </td>
</tr>
<?php mysql_select_db($database_flamuko, $flamuko);
$query_Recordset2 = "SELECT * FROM subcategoria WHERE id_cat =".$row_Recordset1['id'];
$Recordset2 = mysql_query($query_Recordset2, $flamuko) or die(mysql_error());
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
while($prod=mysql_fetch_assoc($Recordset2)){?>
<tr>
<td> </td>
<td width="8%"> </td>
<td width="87%" colspan="2" class="descPROD">
<?php echo $prod['nombre']; }?></td>
</tr>
<?php mysql_select_db($database_flamuko, $flamuko);
$query_Recordset3 = "SELECT * FROM linea WHERE id_sub = '$row_Recordset2[id]'";
$Recordset3 = mysql_query($query_Recordset3, $flamuko) or die(mysql_error());
$totalRows_Recordset3 = mysql_num_rows($Recordset3);
while($sub=mysql_fetch_array($Recordset3)){?>
<tr>
<td> </td>
<td> </td>
<td colspan="2" class="descPROD"><?php echo $sub[nombre]; }?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td scope="col"> </td>
</tr>
</table>
<p class="tituloQUIENES">
<?php
mysql_free_result($Recordset1);
?>
4
PHP / SOS - Flash no se muestra en PHP
« en: 31 de Enero de 2008, 18:14:19 pm »
Saludos, estoy extrayendo el flash de la base de datos pero no se muestra... solo me sale
"no se cargo la pelicula"
aqui les dejo mi codigo a ver si encuentran el error
les agradeceria su ayuda por favor :'(
<?php require_once('Connections/incomed.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$colname_Recordset1 = "-1";
if (isset($_GET['id'])) {
$colname_Recordset1 = $_GET['id'];
}
mysql_select_db($database_incomed, $incomed);
$query_Recordset1 = sprintf("SELECT * FROM productos WHERE id = %s", GetSQLValueString($colname_Recordset1, "int"));
$Recordset1 = mysql_query($query_Recordset1, $incomed) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
<head>
<title>..// I N C O M E D //..</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<style type="text/css">td img {display: block;}body {
background-image: url(images/fondofondo.jpg);
}
</style>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<link href="css/estilos.css" rel="stylesheet" type="text/css" />
</head>
<body bgcolor="#ffffff">
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<!-- fwtable fwsrc="interno3.png" fwpage="ficha prod" fwbase="ficha_prod.gif" fwstyle="Dreamweaver" fwdocid = "365333443" fwnested="0" -->
<tr>
<td width="9"><img src="spacer.gif" width="9" height="1" border="0" alt="" /></td>
<td width="177"><img src="spacer.gif" width="177" height="1" border="0" alt="" /></td>
<td width="8"><img src="spacer.gif" width="8" height="1" border="0" alt="" /></td>
<td width="265"><img src="spacer.gif" width="265" height="1" border="0" alt="" /></td>
<td width="22"><img src="spacer.gif" width="21" height="1" border="0" alt="" /></td>
<td width="82"><img src="spacer.gif" width="80" height="1" border="0" alt="" /></td>
<td width="3"><img src="spacer.gif" width="3" height="1" border="0" alt="" /></td>
<td width="81"><img src="spacer.gif" width="79" height="1" border="0" alt="" /></td>
<td width="3"><img src="spacer.gif" width="3" height="1" border="0" alt="" /></td>
<td width="82"><img src="spacer.gif" width="80" height="1" border="0" alt="" /></td>
<td width="13"><img src="spacer.gif" width="13" height="1" border="0" alt="" /></td>
<td width="12"><img src="spacer.gif" width="12" height="1" border="0" alt="" /></td>
<td><img src="spacer.gif" width="10" height="1" border="0" alt="" /></td>
<td width="4"><img src="spacer.gif" width="1" height="1" border="0" alt="" /></td>
</tr>
<tr>
<td rowspan="15" bgcolor="#FFFFFF"> </td>
<td colspan="11" rowspan="2" bgcolor="#FFFFFF"><img name="ficha_prod_r1_c3" src="http://www.forosdelweb.com/images/banner.jpg" width="741" height="152" border="0" id="ficha_prod_r1_c3" alt="" /></td>
<td width="12" rowspan="15" bgcolor="#FFFFFF"> </td>
<td><img src="spacer.gif" width="1" height="41" border="0" alt="" /></td>
</tr>
<tr>
<td><img src="spacer.gif" width="1" height="111" border="0" alt="" /></td>
</tr>
<tr>
<td height="6" colspan="11" bgcolor="#FFFFFF"></td>
<td><img src="spacer.gif" width="1" height="6" border="0" alt="" /></td>
</tr>
<tr>
<td rowspan="4" bgcolor="#FFFFFF"><img name="ficha_prod_r4_c3" src="http://www.forosdelweb.com/images/menu.jpg" width="177" height="208" border="0" id="ficha_prod_r4_c3" alt="" /></td>
<td rowspan="12" bgcolor="#FFFFFF"> </td>
<td colspan="9" bgcolor="#FFFFFF"><img name="ficha_prod_r4_c5" src="http://www.forosdelweb.com/images/titulo_prod.gif" width="556" height="56" border="0" id="ficha_prod_r4_c5" alt="" /></td>
<td><img src="spacer.gif" width="1" height="56" border="0" alt="" /></td>
</tr>
<tr>
<td height="6" colspan="9" bgcolor="#FFFFFF"></td>
<td><img src="spacer.gif" width="1" height="6" border="0" alt="" /></td>
</tr>
<tr>
<td height="17" colspan="9" bgcolor="ffffff"> </td>
<td><img src="spacer.gif" width="1" height="17" border="0" alt="" /></td>
</tr>
<tr>
<td width="256" rowspan="9" valign="top" bgcolor="ffffff"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3%" class="tituloINDEX"> </td>
<td width="97%" class="tituloINDEX"><?php echo $row_Recordset1['titulo']; ?></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2" class="textoINDEX"><div align="justify"><?php echo $row_Recordset1['comen']; ?></div></td>
</tr>
</table></td>
<td colspan="8" rowspan="3" align="center" valign="top" bgcolor="#D8D8CC"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
</tr>
</table>
/***************************************************\
<script src="DWConfiguration/ActiveContent/IncludeFiles/AC_RunActiveContent.js" type="text/javascript"></script>
<script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','282','height','226','src','flash/<?php echo $row_Recordset1['flash']; ?>','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','flash/<?php echo $row_Recordset1['flash']; ?>' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="300" height="237">
<param name="movie" value="flash/<?php echo $row_Recordset1['flash']; ?>">
<param name="quality" value="high">
<embed src="flash/<?php echo $row_Recordset1['flash']; ?>" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="282" height="226"></embed>
</object>
</noscript>
/***************************************************\
</td>
<td><img src="spacer.gif" width="1" height="129" border="0" alt="" /></td>
</tr>
<tr>
<td height="8" bgcolor="#FFFFFF"></td>
<td><img src="spacer.gif" width="1" height="8" border="0" alt="" /></td>
</tr>
<tr>
<td rowspan="7" bgcolor="#FFFFFF"><img name="ficha_prod_r9_c3" src="http://www.forosdelweb.com/images/banner_prod.gif" width="177" height="302" border="0" id="ficha_prod_r9_c3" alt="" /></td>
<td><img src="spacer.gif" width="1" height="80" border="0" alt="" /></td>
</tr>
<td height="112" colspan="8" rowspan="4" bgcolor="#D8D8CC"><table width="257" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><?php $producto_id=$row_Recordset1['id'];
include('img_inc.php');
?></td>
</tr>
</table></td>
<td height="5"> </td>
<tr>
<td height="5"><img src="spacer.gif" width="1" height="53" border="0" alt="" /></td>
</tr>
<tr>
<td height="3"><img src="spacer.gif" width="1" height="3" border="0" alt="" /></td>
</tr>
<tr>
<td><img src="spacer.gif" width="1" height="53" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="7" bgcolor="#D8D8CC"> </td>
<td bgcolor="#D8D8CC"> </td>
<td><img src="spacer.gif" width="1" height="28" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="7" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td><img src="spacer.gif" width="1" height="85" border="0" alt="" /></td>
</tr>
<tr>
<td height="9" colspan="13" bgcolor="#FFFFFF"></td>
<td><img src="spacer.gif" width="1" height="9" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="13" valign="top"><p style="margin:0px"></p></td>
<td><img src="spacer.gif" width="1" height="8" border="0" alt="" /></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="11" bgcolor="#FFFFFF"><img name="ficha_prod_r17_c3" src="http://www.forosdelweb.com/images/abajofon.jpg" width="741" height="40" border="0" id="ficha_prod_r17_c3" alt="" /></td>
<td bgcolor="#FFFFFF"> </td>
<td><img src="spacer.gif" width="1" height="40" border="0" alt="" /></td>
</tr>
</table>
z
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
Ahy les marco el codigo del flash... Saludos
"no se cargo la pelicula"
aqui les dejo mi codigo a ver si encuentran el error
les agradeceria su ayuda por favor :'(
<?php require_once('Connections/incomed.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$colname_Recordset1 = "-1";
if (isset($_GET['id'])) {
$colname_Recordset1 = $_GET['id'];
}
mysql_select_db($database_incomed, $incomed);
$query_Recordset1 = sprintf("SELECT * FROM productos WHERE id = %s", GetSQLValueString($colname_Recordset1, "int"));
$Recordset1 = mysql_query($query_Recordset1, $incomed) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
<head>
<title>..// I N C O M E D //..</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<style type="text/css">td img {display: block;}body {
background-image: url(images/fondofondo.jpg);
}
</style>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<link href="css/estilos.css" rel="stylesheet" type="text/css" />
</head>
<body bgcolor="#ffffff">
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<!-- fwtable fwsrc="interno3.png" fwpage="ficha prod" fwbase="ficha_prod.gif" fwstyle="Dreamweaver" fwdocid = "365333443" fwnested="0" -->
<tr>
<td width="9"><img src="spacer.gif" width="9" height="1" border="0" alt="" /></td>
<td width="177"><img src="spacer.gif" width="177" height="1" border="0" alt="" /></td>
<td width="8"><img src="spacer.gif" width="8" height="1" border="0" alt="" /></td>
<td width="265"><img src="spacer.gif" width="265" height="1" border="0" alt="" /></td>
<td width="22"><img src="spacer.gif" width="21" height="1" border="0" alt="" /></td>
<td width="82"><img src="spacer.gif" width="80" height="1" border="0" alt="" /></td>
<td width="3"><img src="spacer.gif" width="3" height="1" border="0" alt="" /></td>
<td width="81"><img src="spacer.gif" width="79" height="1" border="0" alt="" /></td>
<td width="3"><img src="spacer.gif" width="3" height="1" border="0" alt="" /></td>
<td width="82"><img src="spacer.gif" width="80" height="1" border="0" alt="" /></td>
<td width="13"><img src="spacer.gif" width="13" height="1" border="0" alt="" /></td>
<td width="12"><img src="spacer.gif" width="12" height="1" border="0" alt="" /></td>
<td><img src="spacer.gif" width="10" height="1" border="0" alt="" /></td>
<td width="4"><img src="spacer.gif" width="1" height="1" border="0" alt="" /></td>
</tr>
<tr>
<td rowspan="15" bgcolor="#FFFFFF"> </td>
<td colspan="11" rowspan="2" bgcolor="#FFFFFF"><img name="ficha_prod_r1_c3" src="http://www.forosdelweb.com/images/banner.jpg" width="741" height="152" border="0" id="ficha_prod_r1_c3" alt="" /></td>
<td width="12" rowspan="15" bgcolor="#FFFFFF"> </td>
<td><img src="spacer.gif" width="1" height="41" border="0" alt="" /></td>
</tr>
<tr>
<td><img src="spacer.gif" width="1" height="111" border="0" alt="" /></td>
</tr>
<tr>
<td height="6" colspan="11" bgcolor="#FFFFFF"></td>
<td><img src="spacer.gif" width="1" height="6" border="0" alt="" /></td>
</tr>
<tr>
<td rowspan="4" bgcolor="#FFFFFF"><img name="ficha_prod_r4_c3" src="http://www.forosdelweb.com/images/menu.jpg" width="177" height="208" border="0" id="ficha_prod_r4_c3" alt="" /></td>
<td rowspan="12" bgcolor="#FFFFFF"> </td>
<td colspan="9" bgcolor="#FFFFFF"><img name="ficha_prod_r4_c5" src="http://www.forosdelweb.com/images/titulo_prod.gif" width="556" height="56" border="0" id="ficha_prod_r4_c5" alt="" /></td>
<td><img src="spacer.gif" width="1" height="56" border="0" alt="" /></td>
</tr>
<tr>
<td height="6" colspan="9" bgcolor="#FFFFFF"></td>
<td><img src="spacer.gif" width="1" height="6" border="0" alt="" /></td>
</tr>
<tr>
<td height="17" colspan="9" bgcolor="ffffff"> </td>
<td><img src="spacer.gif" width="1" height="17" border="0" alt="" /></td>
</tr>
<tr>
<td width="256" rowspan="9" valign="top" bgcolor="ffffff"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3%" class="tituloINDEX"> </td>
<td width="97%" class="tituloINDEX"><?php echo $row_Recordset1['titulo']; ?></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2" class="textoINDEX"><div align="justify"><?php echo $row_Recordset1['comen']; ?></div></td>
</tr>
</table></td>
<td colspan="8" rowspan="3" align="center" valign="top" bgcolor="#D8D8CC"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
</tr>
</table>
/***************************************************\
<script src="DWConfiguration/ActiveContent/IncludeFiles/AC_RunActiveContent.js" type="text/javascript"></script>
<script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','282','height','226','src','flash/<?php echo $row_Recordset1['flash']; ?>','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','flash/<?php echo $row_Recordset1['flash']; ?>' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="300" height="237">
<param name="movie" value="flash/<?php echo $row_Recordset1['flash']; ?>">
<param name="quality" value="high">
<embed src="flash/<?php echo $row_Recordset1['flash']; ?>" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="282" height="226"></embed>
</object>
</noscript>
/***************************************************\
</td>
<td><img src="spacer.gif" width="1" height="129" border="0" alt="" /></td>
</tr>
<tr>
<td height="8" bgcolor="#FFFFFF"></td>
<td><img src="spacer.gif" width="1" height="8" border="0" alt="" /></td>
</tr>
<tr>
<td rowspan="7" bgcolor="#FFFFFF"><img name="ficha_prod_r9_c3" src="http://www.forosdelweb.com/images/banner_prod.gif" width="177" height="302" border="0" id="ficha_prod_r9_c3" alt="" /></td>
<td><img src="spacer.gif" width="1" height="80" border="0" alt="" /></td>
</tr>
<td height="112" colspan="8" rowspan="4" bgcolor="#D8D8CC"><table width="257" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><?php $producto_id=$row_Recordset1['id'];
include('img_inc.php');
?></td>
</tr>
</table></td>
<td height="5"> </td>
<tr>
<td height="5"><img src="spacer.gif" width="1" height="53" border="0" alt="" /></td>
</tr>
<tr>
<td height="3"><img src="spacer.gif" width="1" height="3" border="0" alt="" /></td>
</tr>
<tr>
<td><img src="spacer.gif" width="1" height="53" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="7" bgcolor="#D8D8CC"> </td>
<td bgcolor="#D8D8CC"> </td>
<td><img src="spacer.gif" width="1" height="28" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="7" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td><img src="spacer.gif" width="1" height="85" border="0" alt="" /></td>
</tr>
<tr>
<td height="9" colspan="13" bgcolor="#FFFFFF"></td>
<td><img src="spacer.gif" width="1" height="9" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="13" valign="top"><p style="margin:0px"></p></td>
<td><img src="spacer.gif" width="1" height="8" border="0" alt="" /></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="11" bgcolor="#FFFFFF"><img name="ficha_prod_r17_c3" src="http://www.forosdelweb.com/images/abajofon.jpg" width="741" height="40" border="0" id="ficha_prod_r17_c3" alt="" /></td>
<td bgcolor="#FFFFFF"> </td>
<td><img src="spacer.gif" width="1" height="40" border="0" alt="" /></td>
</tr>
</table>
z
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
Ahy les marco el codigo del flash... Saludos
5
PHP / AYUDA: Repeat Area Horizontal
« en: 07 de Diciembre de 2007, 16:38:30 pm »
disculpen alguien sabria como hacer una tabla 3 x 3 y q esta se rellene con los campos de una columna extraiga de la base de datos por ejemplo la columna imagen
imagen1 imagen2 imagen3
imagen4 imagen5 imagen6
de antemano gracias!!!!
este es mi codigo al q quiero aplicarle eso
<?php require_once('Connections/connect.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$maxRows_Recordset1 = 3;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_connect, $connect);
$query_Recordset1 = "SELECT imagen FROM marca ORDER BY nombre ASC";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $connect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="48%"><table border="0" cellpadding="2" cellspacing="2">
<tr>
<td>imagen</td>
</tr>
<?php do { ?>
<tr>
<td><a href="#" onClick="window.open('ficha_pr.php?id_marca=<?=$id_marca;?>;','verimagen', 'width=400,height=400'); return false;"><img src="images/<?php echo $row_Recordset1['imagen']; ?>" width="200" height="200" class="bordeimg" /></a></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table></td>
<td width="48%"> </td>
<td width="4%"> </td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
imagen1 imagen2 imagen3
imagen4 imagen5 imagen6
de antemano gracias!!!!
este es mi codigo al q quiero aplicarle eso
<?php require_once('Connections/connect.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$maxRows_Recordset1 = 3;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_connect, $connect);
$query_Recordset1 = "SELECT imagen FROM marca ORDER BY nombre ASC";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $connect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="48%"><table border="0" cellpadding="2" cellspacing="2">
<tr>
<td>imagen</td>
</tr>
<?php do { ?>
<tr>
<td><a href="#" onClick="window.open('ficha_pr.php?id_marca=<?=$id_marca;?>;','verimagen', 'width=400,height=400'); return false;"><img src="images/<?php echo $row_Recordset1['imagen']; ?>" width="200" height="200" class="bordeimg" /></a></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table></td>
<td width="48%"> </td>
<td width="4%"> </td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
6
PHP / Re: [AYUDA] MySQL server version
« en: 16 de Noviembre de 2007, 20:46:30 pm »
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_listproduc = "localhost";
$database_listproduc = "ocean";
$username_listproduc = "root";
$password_listproduc = "";
$listproduc = mysql_pconnect($hostname_listproduc, $username_listproduc, $password_listproduc) or trigger_error(mysql_error(),E_USER_ERROR);
?>
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_listproduc = "localhost";
$database_listproduc = "ocean";
$username_listproduc = "root";
$password_listproduc = "";
$listproduc = mysql_pconnect($hostname_listproduc, $username_listproduc, $password_listproduc) or trigger_error(mysql_error(),E_USER_ERROR);
?>
7
PHP / [AYUDA] MySQL server version
« en: 16 de Noviembre de 2007, 20:19:52 pm »
Saludos, tengo un problema y es q hice un listado de productos el cual llama a una base de datos .. al probarlo de manera local funciona perfecto.. pero al subirlo a la web da el siguiente error...
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Alguien podria ayudarme? aqui les dejo el codigo
<?php require_once('Connections/listproduc.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset1 = "SELECT * FROM categoria WHERE id_marca = 0";
$Recordset1 = mysql_query($query_Recordset1, $listproduc) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset7 = "SELECT * FROM categoria WHERE id_marca = 1";
$Recordset7 = mysql_query($query_Recordset7, $listproduc) or die(mysql_error());
$row_Recordset7 = mysql_fetch_assoc($Recordset7);
$totalRows_Recordset7 = mysql_num_rows($Recordset7);
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset8 = "SELECT * FROM producto WHERE PKIDCAT =".$row_Recordset1['PKID'];
$Recordset8 = mysql_query($query_Recordset8, $listproduc) or die(mysql_error());
$row_Recordset8 = mysql_fetch_assoc($Recordset8);
$totalRows_Recordset8 = mysql_num_rows($Recordset8);
?>
<p>jdhehdfhekdhke</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th scope="col"> </th>
</tr>
<tr>
<th scope="col"><?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td colspan="2" class="tituloPROD"><?php
echo $row_Recordset1['nombre']; ?> </td>
</tr>
<?php mysql_select_db($database_listproduc, $listproduc);
$query_Recordset2 = "SELECT * FROM producto WHERE PKIDCAT =".$row_Recordset1['PKID'];
$Recordset2 = mysql_query($query_Recordset2, $listproduc) or die(mysql_error());
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
while($prod=mysql_fetch_assoc($Recordset2)){?>
<tr>
<td> </td>
<td width="8%"> </td>
<td width="87%" colspan="2" class="descPROD">
<a href="ficha_productos.php?PKID=<?php echo $prod['PKID']; ?>"><?php echo $prod['nombre']; }?> </a></td>
</tr>
</table>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> </th>
</tr>
<tr>
<th scope="col"> </th>
</tr>
</table>
<p> </p>
<?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="5%" scope="col"> </th>
<th colspan="2" scope="col"><div align="left"><?php echo $row_Recordset7['nombre']; ?></div></th>
</tr>
<?php mysql_select_db($database_listproduc, $listproduc);
$query_Recordset8 = "SELECT * FROM producto WHERE PKIDCAT =".$row_Recordset7['PKID'];
$Recordset8 = mysql_query($query_Recordset8, $listproduc) or die(mysql_error());
$totalRows_Recordset8 = mysql_num_rows($Recordset8);
while($produc=mysql_fetch_assoc($Recordset8)){?>
<tr>
<th scope="row"> </th>
<td width="8%" scope="row"> </td>
<td width="87%" scope="row"><a href="ficha_productos.php?PKID=<?php echo $prod['PKID']; ?>"><?php echo $produc['nombre']; }?> </a></td>
</tr>
</table>
<?php } while ($row_Recordset7 = mysql_fetch_assoc($Recordset7)); ?><p>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset7);
mysql_free_result($Recordset8);
?>
</p>
<p>ifhefhr</p>
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Alguien podria ayudarme? aqui les dejo el codigo
<?php require_once('Connections/listproduc.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset1 = "SELECT * FROM categoria WHERE id_marca = 0";
$Recordset1 = mysql_query($query_Recordset1, $listproduc) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset7 = "SELECT * FROM categoria WHERE id_marca = 1";
$Recordset7 = mysql_query($query_Recordset7, $listproduc) or die(mysql_error());
$row_Recordset7 = mysql_fetch_assoc($Recordset7);
$totalRows_Recordset7 = mysql_num_rows($Recordset7);
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset8 = "SELECT * FROM producto WHERE PKIDCAT =".$row_Recordset1['PKID'];
$Recordset8 = mysql_query($query_Recordset8, $listproduc) or die(mysql_error());
$row_Recordset8 = mysql_fetch_assoc($Recordset8);
$totalRows_Recordset8 = mysql_num_rows($Recordset8);
?>
<p>jdhehdfhekdhke</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th scope="col"> </th>
</tr>
<tr>
<th scope="col"><?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td colspan="2" class="tituloPROD"><?php
echo $row_Recordset1['nombre']; ?> </td>
</tr>
<?php mysql_select_db($database_listproduc, $listproduc);
$query_Recordset2 = "SELECT * FROM producto WHERE PKIDCAT =".$row_Recordset1['PKID'];
$Recordset2 = mysql_query($query_Recordset2, $listproduc) or die(mysql_error());
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
while($prod=mysql_fetch_assoc($Recordset2)){?>
<tr>
<td> </td>
<td width="8%"> </td>
<td width="87%" colspan="2" class="descPROD">
<a href="ficha_productos.php?PKID=<?php echo $prod['PKID']; ?>"><?php echo $prod['nombre']; }?> </a></td>
</tr>
</table>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> </th>
</tr>
<tr>
<th scope="col"> </th>
</tr>
</table>
<p> </p>
<?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="5%" scope="col"> </th>
<th colspan="2" scope="col"><div align="left"><?php echo $row_Recordset7['nombre']; ?></div></th>
</tr>
<?php mysql_select_db($database_listproduc, $listproduc);
$query_Recordset8 = "SELECT * FROM producto WHERE PKIDCAT =".$row_Recordset7['PKID'];
$Recordset8 = mysql_query($query_Recordset8, $listproduc) or die(mysql_error());
$totalRows_Recordset8 = mysql_num_rows($Recordset8);
while($produc=mysql_fetch_assoc($Recordset8)){?>
<tr>
<th scope="row"> </th>
<td width="8%" scope="row"> </td>
<td width="87%" scope="row"><a href="ficha_productos.php?PKID=<?php echo $prod['PKID']; ?>"><?php echo $produc['nombre']; }?> </a></td>
</tr>
</table>
<?php } while ($row_Recordset7 = mysql_fetch_assoc($Recordset7)); ?><p>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset7);
mysql_free_result($Recordset8);
?>
</p>
<p>ifhefhr</p>
8
PHP / menu de navegacion AYUDA!!!!
« en: 29 de Octubre de 2007, 16:38:14 pm »
Saludos tngo una duda y quisiera saber quien me puede ayudar a hacer un menu de navegacion como por ejemplo el q tiene el foro q t va indica ndo la pagina anterior de la q vienes
Comunidad PHPeros > Programacion WEB > Dudas PHP & MySQL > Crear nuevo tema ... alguien podria ayudarme???
Comunidad PHPeros > Programacion WEB > Dudas PHP & MySQL > Crear nuevo tema ... alguien podria ayudarme???
9
PHP / Re: [AYUDA] Error al aplicar vinculo
« en: 01 de Octubre de 2007, 18:39:16 pm »
cuando trato de modificar esos me da parse error ... no entiendo donde se me estan escapando los datos!!!!
10
PHP / [AYUDA] Error al aplicar vinculo
« en: 01 de Octubre de 2007, 17:09:56 pm »
Saludos ... tngo el siguiente problema, tngo un catalogo de productos donde me muestra el listado ordenado por categorias... ahora bien, cuando asigno vinculos a la variable me da o parse error... o me vincula a partir del tercer articulo... de verdad no se donde tngo el error.. aqui les dejo mi codigo para ver si alguien puede hecharme una mano..
gracias
<?php require_once('Connections/listproduc.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset1 = "SELECT * FROM categoria";
$Recordset1 = mysql_query($query_Recordset1, $listproduc) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php do { ?>
<table width="61%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td colspan="2"><?php
</tr>
<?php mysql_select_db($database_listproduc, $listproduc);
<td> </td>
<td> </td>
<td>
</a></td>
</tr>
</table>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></body>
</html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
gracias
<?php require_once('Connections/listproduc.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset1 = "SELECT * FROM categoria";
$Recordset1 = mysql_query($query_Recordset1, $listproduc) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php do { ?>
<table width="61%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td colspan="2"><?php
echo $row_Recordset1['nombre']; ?> </td>
</tr>
<?php mysql_select_db($database_listproduc, $listproduc);
$query_Recordset2 = "SELECT * FROM producto WHERE PKIDCAT =".$row_Recordset1['PKID'];
$Recordset2 = mysql_query($query_Recordset2, $listproduc) or die(mysql_error());
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
while($prod=mysql_fetch_assoc($Recordset2)){?>
<tr>
<td> </td>
<td> </td>
<td>
<a href="ficha.php?PKID">
<?php echo $prod['nombre']; }?>
</a></td>
</tr>
</table>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></body>
</html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
11
PHP / Re: AYUDA: problema mostrando productos
« en: 28 de Septiembre de 2007, 22:43:42 pm »
ahora dandole vinculo me dice parse error en linea 84 q es la ultima :S:S
<?php require_once('Connections/listproduc.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset1 = "SELECT * FROM categoria";
$Recordset1 = mysql_query($query_Recordset1, $listproduc) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php do { ?>
<table width="61%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td colspan="2"><?php
</tr>
<?php mysql_select_db($database_listproduc, $listproduc);
<td> </td>
<td> </td>
<td>
</a>
</td>
</tr>
</table>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></body>
</html>
<?php } ?>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
<?php require_once('Connections/listproduc.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset1 = "SELECT * FROM categoria";
$Recordset1 = mysql_query($query_Recordset1, $listproduc) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php do { ?>
<table width="61%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td colspan="2"><?php
echo $row_Recordset1['nombre']; ?> </td>
</tr>
<?php mysql_select_db($database_listproduc, $listproduc);
$query_Recordset2 = "SELECT * FROM producto WHERE PKIDCAT =".$row_Recordset1['PKID'];
$Recordset2 = mysql_query($query_Recordset2, $listproduc) or die(mysql_error());
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
while($prod=mysql_fetch_assoc($Recordset2)){?>
<tr>
<td> </td>
<td> </td>
<td>
<a href="ficha_prod.php?PKID=<?=$prod['PKID']?>">
<?=$prod['nombre'];?>
</a>
</td>
</tr>
</table>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></body>
</html>
<?php } ?>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
12
PHP / Re: AYUDA: problema mostrando productos
« en: 28 de Septiembre de 2007, 22:19:52 pm »
mmmmm elimine ese codigo y listo... me detecto desde el primero.... gracias man!!!!!
13
PHP / Re: AYUDA: problema mostrando productos
« en: 28 de Septiembre de 2007, 22:07:56 pm »
PKIDCAT es de la tabla productos.... donde PKIDCAT de productos = PKID de la tabla categorias!!!!!... ahora lo q no entiendo es por q se me muestran a partir del segundo producto.!!!!
14
PHP / AYUDA: problema mostrando productos
« en: 28 de Septiembre de 2007, 21:51:32 pm »
Necesito ayuda urgente pls... tngo un listado de productos pero el problema es q solo me muestra a partir del segundo producto... o sea el primero q sale ingresado en la data jamas sale!!!! alguien puede decirme el error?
pero es el primero de cada categoria ejemplo
en la base de datos tngo
de la categoria
zapato
tngo lso prodcutos
1- rojo
2- negro
3- azul
solo me salen negro y azul.... el rojo q es el primero de esa categoria no me sale
gracias!!!
<?php require_once('Connections/listproduc.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset1 = "SELECT * FROM categoria";
$Recordset1 = mysql_query($query_Recordset1, $listproduc) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php do { ?>
<table width="61%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td colspan="2"><?php
</tr>
<tr>
<td> </td>
<td width="5%"> </td>
<td width="90%"><?php
</tr>
</table>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></body>
</html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
solo se me muestra los resultados a partir del segundo pero no entiendo por que :S
pero es el primero de cada categoria ejemplo
en la base de datos tngo
de la categoria
zapato
tngo lso prodcutos
1- rojo
2- negro
3- azul
solo me salen negro y azul.... el rojo q es el primero de esa categoria no me sale
gracias!!!
<?php require_once('Connections/listproduc.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset1 = "SELECT * FROM categoria";
$Recordset1 = mysql_query($query_Recordset1, $listproduc) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php do { ?>
<table width="61%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5%"> </td>
<td colspan="2"><?php
echo $row_Recordset1['nombre']; ?></td>
</tr>
<tr>
<td> </td>
<td width="5%"> </td>
<td width="90%"><?php
mysql_select_db($database_listproduc, $listproduc);
$query_Recordset2 = "SELECT * FROM producto WHERE PKIDCAT =".$row_Recordset1['PKID'];
$Recordset2 = mysql_query($query_Recordset2, $listproduc) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
while($prod=mysql_fetch_assoc($Recordset2)){
echo $prod['nombre']; }?></td>
</tr>
</table>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></body>
</html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
solo se me muestra los resultados a partir del segundo pero no entiendo por que :S
15
PHP / Re: AYUDA Variables Flash a PHP
« en: 20 de Septiembre de 2007, 22:27:33 pm »
vale.... gracias!