search function error

Adamthenewbie

I am trying to make a search function that searches though a database. This is the query I have so far. I keep getting this error?

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING

$result2 = mysql_query("SELECT fullDate, prov_state, city, country, raceDesc, id FROM resultDB WHERE month LIKE '".$month."' AND startDay LIKE '".$day."' AND year LIKE '".$year."' AND city LIKE '".$city."' AND prov_state LIKE '".$prov"' AND country LIKE '".$country."' AND raceDesc LIKE '".$desc."' AND results LIKE '".$name."' AND type LIKE '".$type."' order by dayOfYear DESC", $mysql_access);

kevinsequeira

DEBUG :

$query = "SELECT fullDate, prov_state, city, country, raceDesc, id FROM resultDB WHERE month LIKE '".$month."' AND startDay LIKE '".$day."' AND year LIKE '".$year."' AND city LIKE '".$city."' AND prov_state LIKE '".$prov"' AND country LIKE '".$country."' AND raceDesc LIKE '".$desc."' AND results LIKE '".$name."' AND type LIKE '".$type."' order by dayOfYear DESC";
echo $query;
$result2 = mysql_query($query, $mysql_access);

see what echo $query throws up, this should help u understand if the query is properly formatted.

reg
kevin

Adamthenewbie

still get the same error?

kevinsequeira

on what line do u get the error ? look at the code a few lines above the indicated line, u make have left out a $ in one of the variable names
if u cant find it then post the entire code and mark the line where ure getting the error
reg
kevin

Adamthenewbie

Here is the error
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/trackiec/public_html/resultsSearchView.php on line 17

Here is the Code:
The variables are getting past from another pages form.

<?
session_start();
?>
<?
include "trackiemenuHTML.inc";
?>
<?
include "trackieadds.inc";
?>
results (<a class = "a1" href = "resultsSearch.php" target = "self">Search Results</a>) (<a class = "a1" href = "resultsAdd.php" target = "self">Add Results</a>) (<a class = "a1" href = "results.php" target = "_self">2003 Results</a>)
<?
$db = 'dbname'; // mySQL database name
$user = 'username'; // mySQL username
$pw = 'password'; // mySQL password
$mysql_access = mysql_connect("localhost", $user, $pw);
mysql_select_db($db, $mysql_access);
Line 17: $result2 = mysql_query("SELECT fullDate, prov_state, city, country, raceDesc, id FROM resultDB WHERE month LIKE '".$month."' AND startDay LIKE '".$day."' AND year LIKE '".$year."' AND city LIKE '".$city."' AND prov_state LIKE '".$prov"' AND country LIKE '".$country."' AND raceDesc LIKE '".$desc."' AND results LIKE '".$name."' AND type LIKE '".$type."' order by dayOfYear DESC", $mysql_access);
print("");
while($row = mysql_fetch_row($result2))
{
print("<a class = \"a1\" href = \"resultsView.php?id=$row[5]\" target = \"_self\">$row[0], $row[4], $row[2], $row[1], $row[3]</a> ");
}
?>

<?
include "trackiemenu2HTML.inc";
?>

Sorry for being such a pain..

Thanks for your help

laserlight

I made a few small changes, and I think I found your error:

<?
session_start();

include "trackiemenuHTML.inc";

include "trackieadds.inc";
?>
<p class="title">results
(<a class="a1" href="resultsSearch.php" target="_self">Search Results</a>)
(<a class="a1" href="resultsAdd.php" target="_self">Add Results</a>)
(<a class="a1" href="results.php" target="_self">2003 Results</a>)</p>
<?
$db = 'dbname'; // mySQL database name
$user = 'username'; // mySQL username
$pw = 'password'; // mySQL password
$mysql_access = mysql_connect("localhost", $user, $pw);
mysql_select_db($db, $mysql_access);
Line 17: $result2 = mysql_query("SELECT
	fullDate, prov_state, city, country, raceDesc, id
	FROM `resultDB`
	WHERE month
	LIKE '" . $month . "'
		AND startDay LIKE '" . $day . "'
		AND year LIKE '" . $year . "'
		AND city LIKE '" . $city . "'
		AND prov_state LIKE '" . $prov . "' //the error was here, missing dot
		AND country LIKE '" . $country . "'
		AND raceDesc LIKE '" . $desc . "'
		AND results LIKE '" . $name . "'
		AND type LIKE '" . $type . "'
	ORDER BY dayOfYear DESC", $mysql_access);
print "<p class = \"body\">";
while ($row = mysql_fetch_row($result2))
{
	print "<a class=\"a1\" href=\"resultsView.php?id=$row[5]\" target=\"_self\">$row[0], $row[4], $row[2], $row[1], $row[3]</a><br>";
}
?>
<br><br><br>

<!--End Main Content Area-->
<?
include "trackiemenu2HTML.inc";
?>

Adamthenewbie

Here is the error
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/trackiec/public_html/resultsSearchView.php on line 17

Here is the Code:
The variables are getting past from another pages form.

<?
include "trackiemenu2HTML.inc";
?>

Sorry for being such a pain..

Thanks for your help

Adamthenewbie

woops I didnt mean to post that again... Thanks for the help I'll try that code.

Adamthenewbie

thanks that worked. Now I have another question. I thought by using LIKE instead of = it would still show the entries that columns are not exactly but have the word in the column. Is there a better way to use the LIKE funciton?? I hope this makes sense...

Adamthenewbie

nevermind I got it to work

Used %' .$var.'%

Thanks for all the help!!