My problem is I am trying to pass on some information using a form and use this information to isolate the details required using the SELECT command. I know that I am getting the information from my form but am unsure on how to retrieve the necessary data from the database.
$sql = 'SELECT * ' . ' FROM `clan_name` ' . ' WHERE 1 AND `clan_name` ' . ' LIKE \'Dr\' LIMIT 0, 30';
Where I have "Dr" i wish to replace this with the selected information from my form.