I want to find a string in many rows of MySQL table and return a value in a different column on the same row.
Does that make sense? Essentially I want to search for A and return B
I know how to connect and close connections for starters. Just not familiar with querys. Thanks
Ok, I solved it after looking harder. I swear google is not my friend when looking up at things like this. This is what I did for anybody elses referance.
@mysql_select_db($database) or die( "Unable to select database");
$search = $_GET['search'];
$query = mysql_query("SELECT * FROM Table1 WHERE Field2 LIKE '%$search%' LIMIT 0, 30 ");
while ($row = mysql_fetch_array($query))
You must be logged in to reply to this topic.