I have done simple php script and I have corrected every little error I got
but now I stucked. I keep getting "You have an error in your SQL syntax
near '' at line 9 ", and I don't know what to do. The code is the following:
<?php
require('config.php');
$conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or
die ('Could not connect to MySQL database.' .mysql_error());
mysql_select_db (SQL_DB, $conn);
$display_block = "<h1>$project_name Categories</h1>
<P>Select a Category to see details.</P>";
//validate project
$get_project = "SELECT
c.cat_name,
p.project_name
FROM
category
AS c LEFT JOIN
project AS p ON p.id = c.project_id
WHERE
c.id = $_GET[cat_id]";
$get_project_res = mysql_query($get_project) or die (mysql_error());
if (mysql_num_rows($get_project_res) < 1) {
//invalid item
$display_block .= "<p><em>Invalid project selection.</em></p>";
} else {
//valid project, get info
$project_name =
strtoupper(stripslashes(mysql_result($get_project_ res,0,'project_name')));
$cat_name = stripslashes(mysql_result($get_project_res,0,'cat_ name'));
}
?>
<html>
<head>
<title>Projects</title>
</head>
<body>
<?php print $display_block; ?>
</body>
</html>
I have to tables, one is category and other one is project. On the main page
I have data from project table, and on the other page (code up) I want to
show data from other table but only valid for project example 1 or 2 etc.
Tnx in advance, sorry for any gramatic mistake, english is not my first
language :)
