[Resolved] 1064: Sql Error

[Iquil]

Hey, I'm completely baffled about this error. I have no idea what the problem is.

Here the PHP:

<?php

// Database Variables

$dbcon[host] = "???";
$dbcon[user] = "???";
$dbcon[pass] = "???";
$dbcon[name] = "???";
$dbtable[trailer] = "???";

$connect = mysql_connect($dbcon[host],$dbcon[user],$dbcon[pass])
	or die(mysql_errno().": ".mysql_error());

mysql_select_db($dbcon[name]);

$query = "SELECT type, type_id, price, id
		  FROM $dbtable[trailer]
		  WHERE type_id = $type_id";

$result = mysql_query($query)
	or die(mysql_errno().": ".mysql_error());

$content = "";
while($row=mysql_fetch_array($result)) {
	extract($row);
	$id = $row[id];
	$content .= "<a href=\"browse3.php?id=$row[id]\">$row[type]</a>: $row[price]";
}

include "temp.php"; // <---- This is just the template.

?>

And this is the Error Message:

1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

Thanks for any help given.

[bodzan]

...this:

$dbtable['trailer'] = "???";
$query = "SELECT type, type_id, price, id
          FROM ".$dbtable['trailer']."
          WHERE type_id = $type_id"; 

I think that the array key other than number can be not interpreted when presented without single qoutes around it.

But I'm not sure on this at all...

[Iquil]

I tryed what you said to and I get the same error again. :bemused:

Ok I'm gonna give you all of my code for the two pages, because I edited the code and it worked but it's not the way need it to work.

This is it when it doesn't work.
Page 1:

<?php

// Database Variables

$dbcon[host] = "localhost";
$dbcon[user] = "Kiz";
$dbcon[pass] = "hirur635";
$dbcon[name] = "hireco";
$dbtable[trailer] = "trailers";

$connect = mysql_connect($dbcon[host],$dbcon[user],$dbcon[pass])
	or die(mysql_errno().": ".mysql_error());

mysql_select_db($dbcon[name]);

$query = "SELECT DISTINCT type_id, type
		  FROM $dbtable[trailer]
		  ORDER BY type_id";

$result = mysql_query($query)
	or die(mysql_errno().": ".mysql_error());

$content = "";
while($row=mysql_fetch_array($result)) {
	extract($row);
	$content .= "<a href=\"browse2.php?type_id=$row[type_id]\">$row[type]</a>";
}

include "temp.php";

?>

Page 2:

<?php

$dbcon[host] = "localhost";
$dbcon[user] = "Kiz";
$dbcon[pass] = "hirur635";
$dbcon[name] = "hireco";
$dbtable[trailer] = "trailers";

$connect = mysql_connect($dbcon[host],$dbcon[user],$dbcon[pass])
	or die(mysql_errno().": ".mysql_error());

mysql_select_db($dbcon[name]);

$query = "SELECT type, type_id, price, id
		  FROM $dbtable[trailer]
		  WHERE type_id = $type_id";

$result = mysql_query($query)
	or die(mysql_errno().": ".mysql_error());

$content = "";
while($row=mysql_fetch_array($result)) {
	extract($row);
	$id = $row[id];
	$content .= "<a href=\"browse3.php?id=$row[id]\">$row[type]</a>: $row[price]";
}
$content .= "<a href=\"javascript:history.go(-1);\">back</a><br/>";

include "temp.php";

?>

Page 3:

<?php

// Database Variables

$dbcon[host] = "localhost";
$dbcon[user] = "Kiz";
$dbcon[pass] = "hirur635";
$dbcon[name] = "hireco";
$dbtable[trailer] = "trailers";

$connect = mysql_connect($dbcon[host],$dbcon[user],$dbcon[pass])
	or die(mysql_errno().": ".mysql_error());

mysql_select_db($dbcon[name]);

$query = "SELECT *
		  FROM $dbtable[trailer]
		  WHERE id = $id";

$result = mysql_query($query)
	or die(mysql_errno().": ".mysql_error());

$content = "";
while($row=mysql_fetch_array($result)) {
	extract($row);
	$content .= "$row[type]: $row[price]";
}
$content .= "<a href=\"javascript:history.go(-1);\">back</a><br/>";

include "temp.php";

?>

What I did to get it to work was remove

?type_id=$row[type_id]

from the link. I declared

$type_id = 1;

in Page 2 to test if it works or not and it does. So I think what I need to do is find another way of passing the $type_id from Page 1 to Page 2.

Any ideas?

[mrhappiness]

$type_id = $_GET['type_id'];

should do the job for you, just place it above the line in which you use $type_id the first time (in each script)

afterwards inform yourself about register globals

[Iquil]

Thank you very much it works.