Is there anything wrong in this code ?

[jd2007]

<?php

 

 

if  (!$name) {

        include("search.php");

        include("navbar.php");

        echo "<hr>";

        echo "<br><br>"; 

        echo "No search term given.";

        exit;

} else      {

        $namen = explode(" ", $name);

        $namenlen = count($name);

       

        if ($namenlen == 1) {

              include("connectdb.php");

              $q = mysql_query(SELECT tags FROM Searching WHERE `tags` = $namen) or die(mysql_error());

              //then for each match do

              $i=0;

              while($row = mysql_fetch_array($q))

              {

              echo $row[$i];

              }

              $i++;

        }

        else {}

       

}

 

?>

[cooldude832]

yes

 

        $namen = explode(" ", $name);

        $namenlen = count($name);

 

do you maen

        $name = explode(" ", $name);

        $namenlen = count($name);

or maybe

        $namen = explode(" ", $name);

        $namenlen = count($namen);

[jd2007]

i still get this error:

 

Parse error: syntax error, unexpected T_STRING in C:\AppServ\www\Search Feature\search_data.php on line 17

[BillyBoB]

first please use the code tags [ code ] it has a button on the message page its a #

 

<?php


if  (!$name) {
        include("search.php");
        include("navbar.php");
        echo "";
        echo "

"; 
        echo "No search term given.";
        exit();
} else       {
        $namen = explode(" ", $name);
        $namenlen = count($name);
       
        if ($namenlen == 1) {
              include("connectdb.php");
              $q = mysql_query("SELECT tags FROM Searching WHERE `tags` = $namen") or die(mysql_error());
              //then for each match do
              $i=0;
              while($row = mysql_fetch_array($q))
              {
              $i++;
              echo $row[$i];
              }
        }
        else {}
       
}
?>

 

try that code not many coding errors but the $i is creating a loop that doesnt go up till all the $row's are echoed

[jd2007]

it says :

Unknown column 'Array' in 'where clause'

 

the table is :

 

tags

page_title

info

link

 

yahooYahooA great site to search the web and hang out.www.yahoo.com