I have a search form from which I hope to be able to select a record by
field JobNumber and display it with an output form titled test.php
<html>
<head>
<title>Job Database Search</title>
</head>
<body style='font-family: Geneva, Arial, Helvetica, sans-serif;'>
Enter Job Number:
<form action="test.php" method="post">
<input type="text" name="searchterm">
<input type="submit" name="Send">
</form>
</body>
</html>
The query on the output form (test.php) is as follows and returns a blank
output:
$query="select * from jobs where JobNumber like '$searchterm'";
The problem I'm having is that the searchterm variable does not appear to
be passing to the output form. I know that I am connecting to the database
and that the query is fundamentally correct because I can access the record
I want by substituting a real Job Number for the variable.
Any ideas?