RE: Changing this php code to show multiple variables!

"Bastien Koert" <bastien_k@xxxxxxxxxxx> · Wed, 20 Oct 2004 13:37:13 -0400

http://flashkit.com/board/showthread.php?s=95608f8e3b6478833f8e42171424bf7f&threadid=505071&highlight=pass+php+array

is a discussion about php and flash....the poster 'argonauta' recommend the 
use of xml, otherwise the solution is to use individual elements for key 
value pair

bastien

From: Juan Stiller <juanstiller@xxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject:  Changing this php code to show multiple variables!
Date: Wed, 20 Oct 2004 13:27:17 -0300 (ART)

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/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php