Get PHP to read my postgres select statement?

Question

I have an application that was built by someone else that I need to edit. There is an area of code that I cannot find the right syntax for ... can someone please help.

The select statement in POSTGRES goes like this:

SELECT collection|| '/' ||color AS collection
FROM table
WHERE series = 'random number' <-- this is controlled by an array in the php

in the php the existing code looks like this:

$tableName = $db->getOne('SELECT collection FROM item_series WHERE series = ?', array($series['marriage_1']));
}else{$tableName = $series['marriage_1'];}

I have tried this, but it is not working:

$tableName = $db->getOne('SELECT collection, ".'/'.", color AS collection FROM item_series WHERE series = ?', array($series['marriage_1']));
}else{
$tableName = $series['marriage_1'];}

Please help I have looked for an answer to this for hours!

mu is too short · Accepted Answer · 2012-09-25 19:03:43Z

1

Wouldn't it be this?

$db->getOne('select collection || \'/\' || color as collection ...', ...);

Or this?

$db->getOne("select collection || '/' || color as collection ...", ...);

Your attempt:

'SELECT collection, ".'/'.", color AS collection FROM item_series WHERE series = ?'

would end this SQL to the database:

SELECT collection, "/", color AS collection FROM item_series ...

and PostgreSQL wouldn't be upset with you for trying to use double quotes for a string literal, it would think you were trying to access a column called /. Besides, you want to concatenate and you want to use the || SQL operator for that.

answered Sep 25, 2012 at 19:03

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get PHP to read my postgres select statement?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related