Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

Krishnaswamy · 05-04-2007, 11:28 AM

Your question is very general.

Assuming you have a SQL Server database, the best practice is to create a stored procedure. This procedure can be written in such a way at run time you provide, let us say, the Customer ID, then it will fetch from the database all iformation for that particular Customer. This can be done in PHP or ASP.

Select * from Customers
where Customer ID=?

This is generally the type of query you will be using and at run time you will type-in what the ? mark is.

05-04-2007, 11:28 AM	#2 (permalink)
Krishnaswamy Junior Member Join Date: May 2007 Posts: 29	Re: Can anyone help me with this SQL query? Your question is very general. Assuming you have a SQL Server database, the best practice is to create a stored procedure. This procedure can be written in such a way at run time you provide, let us say, the Customer ID, then it will fetch from the database all iformation for that particular Customer. This can be done in PHP or ASP. Select * from Customers where Customer ID=? This is generally the type of query you will be using and at run time you will type-in what the ? mark is.