Thanks
----- Original Message -----
From: "Martín Marqués" <[EMAIL PROTECTED]>
To: "Dave.O" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, August 18, 2001 12:43 AM
Subject: Re: [PHP] Adding records to a MySql database
> On Vie 17 Ago 2001 20:39, Dave.O wrote:
> > No offence but you are telling me stuff I already know ! This mailing
> > list is very good so dont take offence due to my frustration. I know
how
> > to connect to the server, create the database and more or less query it,
> > but cant find the command to add/insert records or am I doing something
> > very wrong. I presume this can be done in php
>
> I don't use MySQL, but I'll give you an example.
>
> Lets say you have a table in your database like this:
>
> col1 INT (autoincremental)
> col2 VARCHAR(50)
>
> and say the name of the table is tab1
>
> if you want to insert a new row with value 'Dave the great!' whihc is
loaded
> in the $var1 variable, you just have to do this:
>
> $query="INSERT INTO tab1 (col2) VALUES (" . $var1 . ")";
>
> query_func($query);
>
> All this after you have connected to the database with the connection
> function of the MySQL extension.
>
> So, if the query went OK, you have a new record in the database with some
> value in the col1 (integer type) and 'Dave the great!' in col2.
>
> Undestand?
>
> --
> 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]