search

[Manat]

I have a search box
you enter a word in the search box

Here is the code:

if($_GET['keyword']
{
$keyword = $HTTP_GET_VARS["keyword"];
$strSQLSR = "SELECT * FROM Product WHERE Name LIKE '%".$keyword."%'";
$resultSR = mysql_query($strSQLSR) or die(mysql_error());
$iID = $row["Product_ID"];
if (!$q->doquery($db, $strSQLSR))
{
echo $keyword." Didnt work, Internal error (Error 001). <br> Please try again later.";
exit();
}
}

And product description is displayed based on $iID.
That works fine

Does anyone know what is wrong with my code?
Or is there a better way to do this?
keyword is the name of the search input type field.

It doesn't work, I get a parse error on the $resultSR = mysql_query($strSQLSR) or die(mysql_error()); line.

Thanks
MK

[bastien]

Missing brackets all over the place, loop thru resultSR is not done...

if(isset($_GET['keyword']) ){
{ 
$keyword = $HTTP_GET_VARS["keyword"]; 
$strSQLSR = "SELECT * FROM Product WHERE Name LIKE '%".$keyword."%'"; 
$resultSR = mysql_query($strSQLSR) or die(mysql_error()); 
while ($row = mysql_fetch_row($resultSR)){
  $iID = $row["Product_ID"]; 
    if (!$q->doquery($db, $strSQLSR)) 
    { 
    echo $keyword." Didnt work, Internal error (Error 001). <br>    Please try again later."; 
    exit(); 
  } //end if
}//end while
}//end if 

[Manat]

I tried echoing $iID, but it doesn't work.
Since we are doing a while loop, shouldn't $iID be an array?

Thx
MK

[bastien]

No, since we are looping thru the array

try this:

if(isset($_GET['keyword']) ){ 
{  

$keyword = $HTTP_GET_VARS["keyword"];  

$strSQLSR = "SELECT * FROM Product WHERE Name LIKE '%".$keyword."%'";  

$resultSR = mysql_query($strSQLSR) or die(mysql_error());  

if (!$resultSR))  

    {  

    echo $keyword." Didnt work, Internal error (Error 001). <br>    Please try again later.";  

    exit();  

  } //end if 

while ($row = mysql_fetch_row($resultSR)){ 
  $iID = $row["Product_ID"];  

   echo $iID."<BR>";
    }//end while 
}//end if

[Manat]

Hi,

At first, this line gave me an error:
if (!$resultSR))

{

echo $keyword." Didnt work, Internal error (Error 001). <br> Please try again later.";

exit();

} //end if

This line: if (!$resultSR)), of this code produced an error.
So I took it out, Still I get an error at the last line of the file, which is an table end tag.

The code seems fine to me, no problem whatsoever.
Yet there seems to be something wrong with.
$iId is never echoed, I just get a parse error and I don't see my footer that i phpinclude.

Please help!!

Thx
MK

[bastien]

sorry. my bad...an extra ) in the

if (!$resultSR))   //extra ) here
    {   

    echo $keyword." Didnt work, Internal error (Error 001). <br>    Please try again later.";   

    exit();   

  } //

should be

if (!$resultSR)   

    {   

    echo $keyword." Didnt work, Internal error (Error 001). <br>    Please try again later.";   

    exit();   

  } //

[Manat]

Ok, that works fine now.
But that was the least of the problem.

I still get a parse error on the last line of the file, which isn't even php, it's an html table end tag.

It maybe sounds like a looping problem?
$iID never gets echoed.

Any ideas?

Thx
mK

[bastien]

sounds like its missing an ending } somewhere...can you post the code and the exact error?

[Manat]

Well, you were right, it was an extra }.

But this line: $iID = $row["Product_ID"]; produces a warning, it says Product_ID is an undefined index, is that normal?

It does exist in the table, I did a copy and paste from the table view, so there's no typo.

After that I do a:
$strSQL = "SELECT * FROM Product WHERE Product_ID = $iID";
$q = new Query();

if (!$q->doquery($db, $strSQL))
{
echo "Internal error (Error Code 002). <br> Please try again later.";
exit();
}

And error code 002 is echoed.
And again, $iID is never echoed.

[bastien]

show all the code...undefined warnings mean that you haven't set the the value somewhere else...try single quotes instead of doubles...

the other error seems like its not processing the class function to query the db...Can't really help you there, I don't use classes in my code

[Manat]

Ok, I took out all my other code, and I will re-write it.

However, as for the snippet we were working on, $iID still doesn't echo.

But I did this:

while ($row = mysql_fetch_row($resultSR)){

$iID = $row['Product_ID'];

echo $iID."ya<BR>";
}//end while
}//end if

So although $iID is never echoed for some reason, ya is echoed for the right amount of times. Meaning if there are 4 results that should be sent back, ya is outputted 4 times, so at least the count is working good.

What I can do from here, is once $iID is echoed, I can display a number of links on this page going to the product detail page, I would just need the iID to be in the query string, which is easy, but since iID doesn't get echoed it's not possible.

Any idea why it doesn't get echoed?
thx
MK

[bastien]

mysql_fetch_row get the rows as an array, each row is an array of the elements in the resultset....You can change this to mysql_fetch_array and then it will give the proper association to get the Product ID

[Manat]

Thanks for all your help Bastien
That did the trick

I apreciate all ur help.

Thanks again

MK