[RESOLVED] Problem with my search qury again

[lgefrank]

Sorry its a bit big. I'm trying to work a search query going and sort the data into table to make it nicer to view. Also I've used the strip tags funtion to get rid of unwanted code in the varible. But Ihave a problem in that all I get returned is a "]parse error, unexpected I VARIABLE on line 28". Line 28 is where my query is but I don't think its that. I can't see what I've done wrong. I've tryed formating this data like this before and it worked well. I don't see what's wrong with this code I've written. Please help me.

<?PHP
$search = $_POST["search"];

print("Searching for: $search<br>"); 

#strip search of tags
$search = strip_tags($search, "<b><i>");

#connect to MySQL
$conn=@mysql_connect("localhost")
		 	or die( "Couldn't connnect to server" );

#select the specified database
$rs = @mysql_select_db("ags", $conn) 
			or die( "Err:Db" );
#create the query 
$sql = "
	SELECT *
	FROM article 
	WHERE body like '%$search%' order by datex desc";

#execute the query
$rs = @mysql_query( $sql ) 
		or die( "Could not execute SQL query" );
#loop through all records
while ( $row = mysql_fetch_array( $rs ) ) 
{
?>
<table border="2" width="375">
<tr>
<td><b>Author:</b> <?php echo $row["author"]; ?></td>

<td><b>Title:</b> <?php echo $row["title"]; ?>
           <?php echo $row["title"]; ?></a> </td><tr>
<tr><td colspan="2">
  <?php
  $datetime = $row["datex"];
  $year = substr( $datetime, 0, 4 );
  $mon  = substr( $datetime, 4, 2 );
  $day  = substr( $datetime, 6, 2 );
  $hour = substr( $datetime, 8, 2 );
  $min  = substr( $datetime, 10, 2 );
  $sec  = substr( $datetime, 12, 2 );
  $orgdate = date("l F dS, Y h:i A",mktime( $hour, $min, $sec, $mon, $day, $year ) );
  ?>
<b>Date: </b><?php echo $orgdate; ?></td></tr>

<tr><td colspan="2"><b>Text:</b> <?php echo $row["text"]; ?></td></tr>
</table>
<br>
<?php } ?>

[big_nerd]

lgefrank,

Try taking the @ from behind the SQL Queries, the @ makes it silent. Perhaps there is an inherant error with one of these commands?

Also, add error_reporting(E_ALL); (unless you already have it on) for troubleshooting purposes.

[lgefrank]

big.nerd,

Thanks for your input. I've made the changes you suggested. But now I get the error "Parse error: parse error, unexpected T_VARIABLE in C:\Program Files\Apache Group\Apache2\htdocs\agssearch2.php on line 31".
I'm still very new to programing and don't really know if this is progress. This query is a cross between two querys I've written and got to workm already.
the frist was this one

#create the SQL query
$sql = "select * from article order by datex desc limit 3";

This one I used to put the data in a table
The other one

#create the query 
$sql = "SELECT article.body
	FROM article 
	WHERE article.body like '%$search%' order by datex desc";

This is the search qurey a I have written. As you can see the query I have written this program does both. And a far as my understanding goes it should work.
thanks again for your help. Any help is always welcome. Thank you.

[big_nerd]

Untested but... try something like this:

<?php

$search = $_REQUEST["search"]; 

echo "Searching for: $search<br>";

#strip search of tags 
$search = strip_tags($search, "<b><i>"); 

// Set Connect String
$server = "localhost";
$username = "sad";
$password = "sadd";
$dbname = "ags";

// Connect to Database
$sqlconnect = mysql_connect($server, $username, $password) or die ("no connect $sqlconnect");
$int_db = mysql_select_db("$dbname",$sqlconnect);

if (!$int_db) {
	print "could not select database $dbname.<br>Server:$server<br>Username:$username<br>Passowrd:$password";
}	

$query = "SELECT DISTINCT * from article WHERE body LIKE '%$search%' ORDER BY datex DESC";
$result = mysql_query($query);

while ($row = mysql_fetch_object($result)) {
echo "<table border=\"2\" width=\"375\">";
echo "<tr>\n<td><b>Author:</b>";
echo $row->author;
echo "</td>\n<td><b>Title:</b>";
echo $row->title;
echo "</td></tr>\n<tr><td colspan=\"2\">";
$datetime = $row->datex;
$year = substr( $datetime, 0, 4 ); 
$mon  = substr( $datetime, 4, 2 ); 
$day  = substr( $datetime, 6, 2 ); 
$hour = substr( $datetime, 8, 2 ); 
$min  = substr( $datetime, 10, 2 ); 
$sec  = substr( $datetime, 12, 2 ); 
$orgdate = date("l F dS, Y h:i A",mktime( $hour, $min, $sec, $mon, $day, $year ) ); 
echo "<b>Date: </b>";
echo $row->orgdate;
echo "</td></tr>\n<tr><td colspan=\"2\"><b>Text:</b>";
echo $row->text;
echo "</td></tr></table><br>";
	}
?>

Once you get it working you may want to look into SQL Injection and mysql_real_escape_string();

[lgefrank]

Thanks, big.nerd

Your help has been much appreciated. I wont be able to test the code till monday because of reasons I wont go into. But I'm sure that the code will work. thanks again for your help.

Kind regards
lgefrank

[lgefrank]

Thanks, Big.nerd

It works, I spoted your deliberate mistake 😉 (of change the varabe name fron "body" to " text"). After i fixed that the code worked wonderfully. Also thanks for the advice on using "mysql_real_escape_string();" it seem much better that what I was using berfore. I'll try to work it into my future programs. Thanks again!

regards
lgefrank