Pulling a substring from a database

[tjbarr]

I need help with this query.

'ltr' is sent over in the url and I want only the org_names that start with this letter(ltr).

$lttr = $_GET['ltr'];
$query="SELECT org_name FROM tbl_cdc_org where substr(org_name,1)= $lttr";

How do you pull a substring out of a query field?

[drew010]

you may want something along the lines of
SELECT org_name FROM tbl_cdc_org LIKE '$lttr%'

[tjbarr]

Thanks, but when I try this code It doesn't pull anything out of the database. I am using postgres as a database, does this make a difference?

[drew010]

what code are you using to retreive the data.

[tjbarr]

<?

$lttr=$_GET['ltr'];

$query="SELECT org_name FROM tbl_cdc_org where org_name like '$lttr%';";

$result_set = pg_Exec ($conn, $query);
$rows = pg_NumRows($result_set);
print $query;
for($i=0;$i<$rows;$i++){
$_POST['Name']=pg_result($result_set, $i,"org_name");
?>

<table>
<?=$_POST['Name']?>
<? } ?>
</table>

[drew010]

have you tried viewing the page source. it should work but that html code for a table isnt valid and may not output anything depending on your browser.

[tjbarr]

ok I will try that, but when I run the query without the where - it displays on the page.

[drew010]

yeah i just noticed i wrote it wrong. try
SELECT org_name FROM tbl_cdc_org WHERE org_name LIKE '$lttr%'

[tjbarr]

Now it prints this query out but no results from the query. But still when I remove the where it prints all of the org_names out.
Not sure what I am doing wrong. Thanks for all your help

SELECT org_name FROM tbl_cdc_org WHERE org_name LIKE 'a%';

[drew010]

thats strange, pgsql does support like, im not sure why it wont work. have you tried running pgsql from the command line and just testing queries.

[tjbarr]

I think I figured out what the problem is

when I print the query out the variable is lowercase, but in the database the first letter of org_name is uppercase. How do I adjust to this?

[drew010]

$query = "SELECT org_name FROM tbl_cdc_org WHERE org_name LIKE '" . strtoupper($lttr) . "%'";