Parse Error Issue

monki_SF

I'm getting a parse error

Parse error: parse error, unexpected '(' in /home/yaofield/public_html/search.php on line 96

from this line of code

$categoryname="Select category_name from category_master where category_id = "(". $objListings['category_id'] .");

I'm sure it has something to do with quotes - but can't figure out the fix.

Sayian


$cat_id = (INT) $objListings['category_id'];

$categoryname="SELECT category_name 
FROM category_master 
WHERE category_id = '$cat_id'";

assigning variables before using them in a query, if they are part of an array can prove to be very helpful in keeping your code clean, and maintainable.

monki_SF

That seems to work pulling the Cat ID to display here

<a href="listingdetail.php?listid=<?=$objListings[listing_id]?>&catid=<?=$objListings[category_id]?>"><b><?=$price?><?=$objListings[listing_title]?></b></a>&nbsp;<?=$location?>&nbsp;&nbsp;<?=$categoryname?>

but for some reason the category name isn't being pulled - just the ID

And its displaying the following

*   test ( sf )  SELECT category_name FROM category_master WHERE category_id = '225'

I'm a little new to object oriented php - so may be missing something here.

bradgrafelman

If category_id is an integer type in MySQL, don't use quotes around the value.

Plasma

$categoryname="Select category_name from category_master where category_id = "(". $objListings['category_id'] .");

Thats just broken!

$categoryname="Select category_name from category_master where category_id = ". intval($objListings['category_id']);

Will work.

monki_SF

I'm pulling the correct category id - however the statement is what i am showing - rather than the actual category name here

<a href="listingdetail.php?listid=<?=$objListings[listing_id]?>&catid=<?=$objListings[category_id]?>"><b><?=$price?><?=$objListings[listing_title]?></b></a>&nbsp;<?=$location?>&nbsp;&nbsp;<?=$categoryname?>

result of above code

test ( sf ) Select category_name from category_master where category_id = 225

Roger_Ramjet

You are creating a query string called $categoryname. You then have to run that query and process the results. What you are currently doing is just creating the query string and then echoing it to the page :rolleyes: