Help creating search query - very basic - sorry

[pp4sale]

I am trying to create a search box where users can insert an id number and this will take them through to a specific page.

eg can type in "12" and this will take someone through to ../info.php?id=12

Does anyone know how to do this or a tuturial that might help me.

Sorry I can't find out how to do this?

[djjjozsi]

http://www.phpcode.hu/teszt/s/search.rar

And here is the sql query to make a mysql table:
CREATE TABLE info (
info_id int(11) NOT NULL auto_increment,
information VARCHAR( 255 ) CHARACTER SET latin2 COLLATE latin2_hungarian_ci NOT NULL
,PRIMARY KEY (info_id)) ;

Here it is workin http://phpcode.hu/teszt/s/?

write into this
1

[pp4sale]

I have done it another way (see coding below), but can you not use: onclick="openURL();" rather than onclick="makeURL();" - this doesn't seem to work if I change it?

Also does anyone know how to get this form to submit when enter is pressed, it just reloads the page and if i type in type="submit" the whole form stops working. I've made this from an example in a tutorial so it may not be 100% right, although it does work - although when i click on back, the previous page doesn't always load - says page not found - only happens when I added this code??!

Any help would be greatly appreciated.

<script>
function makeURL() {
var baseURL = 'http://www.example.com/info.php?id=';

var pfxmnumber = 'mnumber=';
var mnumber = document.form1.mnumber.value;
var url = baseURL + mnumber

pfxmnumber + mnumber;
location = url;
}
</script>
<form name="form1" id="form1" method="post" action="">
<p align="center">
<font size="2" face="Arial, Helvetica, sans-serif"><b>Or</b><br> Search by ID:
<input name="mnumber" type="number" size="5" id="mnumber" value=""/><br>

<input name="Search ID" type="button" id="Search ID" value="Search ID" onclick="makeURL();" /> 

</font></p>
</form>

[djjjozsi]

<script>
function makeURL() {
var baseURL = 'http://www.example.com/info.php?id=';
var pfxmnumber = 'mnumber=';
var mnumber = document.form1.mnumber.value;
var url = baseURL + mnumber;
location = url;
}
</script>
<form name="form1" id="form1" method="post" action="">
<p align="center">
<font size="2" face="Arial, Helvetica, sans-serif"><b>Or</b><br> Search by ID:
<input name="mnumber" type="number" size="5" id="mnumber" value=""/><br>

<input name="Search ID" type="button" id="Search ID" value="Search ID" onclick="makeURL();" />
</font></p>
</form>

[pp4sale]

Thanks for that, do you know how to make it open the url when 'enter' is pressed on the id number entered.

Does it matter that it says makeURL rather than openURL? Is that why if you press back it sometimes doesn't load the previous page?

Thanks again. 😃