you must first connect to the mysql database,
for example
$dbhost = "localhost";
$dbuser = "DATABASE USER";
$dbpass = "DATABASE PASSWORD";
$database = "DATABASE NAME";
@mysql_connect($dbhost, $dbuser, $dbpass) or die ("Deze pagina is
tijdelijk offline.");
@mysql_select_db($database) or die ("Deze pagina is tijdelijk offline.");
after the connect you need to query the stuff
for example
$result = mysql_query("select * from table where id > 5");
while ($row = mysql_fetch_array($result))
{
echo $rij[0];
echo $rij[id];
}
/* delete query */'
$result = mysql_query("delete from table where id = 1");
$nr = mysql_affected_rows($result);
echo $nr . "rows are deleted.";
i hope you have enough info
the examples are not tested.
Jeroen Timmers.
http://www.php.net/manual/en/ref.mysql.php
----- Original Message -----
From: "Hayan Al Mamoun" <[EMAIL PROTECTED]>
To: "Jeroen Timmers" <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 12:54 PM
Subject: Re: Re: [PHP-DB] Maintain MySQL Transactions
> I have two sql statements, and I want to execute them all or
> nothing at all.
> For an example
> 1- Delete * from sometable where Id=SOMETHING
> 2- insert into OtherTable (fieldlist) values (valuelist) where
> Id=SOMETHING.
> How can I do so?????
>
>
>
>
> ________________________________________________
> Get your own "800" number
> Voicemail, fax, email, and a lot more
> http://www.ureach.com/reg/tag
>
>
> ---- On Sat, 9 Feb 2002, Jeroen Timmers ([EMAIL PROTECTED])
> wrote:
>
> > what would you like todo?
> > explain further
> >
> > Jeroen
> > ----- Original Message -----
> > From: "Hayan Al Mamoun" <[EMAIL PROTECTED]>
> > To: "PHPList (E-mail)" <[EMAIL PROTECTED]>
> > Sent: Saturday, February 09, 2002 7:51 AM
> > Subject: [PHP-DB] Maintain MySQL Transactions
> >
> >
> > > Hi, How can I maintain MySQL transactions with PHP
> > >
> > > Best Regards
> > > Hayan
> > >
> > >
> > > --
> > > 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
