For Example:
//.....mysql connection......
$sql1="INSERT INTO Persons (FirstName, LastName, Age) VALUES
('$_POST[firstname]','$_POST[lastname]','$_POST[age]')";
if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); }
$sql2="SELECT * FROM Persons WHERE Max(person_id)");"
//....Display the result of last record ......
mysql_query("DELETE FROM Persons WHERE FirstName=' ' OR LastName=' ' ");
Is it OK practice?
OR
Use procedure for more than one continues queries.
And how to use the mysql procedure for this?
Imran Shafiq Khan
--- On Thu, 15/4/10, ya...@southcot.com <ya...@southcot.com> wrote:
From: ya...@southcot.com <ya...@southcot.com>
Subject: [php_mysql] Re: Question about MySQL Procedure??
To: php_mysql@yahoogroups.com
Date: Thursday, 15 April, 2010, 12:57
Can you give us an example of what you mean?
Charlie
--- In php_my...@yahoogrou ps.com, imran shafiq <jibreel_amin@ ...> wrote:
>
> Dear Expert
> If we use three queries one after another for example
> INSERT
> SELECT
> DELETE
> Is it OK ?or we use procedure for this and how to use it?
> Imran Shafiq Khan
[Non-text portions of this message have been removed]
