Can anyone help me with this SQL query?

[drew22299]

Hey,

I have a script written in asp and I have modified some of the SQL to search the database for specific things that I have specified in WHERE.

How would I write an SQL query in Php or asp to search the database based on the user input? for example, if the user types in the name of a town or city and make it search the fields in the database based on what they typed?

Thanks!

[Krishnaswamy]

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.

[drew22299]

I understand that and I know what the code needs to do but I don't know the syntax etc, which is why I posted a message on this forum so someone could write an example code.

[Krishnaswamy]

This is a small tutorial for you on your query questions(no pun):
This is a simpel table called Student in your database with four columns, StudentID, SFName,SLName, and DateCertified:

1 Venkat Raman 1/1/1908 12:00:00 AM
9 Jay Krishnaswamy 4/3/1941 12:00:00 AM
22 Nicole Kidman 4/5/2000 12:00:00 AM
23 John Pollack 1/1/2000 12:00:00 AM
--------------------------
This is a simple well known "SELECT" query
----------------------------
select SFname, SLName
from Student
where StudentID='9'
This gives the result
Jay Krishnaswamy------------------------------
Create a stored proc (testing)which shows all data in the table:
create proc testing as
select SFName, SLName
from Student
--------------------------------
Now the code you wantedthis creates a stored procedure newTest)
create proc newTest
@idss nchar(20)
as
select SFName, SLName
from Student
where @idss=SFName
---------------
when you run the following command:
exec newTest 'Jay'
you will get:
Jay krishnaswamy

I hope this helps.

Jay

[QvnsQ]

so the problem already fixed??