Parse error: syntax error, unexpected T_PRINT in /home/st/ml514//Epu/L5/legoquery.php

Fafner

So I'm new to this, and I thought I would try out several things. Well I tried this (see the code below) and it turns out that there is a problem.

The thing is that when I search for a special ID, this whole "thing" I'm trying to make is supposed to check for this ID in a database, and if it finds the ID then it should post the results.

So I tried to search for an ID, and it gave me this error (it give me this error if I just try to access the php file anyway):

Parse error: syntax error, unexpected T_PRINT in /home/st/ml514//Epu/L5/legoquery.php on line 40

Anyone know how to solve this problem? 🙂

Here's the code (never mind the language in the code):

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Sökresultat av sats i LEGO</title>
</head>
<body>
<?php
mysql_connect("studsql.itn.liu.se","lego_guest","");
mysql_select_db("lego");

$query_temp = $_POST["query"];

$query = stripslashes($query_temp);

?>
<h2>Resultat</h2>
<p style="font-family:monospace">Din sökning gav följande resultat :
</p>
<p>
<?php
$contents = mysql_query("SELECT Setname, year FROM sets WHERE SetID LIKE '$query%' ORDER BY year");
$parts = mysql_query("Select Partname FROM sets, parts WHERE sets.setID = sets.$query AND set.catID = parts.catID");
print("<table>\n<tr>");
for($i=0; $i<mysql_num_fields($contents); $i++) {
$fieldname = mysql_field_name($contents, $i);
print("<th>$fieldname</th>");
}
print "</tr>\n";

while($row = mysql_fetch_row($contents)) {
print("<tr>");
for($i=0; $i<mysql_num_fields($contents); $i++) {
print("<td>$row[$i]</td>");
}
print("</tr>\n");
for($j=0; $j<mysql_num_fields($parts); $j++) {
$part = mysql_fetch_row($parts)

print("<td>$part[$j]</td>);
} // end for
} // end while
print("</table>\n");
?>
</body>
</html>

Piranha

Go to row 40 and look backwards if something is wrong. Normally it is only small errors that gets you into trouble, like missing a ; in the end of a row, missing a }, ) or ] or a missing " sign. Just look for those things and I think you will get it working. If not please post back and mark out what line the error is at.

By the way, post code in the [ php ] [ /php ] tags, then it gets formatted and is much easier to read.

Fafner

Ok so the ";" was missing on line 38, that solved at least that problem but then it gave me a new one:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/st/ml514//Epu/L5/legoquery.php on line 37

Here's the code:

http://hashphp.org/pastebin?pid=9432

NogDog

Fafner wrote:
Ok so the ";" was missing on line 38, that solved at least that problem but then it gave me a new one:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/st/ml514//Epu/L5/legoquery.php on line 37

Here's the code:

http://hashphp.org/pastebin?pid=9432

That error almost always means there was an error in your query, so mysql_query() returned FALSE instead of a resource ID. A useful pattern to use while developing your script is:

// assign your query to a variable
$sql = "SELECT Setname, year FROM sets WHERE SetID LIKE '$query%' ORDER BY year"; 
// this will give you useful debug info if your query fails:
$contents = mysql_query($sql) or die("Query failed: $sql - " . mysql_error());

Piranha

You should check out debugging 101 to get tips about how to debug your code.