Re: [PHP] writing to mysql using php
You're limited to one action per statement, not one record.
Using "UPDATE ... WHERE", you can update any number of rows
with a single SQL statement.
--
Scott Hurring
Systems Programmer
EAC Corporation
scott (*) eac.com
--
"Hugh Danaher" <[EMAIL PROTECTED]> wrote in message
001301c29fc8$b20f06c0$0100a8c0@win95">news:001301c29fc8$b20f06c0$0100a8c0@win95...
> Shams,
> Most database actions you want your user to do should be limited to them
> writing to one record and/or updating that one record. If instead you want
> to update information on several records, then you'd need a statement like:
> $table="your_table_name";
> $query=mysql_query("update $table set column_name='what ever' where
> other_column_name='something else'");
> Hope this helps,
> Hugh
>
> - Original Message -
> From: "Enrique Garcia Briones" <[EMAIL PROTECTED]>
> To: "Shams" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, December 09, 2002 12:10 PM
> Subject: RE: [PHP] writing to mysql using php
>
>
> > If there were no more replies... you can use it by means of BUCLES, isn't
> > it?
> >
> > BR, Enrique
> >
> > -Mensaje original-
> > De: Shams [mailto:[EMAIL PROTECTED]]
> > Enviado el: Martes, 03 de Diciembre de 2002 04:32 a.m.
> > Para: [EMAIL PROTECTED]
> > Asunto: [PHP] writing to mysql using php
> >
> >
> > Hi,
> >
> > I'm relatively new to PHP and mySQL.
> >
> > I currently have a simple table created within a MySQL database. And I
> have
> > a php script that connects to the database, presents a form for the user
> to
> > fill in, and then writes that record to the table.
> >
> > Instead... is it possible, to write to multiple records at once using a
> > tabular view rather than one record at a time with a columnar view ?
> >
> > Many Thanks,
> >
> > Shams
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] writing to mysql using php
Shams,
Most database actions you want your user to do should be limited to them
writing to one record and/or updating that one record. If instead you want
to update information on several records, then you'd need a statement like:
$table="your_table_name";
$query=mysql_query("update $table set column_name='what ever' where
other_column_name='something else'");
Hope this helps,
Hugh
- Original Message -
From: "Enrique Garcia Briones" <[EMAIL PROTECTED]>
To: "Shams" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 12:10 PM
Subject: RE: [PHP] writing to mysql using php
> If there were no more replies... you can use it by means of BUCLES, isn't
> it?
>
> BR, Enrique
>
> -Mensaje original-
> De: Shams [mailto:[EMAIL PROTECTED]]
> Enviado el: Martes, 03 de Diciembre de 2002 04:32 a.m.
> Para: [EMAIL PROTECTED]
> Asunto: [PHP] writing to mysql using php
>
>
> Hi,
>
> I'm relatively new to PHP and mySQL.
>
> I currently have a simple table created within a MySQL database. And I
have
> a php script that connects to the database, presents a form for the user
to
> fill in, and then writes that record to the table.
>
> Instead... is it possible, to write to multiple records at once using a
> tabular view rather than one record at a time with a columnar view ?
>
> Many Thanks,
>
> Shams
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] writing to mysql using php
If there were no more replies... you can use it by means of BUCLES, isn't it? BR, Enrique -Mensaje original- De: Shams [mailto:[EMAIL PROTECTED]] Enviado el: Martes, 03 de Diciembre de 2002 04:32 a.m. Para: [EMAIL PROTECTED] Asunto: [PHP] writing to mysql using php Hi, I'm relatively new to PHP and mySQL. I currently have a simple table created within a MySQL database. And I have a php script that connects to the database, presents a form for the user to fill in, and then writes that record to the table. Instead... is it possible, to write to multiple records at once using a tabular view rather than one record at a time with a columnar view ? Many Thanks, Shams -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
