[SOLVED] parse error

[cs1h]

Hi,

I'm getting the following error from my php script,

 

Parse error: syntax error, unexpected ')' in D:\Inetpub\vhost\myroho.com\httpdocs\asearching.php on line 10

 

and the code is

 

<?

//connect to your database ** EDIT REQUIRED HERE **
mysql_connect("localhost","adder","clifford"); //(host, username, password)

//specify database ** EDIT REQUIRED HERE **
mysql_select_db("real") or die("Unable to select database"); //select which database we're using

$keywords = preg_split("/[\s,]+/", trim($_POST['keyword']));
$sql = "SELECT * FROM items WHERE country='" . mysql_real_escape_string($_POST['menuFilesDMA']=) . "' AND type='" . mysql_real_escape_string($_POST['Type']=) . "' AND Abstract LIKE '%" . implode('%', $keyword) . "%'";
}
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
if($num_rows == 0) {
echo "No results<BR>n";
} else {
while($row = mysql_fetch_array($result)) {
echo "{$row['somefield']}<BR>n";
}
}
?> 

 

I'm new to php and I can't find whats wrong with it.

 

Any help would be much appriciated (even if someone can tell me if they think this script will work),

 

Thanks

Colin

[MadTechie]

why do you have the ='s and } ?

 

see comments

$sql = "SELECT * FROM items WHERE country='" . mysql_real_escape_string($_POST['menuFilesDMA']=) . "' AND type='" . mysql_real_escape_string($_POST['Type']=) . "' AND Abstract LIKE '%" . implode('%', $keyword) . "%'"; // why the ='s ?
} //<-- whats this for ?

[cs1h]

Thanks for the reply,

 

I removed the } but I am not sure what you mean by the ='s

 

Thanks

Colin

[MadTechie]

from

$sql = "SELECT * FROM items WHERE country='" . mysql_real_escape_string($_POST['menuFilesDMA']=) . "' AND type='" . mysql_real_escape_string($_POST['Type']=) . "' AND Abstract LIKE '%" . implode('%', $keyword) . "%'"; // why the ='s ?

to

$sql = "SELECT * FROM items WHERE country='" . mysql_real_escape_string($_POST['menuFilesDMA']) . "' AND type='" . mysql_real_escape_string($_POST['Type']) . "' AND Abstract LIKE '%" . implode('%', $keyword) . "%'"; 

[cs1h]

Hi,

 

That new code worked but I am now getting a new error,

 

Warning: implode() [function.implode]: Bad arguments. in D:\Inetpub\vhost\myroho.com\httpdocs\asearching.php on line 10

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Inetpub\vhost\myroho.com\httpdocs\asearching.php on line 13

No results

n

 

Any help is much appriciated,

 

Thanks, Colin

[MadTechie]

OK what is

$keyword ? a string or an array ?

do a var_dump($keyword); see what it displays

 

as for the 2nd error

change

$result = mysql_query($query);

to

$result = mysql_query($sql);

[cs1h]

I made the change in the second surgestion and it removed the second error.

 

I think $keyword is a string because it comes from a text box (unless I misunderstand what a string is), I am not sure what you mean by do a var_dump($keyword);

 

Thanks

Colin

 

The only message I get now is

Warning: implode() [function.implode]: Bad arguments. in D:\Inetpub\vhost\myroho.com\httpdocs\asearching.php on line 10

 

[MadTechie]

OK if its a string i *think* your trying to do this

 

$sql = "SELECT * FROM items WHERE country='" . mysql_real_escape_string($_POST['menuFilesDMA']) . "' AND type='" . mysql_real_escape_string($_POST['Type']) . "' AND Abstract LIKE '%$keyword%'"; 

 

 

[cs1h]

Thanks for all your help MadTechie, it seems to be working now.

 

Cheers Colin