Are you writting the flash side too?
You could just return a multi-dimensional array?
$result = mysql_query();
$count = 0;
while($row = mysql_fetch_row($result)
{
$ret[$count] = $row;
$count++;
}
return $ret;
----- Original Message -----
From: Juan Stiller <juanstiller@xxxxxxxxxxxx>
Date: Wednesday, October 20, 2004 12:27 pm
Subject: 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:
>
> &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
