So, I have a moderately large database of customer names that is searchable via a PHP form. Right now it is set up with one form input to search the table.
How would I go about setting it up with two inputs, one for first name and one for last? Do I have to set up separate forms for each text input?

Originally Posted by werm82

How would I go about setting it up with two inputs, one for first name and one for last?

Add another field for searching using your current methodology and update the quires.

Originally Posted by werm82

Do I have to set up separate forms for each text input?

No.

Forgive me for being naive to PHP (I'm a designer, so I took up javascript instead ) But this is what I have for my code at the moment. Would I have to change SELECT * to SELECT col_name? And would I integrate it into what I currently have now, or create another SELECT statement? I guess I know what needs to be done, but I'm having trouble translating it from English to PHP. If I'm being too dense, just say so.

PHP Code:

if (isset($_POST['last_name'])) {
  $colname_Recordset1 = $_POST['last_name'];
}
mysql_select_db($database_db, $db);
$query_Recordset1 = sprintf("SELECT * FROM db WHERE last_name LIKE %s", GetSQLValueString("%" . $colname_Recordset1 . "%", "text"));
$Recordset1 = mysql_query($query_Recordset1, $db) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$colname_Recordset1 = "-1"; 


In your query string you can see

where last_name LIKE %s

The rest of the string looks funny to me

But if I was doing it I would use something like

where last_name LIKE %s AND first_name LIKE %s

If that makes sense

Check out this tutorial it covers what you want to do

http://www.w3schools.com/SQl/sql_like.asp

You can use one form and do something like..

PHP Code:

$myand = "";

if ($_POST["last"])
{
$last = $_POST["last"];
$myand .= " AND lastname LIKE '%$last%'";
}

if ($_POST["city"])
{
$city = $_POST["city"];
$myand .= " AND city LIKE '%$city%'";
}
$query = "SELECT * FROM blah where firstname = '$first' $myand"; 


I almost got it! I tried

PHP Code:

$query_rsSearch = sprintf("SELECT * FROM admins WHERE Last_Name LIKE %s AND First_Name LIKE %s", GetSQLValueString($colname_rsSearch, "text")); 


But when I ran a search, I got a sprintf error,
Warning: sprintf() [function.sprintf]: Too few arguments in C:\wamp\www\admins\search.php on line 39
Query was empty
The same thing happens when I replace AND with OR. And what the hell is sprintf anyway?

You got me on that one Sorry.

You only have the sprintf parameter for the first %s (last name), not the last %s. Add in the parameter for first name.