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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > is anyone away of any tutorials as I'm having difficulty constructing the > remainder of my code. Thanks for the replies! > "Paul Duggan" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > 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! > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php