Re: simple php search

thanks all for the help, I substituted GET for POST in \"{$_GET['surname']}\"" figured that I needed a 2nd php file which was invoked from the submit button on the first and hey presto it works :) "Paul Duggan" <paulduggan@f2s.com> wrote in message news:20031205155436.54226.qmail@pb1.pair.com... > is anyone away of any tutorials as I'm having difficulty constructing the > remainder of my code. Thanks for the replies! > "Paul Duggan" <paulduggan@f2s.com> wrote in message > news:20031205144538.36940.qmail@pb1.pair.com... > > if I create a text box: > > > > <body> > > > > <form action="nextpage.html" method="GET" > > name="myform"> > > > > <input type="Text" name="surname" align="TOP" > > size="25"><br> > > > > <input type="Submit" value="Submit" align="MIDDLE"> > > > > </form> > > > > > > how do I go about extracting a surname from a mysql database? > > > > > > > > will it be something along the lines? > > > > select firstname,surname > > from employees > > where surname = textbox.surname; > > > > > > new to this so im trying to get my head around it, basically i just want > to > > search a mysql database by someones surname. > > > > cheers! > >