check if query has something

[nabeels786]

SELECT * FROM reviews WHERE instr(gamename, '$search') 

is that right?

[sail3005]

this is how i do it:

mysql_query("SELECT * FROM book ORDER BY title ASC",$db);

[nabeels786]

its like a mini search thingy, i want it search the reviews for $search and return the results

[nabeels786]

any suggestions?

[nabeels786]

oh ok

that will check if that has $search in it right?

[scoutt]

correct, it will check to see if what the user entered and if it is in the database, so if

$search = table

then once it goes through it's search it then will fine any game that has table in it. that is what the % means. it can have anything before it or after it but it has to contain table.

[nabeels786]

it wont work. like it wont find anything

[scoutt]

what's the cod eyou have now?

[nabeels786]

$sql="SELECT * FROM reviews WHERE (gamename LIKE '%$search%') OR (review LIKE '%$search%') OR (name LIKE '%$search%') OR (describ LIKE '%$search%')";

                $result = mysql_query($sql);
                echo "<UL>\n";
                while ($row = mysql_fetch_array($result)) {
                    printf("<li><a href=\"viewreview.php?id=%s&system=%s\">%s</a> - by <a href=\"../forums/profile.php?mode=viewprofile&u=%s\">%s</a> - %s</li>", $row['id'], $row['system'], $row['gamename'], $row['id'], $row['name'], $row['describ']);
                }
                echo "</UL><BR>\n"; 

[scoutt]

like this.

$sql="SELECT * FROM reviews WHERE (gamename LIKE '%$search%' OR review LIKE '%$search%' OR name LIKE '%$search%' OR describ LIKE '%$search%')"; 

[nabeels786]

still wont work, no errors are returned

[scoutt]

try this and see if the select statement is ok on the ouput. also it will give an error if the result is wrong. also make sure all the categories are actually in the reviews table. Also what is the form coding that the search is coming from?

$sql="SELECT * FROM reviews WHERE (gamename LIKE '%$search%' OR review LIKE '%$search%' OR name LIKE '%$search%' OR describ LIKE '%$search%')";
              echo $sql;

                $result = mysql_query($sql);
                 if (!$result)
                {echo mysql_error($result)}

                echo "<UL>\n";
                while ($row = mysql_fetch_array($result)) {
                    printf("<li><a href=\"viewreview.php?id=%s&system=%s\">%s</a> - by <a href=\"../forums/profile.php?mode=viewprofile&u=%s\">%s</a> - %s</li>", $row['id'], $row['system'], $row['gamename'], $row['id'], $row['name'], $row['describ']);
                }
                echo "</UL><BR>\n"; 

[nabeels786]

alright i got it, thanks

i noticed it wasnt showing the SQL statement, this was the prob:

if($submit){ //check if submitted
...
}