This topic is locked

Calculate a complex URL

3/14/2011 8:01:49 PM
PHPRunner General questions
K
kenlyle author

I am using

Concat("/index.php?option=com_tienda&view=manufacturers&layout=products&filter_manufacturer=",manufacturer_id,"&task=products&Itemid=") AS searchurl
in a query to compute a URL, which will hopefully show up in a list.
I am getting an error at the line 271, which contains the first element ending with the equals sign:
Parse error: syntax error, unexpected '=' in /home/blah/jos_tienda_manufacturers_settings.php on line 271
The code looks like this:
$proto23["m_arguments"] = array();

$obj = new SQLNonParsed(array(

"m_sql" => ""/index.php?option=com_tienda&view=manufacturers&layout=products&filter_manufacturer="" <-271

));
$proto23["m_arguments"][]=$obj;

$obj = new SQLNonParsed(array(

"m_sql" => "manufacturer_id"

));
$proto23["m_arguments"][]=$obj;

$obj = new SQLNonParsed(array(

"m_sql" => ""&task=products&Itemid=""

));
I am pretty sure that it's the trailing = on line 271.
How can I restructure to get around this issue?
Thanks,

K

Sergey Kornilov admin 3/14/2011

Use single quotes in your SQL Query:

Concat('/index.php?option=com_tienda&view=manufacturers&layout=products&filter_manufacturer=',manufacturer_id,'&task=products&Itemid=') AS searchurl