Just the one.

[corkg]

Hi

 

I have a query to select something from a database:

 

$sqlquery="SELECT * FROM PVS";

while($foy=odbc_fetch_object($resultiscri)){ echo"$foy->name"; }

 

But it gives me a list like this

 

1

1

2

2

3

 

I only want it to show

 

1

2

3

[trq]

<?php

$sqlquery="SELECT * FROM PVS GROUP BY `name`";

?>

[corkg]

I am afraid it does not return any results,

I am using an ODBC database.

 

This is the full code

 

 <select name="findcri" id="findcri">
                                          <?  $sqlquery="SELECT * FROM PVCDATABASEOFJOBS";
$resultiscri=odbc_exec($conexion,$sqlquery); while($foy=odbc_fetch_object($resultiscri)){

  ?>
                                        <option value="<?=$foy->catagory?>"><?=$foy->catagory?></option>
                                            <? }?>
                                            </select>