Query problem

[CanMan2004]

Hi all

 

I've got some code which does a query on a database and then returns a list of document ares and under each area, is the relevant documents. For some reason, it wont return the document area names if they contain an uppercase character or a symbol such as / or ' for some reason, it will return the areas containing a & symbol. The code I believe is doing this is

 

$qry = $this->DB->prepare("SELECT * FROM page_documents WHERE pd_pgid=:id");
		$qry->bindParam(":id", $id);
		$qry->execute();
		while ($row = $qry->fetch()) {
			$a[] = $row['pd_dmid'];
		}

 

 

But I cannot see what could be doing it.

 

Can anyone help

 

Thanks in advance

 

Ed

[Jessica]

What database library are you using?

[CanMan2004]

not 100% sure, doing this for a friend, what could they be?

[Jessica]

I don't know, but the fact that it's in a class form indicates it's not just regular PHP functions, it's a custom library. You need to find out what it is then check their documentation, and if you can't get it post in the third party forum.