Thanks


----- Original Message -----
From: "ERISEN, Mehmet Kamil" <[EMAIL PROTECTED]>
To: "Dave.O" <[EMAIL PROTECTED]>; "Martín_Marqués"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, August 18, 2001 12:42 AM
Subject: Re: [PHP] Adding records to a MySql database


> Here is how this is done:
>
> $sql = "insert into employees
>         values ('10','John','Smith','Engineer') ";
> $result = mysql_query($sql) or die ('Insert failed');
>
> with php, you can execute any SQL statement as long as you
> have access...
>
> to update a table
>
> $sql = "update employees
>         set job = 'Chief Engineer'
>         where employee_id = '10' ";
> $result = mysql_query($sql) or die ('Update failed');
>
> hope this helps,
> ultrAslan
>
> --- "Dave.O" <[EMAIL PROTECTED]> wrote:
> > I was looking for the command something like mysql_insert
> > or something, just
> > found dba_insert() is this it ?!?
> >
> > ----- Original Message -----
> > From: "Martín Marqués" <[EMAIL PROTECTED]>
> > To: "Dave.O" <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Saturday, August 18, 2001 12:23 AM
> > Subject: Re: [PHP] Adding records to a MySql database
> >
> >
> > > On Vie 17 Ago 2001 20:14, Dave.O wrote:
> > > > I have read the documentation already.
> > > >
> > > > I am trying to create a directory, which information
> > can be added and
> > > > maintained through a the web browser.  I thought that
> > using a MySql
> > > > database would be a good idea rather than writing it
> > all to a file.  You
> > > > saying that MySql is a waste of time for this ?
> > > >
> > > > I thought that PHP can be used to add records etc and
> > query databases
> > for
> > > > this
> > >
> > > You said that all you found were functions to query
> > information. Thats all
> > > you need with an SQL database.
> > > The main SQL query commands are: SELECT, UPDATE, DELETE
> > and INSERT. With
> > > those 4 comands you can read, insert and modify (also
> > delete) the
> > information
> > > on your database.
> > >
> > > Hope you understand know.
> > >
> > > Saludos... :-)
> > >
> > > --
> > > Porqué usar una base de datos relacional cualquiera,
> > > si podés usar PostgreSQL?
> > >
> >
> -----------------------------------------------------------------
> > > Martín Marqués                  |
> > [EMAIL PROTECTED]
> > > Programador, Administrador, DBA |       Centro de
> > Telematica
> > >                        Universidad Nacional
> > >                             del Litoral
> > >
> >
> -----------------------------------------------------------------
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail:
> > [EMAIL PROTECTED]
> > > For additional commands, e-mail:
> > [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
> > [EMAIL PROTECTED]
> > >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail:
> > [EMAIL PROTECTED]
> > For additional commands, e-mail:
> > [EMAIL PROTECTED]
> > To contact the list administrators, e-mail:
> > [EMAIL PROTECTED]
> >
>
>
> =====
> Mehmet Erisen
> http://www.erisen.com
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to