I don't pretend to know flashes interface, as I said before - but instead of naming 
the variables differently - you should be able to pass them in an array.


Assuming flash accepts the parameters in this form.  You'll want to make sure you emit 
every variable each time, otherwise your data sets will get out of sync (emit them 
even if they're blank) - but I still say there surely must be a better way to be 
populating this data.


Seems to be an introductory that may be of some use, found just by googling for 'flash 
php mysql'.

- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent those of St. 
Jude Children's Research Hospital.

-----Original Message-----
From: Juan Stiller [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 20, 2004 11:27 AM
Subject: [PHP-DB] Changing this php code to show multiple variables!

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: 


So here it is the php code:

$conn = @mysql_connect("***", "***", "***");

if (!$conn) {
echo( "<P>No se pudo conectar " .
"al servidor MySQL.</P>" );

if (! @mysql_select_db("clientes") ) {
echo( "<P>No se puede encontrar " .
"la base de datos clientes!</P>" );

// Request all data
$result1 = mysql_query("select * from

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']}";

Can anyone help me with this?


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

Reply via email to