PDO using multiple values in one query

[azz0r_wugg]

$parents	= $db->prepare("
			SELECT c.*, sc.is_visible, sc.id as sc_id 
				FROM category c
				JOIN site_category sc ON (c.category_id = sc.category_id AND sc.site_id = :site_id)
				WHERE sc.parent_id = :parent_id  AND sc.site_id = :site_id  $categoryId  $isVisible
			ORDER BY sc.position 
		");
 
		$parents->bindValue('site_id', 		$siteId);
		$parents->bindValue('parent_id', 	$parentId);
		$parents->execute();
		$items = $parents->fetchAll(PDO::FETCH_OBJ);

:site_id is used twice in the query. On Windows XP local using PHP 5.3.0 this query works. On a Mac Or Linux server this query spits out an error.

My Question: Is this OS dependant or is it due to a setting in PHP / MYSQL.

(note sure what forum this goes in, so I've put it in both PHP and MYSQL.

[azz0r_wugg]

$parents	= $db->prepare("
			SELECT c.*, sc.is_visible, sc.id as sc_id 
				FROM category c
				JOIN site_category sc ON (c.category_id = sc.category_id AND sc.site_id = :site_id)
				WHERE sc.parent_id = :parent_id  AND sc.site_id = :site_id  $categoryId  $isVisible
			ORDER BY sc.position 
		");
 
		$parents->bindValue('site_id', 		$siteId);
		$parents->bindValue('parent_id', 	$parentId);
		$parents->execute();
		$items = $parents->fetchAll(PDO::FETCH_OBJ);

:site_id is used twice in the query. On Windows XP local using PHP 5.3.0 this query works. On a Mac Or Linux server this query spits out an error.

My Question: Is this OS dependant or is it due to a setting in PHP / MYSQL.

(note sure what forum this goes in, so I've put it in both PHP and Mysql.

[r937]

i'm guessing this isn't a mysql problem, even if it's a mysql error message (which you didn't specify)

[Mark Baker]

:site_id is used twice in the query. On Windows XP local using PHP 5.3.0 this query works. On a Mac Or Linux server this query spits out an error.

My Question: Is this OS dependant or is it due to a setting in PHP / MYSQL.

It shouldn't be platform or OS dependent, but it could be configuration dependent or even version dependent.

Knowing exactly what error the query spits out could be very helpful in diagnosing the problem.

[Cups]

This should get the err info, ftw.

var_dump( $items->errorInfo() ); 

(Quite interested in this answer too)

[crmalibu]

The manual sais you cannot use the same placeholder name multiple times.

[raena]

Let's keep this in one thread, thanks.