Sorry i forgot to change the email address so you
received this message on your personal mail. Sorry for
that!
You re right, i was mistaken, its showing the first
record, and you said im not making php show all, what
modifications should i insert in the code to make it
show all results? But anyway, when i test the file on
my browser, muestradevvars.php it shows all results,
but on flash it only shows the first record.
I just can´t find a proper flash tutorial.
--- "Norland, Martin" <Martin.Norland@xxxxxxxxxx>
escribió:
> No, sorry - I haven't ever had to use flash, let
> alone use it to interface to php.
>
> Check which result flash is seeing - is it only
> seeing the first, or is it only seeing the last? It
> looks like you're building a query string to pass to
> it, but you're not presently setting the data as
> arrays (e.g.
> "&Apellido[]={$row['appellidoclientesnuevos']}") -
> which would mean it only gets to see one result set.
>
> However, you don't want to be passing the entire
> results of your database query in a $_GET string to
> this flash script - if that is what you're doing -
> there is certainly a better/preferred way to get
> this info into flash.
>
> - 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:juanstiller@xxxxxxxxxxxx]
>
> Sent: Monday, October 18, 2004 1:25 PM
> To: php-db@xxxxxxxxxxxxx
> Subject: RE: Showing all mysql query
> results!
>
>
> Ok, i just followed your advice for make the code
> easier to read, it looks good, and yes it works ok
> too.
>
> I´ve tried it, and yes it shows more than 1 entry,
> but
> i cant make flash to show them, im sure something on
> flash must be wrong or missing, there is no fault on
> the php code, so i might research a little more on
> the
> flash part.
>
> Do you know some good tutorial for this?
>
> Thanks for your response.
>
>
> Juan.
>
>
> --- "Norland, Martin" <Martin.Norland@xxxxxxxxxx>
> escribió:
> >
> > A quick glance says that's all perfectly right, I
> > would run the query on the mysql command line to
> be
> > sure it's really giving more than 1 result - but I
> > can suggest two things:
> >
> > 1) be sure to mysql_free_result($result)
> afterwards
> > if you're done with the query but your script will
> > still be doing anything. You really do want to do
> > that because it tells mysql you're done with that
> so
> > it can release the memory - PHP doesn't actually
> use
> > the memory for that resultset, it just holds a
> > result id that it uses to get the results from
> mysql
> > (so best to let mysql have its memory back as soon
> > as you're done).
> >
> > 2) you will save yourself a fair amount of effort
> > and readability, if you don't need those variables
> > other than to print, to change things like so:
> > ---------------
> > $apellido=$row["apellidoclientesnuevos"];
> > echo "&Apellido=$apellido";
> > --- becomes ---
> > echo
> "&Apellido={$row['appellidoclientesnuevos']}";
> > ---------------
> > (you don't need to use ', " works too - I find '
> > more legible here)
> >
> > This may also reduce confusion if you start
> thinking
> > that the database field is holding just names,
> > instead of names of new clients (e.g. you
> > accidentally paste it elsewhere for use and keep
> > pulling only from the new clients table).
> >
> > Are you perhaps storing clients in that table
> > temporarily, so it rarely has many clients in it?
> > That could explain the behaviour as well.
> >
> > - 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:juanstiller@xxxxxxxxxxxx]
> >
> > Sent: Monday, October 18, 2004 11:07 AM
> > To: php-db@xxxxxxxxxxxxx
> > Subject: Showing all mysql query results!
> >
> >
> > Hi, im using this script, to show all entrys of a
> > mysql database on a flash movieclip, but i was
> told
> > at
> > flash forums, that this code is not ok, because
> its
> > showing only the last entry not all of them, maybe
> > you
> > someone can recommend what to add to this little
> > script?.
> >
> >
> > <?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))
> > {
> > $id=$row["id"];
> > echo "&Id=$id";
> > $apellido=$row["apellidoclientesnuevos"];
> > echo "&Apellido=$apellido";
> >
> > $nombre=$row["nombreclientesnuevos"];
> > echo "&Nombre=$nombre";
> >
> > $dni=$row["dniclientesnuevos"];
> > echo "&Dni=$dni";
> >
> > $telefono=$row["telefonoclientesnuevos"];
> > echo "&Telefono=$telefono";
> >
> > $dia=$row["diacitaclientesnuevos"];
> > echo "&Dia=$dia";
> >
> > $mes=$row["mescitaclientesnuevos"];
> > echo "&Mes=$mes";
> >
> > $ano=$row["anocitaclientesnuevos"];
> > echo "&Ano=$ano";
> >
> > $hora=$row["horacitaclientesnuevos"];
> > echo "&Hora=$hora";
> >
> > $minutos=$row["minutoscitaclientesnuevos"];
> > echo "&Minutos=$minutos";
> >
> > $abogado=$row["abogadoclientesnuevos"];
> > echo "&Abogado=$abogado";
> >
> > $asunto=$row["asuntoclientesnuevos"];
> > echo "&Asunto=$asunto";
> >
> > $donde=$row["dondeclientesnuevos"];
> > echo "&Donde=$donde";
> > }
> > ?>
> >
> > Thanks
> > Emilio
> >
> >
> >
> >
> >
> >
>
=== message truncated ===
___________________________________
¡Llevate a Yahoo! en tu Unifón!
Ahora podés usar Yahoo! Messenger en tu Unifón, en cualquier momento y lugar.
Encontrá más información en: http://ar.mobile.yahoo.com/sms.html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
