dynamic sql?

Anon

here's the problem i'm running into. i've got results returning (with a paging feature added) on a single query. is there a simple way to add an array so that user can change the query based on dynamic links... i.e. choose the "B" link and return a result for all entries starting with letter b. initial code is below:

$QUERY = "SELECT * FROM company WHERE comp_name LIKE 'A%' ORDER by comp_name";
$QRETURN= @($QUERY);

$QNUM = @mysql_num_rows($QRETURN);
$DISPPAGE = 10;
$NUMPAGES = intval($QNUM/$DISPPAGE);
if ($QNUM % $DISPPAGE) {
$NUMPAGES++;
}
if($QRETURN):
if($QNUM > 0):

much thanks...

fitzbean

Sure just use the variable.. ?

Anon

In the page with the Query :

$QUERY = "SELECT * FROM company WHERE comp_name LIKE '$letter%' ORDER by comp_name";

In your page with the letters, just write something like:

But before making the $Query = ..., make a validation (make sure the $letter var is one caracter only and is a character.)

Anon

thanks. simple and works great.