RE: [PHP-DB] Showing all mysql query results!

2004-10-18 Thread Juan Stiller
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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
> 
> Sent: Monday, October 18, 2004 1:25 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] 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" <[EMAIL PROTECTED]>
> 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:[EMAIL PROTECTED]
> > 
> > Sent: Monday, October 18, 2004 11:07 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] 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, b

RE: [PHP-DB] Showing all mysql query results!

2004-10-18 Thread Bastien Koert
check out
www.phpforflash.com
or
www.flashkit.com
bastien
From: Juan Stiller <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Showing all mysql query results!
Date: Mon, 18 Oct 2004 15:24:53 -0300 (ART)
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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
>
> Sent: Monday, October 18, 2004 11:07 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] 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?.
>
>
>  $conn = @mysql_connect("***", "***", "");
>
> if (!$conn) {
> echo( "No se pudo conectar " .
> "al servidor MySQL." );
> exit();
> }
>
> if (! @mysql_select_db("clientes") ) {
> echo( "No se puede encontrar " .
> "la base de datos clientes!" );
> exit();
> }
>
> // Request all data
> $result1 = mysql_query("select * from
> clientesnuevos");
>
> print "Results=";
> echo "Clientes agregados:";
>
> 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
>
>
>
>
>
>
> ___
> ¡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
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
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


Re: [PHP-DB] Showing all mysql query results!

2004-10-18 Thread Gabino Travassos
Have you used Flash to get PHP before? It looks like you're making your 
variables fine, but are you using a loop to check whether the variables have 
loaded? After &Donde=$donde I would add a variable: &done=1, then check in 
Flash whether done==1. If it is, all your variables have loaded into Flash, 
if not then you have to loop and wait. It doesn't happen instantaneously. It 
takes maybe 1/5 or 1/2 a second, so...


- Original Message - 
From: "Norland, Martin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 18, 2004 12:45 PM
Subject: RE: [PHP-DB] Showing all mysql query results!


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:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 1:25 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] 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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 11:07 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] 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?.

if (!$conn) {
echo( "No se pudo conectar " .
"al servidor MySQL." );
exit();
}
if (! @mysql_select_db("clientes") ) {
echo( "No se puede encontrar " .
"la base de datos clientes!" );
exit();
}
// Request all data
$result1 = mysql_query("select * from
clientesnuevos");
print "Results=";
echo "Clientes agregados:";
while($row=mysql_fetch_array($result1, MYSQL_ASSOC))
{
$id=$row["id"];
echo "&Id=$id";
$apellido=$row["apellidoclientesnuevos"];
echo "&Apellido=$apellido";
$nombre=$row["nombreclientesnuevos"];
echo "&Nombr

RE: [PHP-DB] Showing all mysql query results!

2004-10-18 Thread Norland, Martin
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:[EMAIL PROTECTED] 
Sent: Monday, October 18, 2004 1:25 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] 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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
> 
> Sent: Monday, October 18, 2004 11:07 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] 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?.
> 
> 
>  $conn = @mysql_connect("***", "***", "");
> 
> if (!$conn) {
> echo( "No se pudo conectar " .
> "al servidor MySQL." );
> exit();
> }
> 
> if (! @mysql_select_db("clientes") ) {
> echo( "No se puede encontrar " .
> "la base de datos clientes!" );
> exit();
> }
> 
> // Request all data
> $result1 = mysql_query("select * from
> clientesnuevos");
> 
> print "Results=";
> echo "Clientes agregados:";
> 
> 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"];
>

RE: [PHP-DB] Showing all mysql query results!

2004-10-18 Thread Juan Stiller
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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
> 
> Sent: Monday, October 18, 2004 11:07 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] 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?.
> 
> 
>  $conn = @mysql_connect("***", "***", "");
> 
> if (!$conn) {
> echo( "No se pudo conectar " .
> "al servidor MySQL." );
> exit();
> }
> 
> if (! @mysql_select_db("clientes") ) {
> echo( "No se puede encontrar " .
> "la base de datos clientes!" );
> exit();
> }
> 
> // Request all data
> $result1 = mysql_query("select * from
> clientesnuevos");
> 
> print "Results=";
> echo "Clientes agregados:";
> 
> 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 
> 
> 
>   
> 
>   
>   
> ___ 
> ¡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
> 
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
>  

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



RE: [PHP-DB] Showing all mysql query results!

2004-10-18 Thread Norland, Martin

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:[EMAIL PROTECTED] 
Sent: Monday, October 18, 2004 11:07 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] 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?.


No se pudo conectar " .
"al servidor MySQL." );
exit();
}

if (! @mysql_select_db("clientes") ) {
echo( "No se puede encontrar " .
"la base de datos clientes!" );
exit();
}

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

print "Results=";
echo "Clientes agregados:";

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 






___ 
¡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

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