Ok if have some code that i am trying to add to.
<form action="#" method="post" enctype="multipart/form-data">
<input type="text" name="search"/>
<input type="submit" name="search1"/>
</form>
<?php
if(isset($_POST['search1'])){
$search=mysql_real_escape_string($_POST['search']);
}
include 'connect.php';
if(isset($_POST['search1'])){
$query=mysql_query("SELECT * FROM media WHERE
extra_cred LIKE '%".$search."%' OR
artist_id LIKE '%".$search."%' OR
title LIKE '%".$search."%' OR
content LIKE '%".$search."%' OR
detail LIKE '%".$search."%' OR
tags LIKE '%".$search."%' OR
user LIKE '%".$search."%' OR
type LIKE '%".$search."%'
")
?>
What I would like to do is also search another table within that database by the name of artists with the same POST data. Anyone know what to do? I've been at this for a while.