Changing this php code to show multiple variables!
| From: | Juan Stiller | Date: | Wed, 20 Oct 2004 16:27:17 +0000 |
| Subject: | Changing this php code to show multiple variables! | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36928@lists.php.net to get a copy of this message | ||
Hi, i´ve got this php code that sends a query to a
mysql server, and when it gets the query results, it
send it to a flash movieclip, everything works fine
when i´ve got only one entry on the database, but when
there´s more than one enrty, the variable is
overwritten and as reslt, it shows only one entry i
was told that i must create a function to to name
multiple variables, so the result might be:
&Lastname0=craw&Firstname0=david&Lastname1=Zarlanga&Firstname1=John
So here it is the php code:
<?php
$conn = @mysql_connect("***", "***", "***");
if (!$conn) {
echo( "<P>No se pudo conectar " .
"al servidor MySQL.</P>" );
exit();
}
if (! @mysql_select_db("clientes") ) {
echo( "<P>No se puede encontrar " .
"la base de datos clientes!</P>" );
exit();
}
// Request all data
$result1 = mysql_query("select * from
clientesnuevos");
print "Results=";
echo "<h1>Clientes agregados:</h1><br>";
while($row=mysql_fetch_array($result1, MYSQL_ASSOC))
{
echo "&Id={$row['id']}";
echo "&Apellido={$row['apellidoclientesnuevos']}";
echo "&Nombre={$row['nombreclientesnuevos']}";
echo "&Dni={$row['dniclientesnuevos']}";
echo "&Telefono={$row['telefonoclientesnuevos']}";
echo "&Dia={$row['diacitaclientesnuevos']}";
echo "&Mes={$row['mescitaclientesnuevos']}";
echo "&Ano={$row['anocitaclientesnuevos']}";
echo "&Hora={$row['horacitaclientesnuevos']}";
echo "&Minutos={$row['minutoscitaclientesnuevos']}";
echo "&Abogado={$row['abogadoclientesnuevos']}";
echo "&Nombre={$row['nombreclientesnuevos']}";
echo "&Asunto={$row['asuntoclientesnuevos']}";
echo "&Donde={$row['dondeclientesnuevos']}";
}
mysql_free_result($result1);
?>
Can anyone help me with this?
Thanks
Juan
Correo Yahoo! - 6 MB, tecnología antispam ¡gratis!
Suscribite ya http://correo.yahoo.com.ar/