syntax error

[Anon]

what is causing this error?:

You have an error in your SQL syntax near 'WHERE pid = 0 ORDER BY title' at line 1

thx

remco

[Anon]

What's the entire SQL query?

[Anon]

function index() {
global $mpnTables, $phpEx, $myts, $eh, $sitename, $mf;
include("header.$phpEx");
$result=mysql_query("SELECT cid, title, imgurl FROM ".$mpnTables['classifieds_categories']." WHERE pid=0 ORDER BY title") or $eh->show("0013");

OpenTable();
$mainlink = 0;
mainheader($mainlink);
echo "<center><table border=0 cellspacing=5 cellpadding=0 width=\"90%\"><tr>";
$count = 0;
while($myrow = mysql_fetch_array($result)) {
	$title = $myts->makeTboxData4Show($myrow['title']);
	$imgurl = $myts->makeTboxData4Show($myrow['imgurl']);
	$imgurl = urldecode($imgurl);
		echo "<td valign=\"top\" align=\"right\">";
		if ($myrow['imgurl']){
		echo "<a href=classifieds.$phpEx?op=viewcat&cid=".$myrow['cid']."><img src=\"".$imgurl."\" height=\"50\" border=\"0\"></a>";
		} else {
		echo "";
		}
	$totalbiz = $mf->getTotalItems($myrow['cid'], 1);
		echo "</td><td valign=\"top\" width=\"40%\"><font size=2><a href=classifieds.$phpEx?op=viewcat&cid=".$myrow['cid']."><b>$title</b></a>&nbsp;($totalbiz)<br>";
	// get child category objects
	$arr=array();
	$arr=$mf->getFirstChild($myrow['cid']);
	$space = 0;
	$chcount = 0;
	foreach($arr as $ele){
		$chtitle=$myts->makeTboxData4Show($ele->title);
		if ($chcount>4){
			echo "...";
			break;
		}
		if ($space>0) {
    			echo ", ";
    		}

    		echo "<a href=classifieds.$phpEx?op=viewcat&cid=".$ele->cid.">".$chtitle."</a>";
    		$space++;
		$chcount++;

	}
		if ($count<1) {
    		echo "</font></td>";
		}
		$count++;
		if ($count==2) {
    		echo "</font></td></tr><tr>";
    		$count = 0;
		}
}
echo "</font></td></tr></table></center>";
list($numrows)=mysql_fetch_row(mysql_query("select count(*) from ".$mpnTables['classifieds_business']." where status>0"));
echo "<br><br><center><font size=2>".translate("There are")." <b>$numrows</b> ".translate("Adds in our Database")." </center>";
echo "</font></basefont>";
CloseTable();
echo "<br>";
OpenTable();
echo "<div align=\"left\"><font size=\"3\"><b>".translate("Latest Listings")."</b></font><br><br>";
showNew("".$mpnTables['classifieds_business']."");
echo "</div>";
CloseTable();	
include("footer.$phpEx");

}

[Anon]

Have you checked the value in $mpnTables['classifieds_categories'] to make sure it's valid?

[Anon]

how do i do this?

[Anon]

Try

print ("$mpnTables['classifieds_categories']\n");

right before

$result=mysql_query("SELECT cid, title, imgurl FROM " ...

and see what gets displayed.

Or you could

$sel_stmt = "SELECT cid, title, imgurl FROM "
. $mpnTables['classifieds_categories'] . " WHERE pid=0 ORDER BY title");

and then

print("$sel_stmt\n");

and see how the entire statement reads.

[Anon]

This is what it reads: (line 88 is exactly the line no i have put in, being the print....)

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /home/sites/site21/web/classifieds.php on line 88

[Anon]

So my question is-- Is $mpnTables['classifieds_categories'] a valid reference?

[Anon]

sorry, but i'm not getting it
i did make a db called classifieds_categories..

[Anon]

That message means there is a syntax error in your db query. What you need to do is print out the query, that you passing, to the browser and look at it. The reason might become more apparent. Also post the query that is being passed here to let others look at. I bet a solution will be posted shortly after.

[Anon]

Double check the spelling of your array and field names as well as the table names you populated $mpnTables with. Without knowing what $mpnTables['classifieds_categories'] actually contains, it's difficult to trouble shoot the syntax. Try putting the select statement into a variable and printing that, (the $sel_stmt example I listed earlier) and see what you get.

Unfortunately, I'm off to a brain-numbing long meeting. I'll check back in a couple hours. Good luck.

Hank

[Anon]

how do I print out a query (i'm a newbie at all this)

[Anon]

this is what the db contains:

Field Type Attributes Null Default Extra Action
cid int(11) UNSIGNED No auto_increment Change Drop Primary Index Unique

pid int(11) UNSIGNED No 0 Change Drop Primary Index Unique

title varchar(50) No Change Drop Primary Index Unique

imgurl varchar(150) No Change Drop Primary Index Unique

[Anon]

In your case

print "SELECT cid, title, imgurl FROM " . $mpnTables['classifieds_categories'] . " WHERE pid=0 ORDER BY title";

put that right aove the line in your code that says

$result=mysql_query("SELECT cid, title, imgurl FROM ".$mpnTables['classifieds_categories']." WHERE pid=0 ORDER BY title") or $eh->show("0013");

[Anon]

did that and uploaded once again, then pointed my browser to:

http://www.gsmbe.com/classifieds.php see for the error yourself

[Anon]

Here is the problem

This is your query being passed.

SELECT cid, title, imgurl FROM WHERE pid=0 ORDER BY title

It is missing the tablename.

'FROM WHERE'

The tablename should be in between like this

'FROM tablename WHERE'

which means that, as Hank told you already, that $mpnTables['classifieds_categories'] has no value. It is not being set for some reason. You will need to debug.

[Anon]

should tablename be in between [] or "" or '' ?
Should it read FROM " . $mpnTables['classifieds_categories'] . " WHERE ?

[Anon]

this is already the case, so how do I debug???

[Anon]

You will need to know PHP. So in your case, you will either need to learn PHP, or employ someone who knows ir already.