Search form itemname or item ID?

PHP
1

Right now I have it where I can search for an item by name (search term), but I would also like to search by ItemID.

How can I acomplish this?

Here is my search query

$sql = mysqli_query(
    $db,
    sprintf(
        "SELECT * FROM new_equip WHERE itemname LIKE '%s'",
        '%'. $searchTerm .'%'
    )
);
2

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.