Obtain an ID from description field from a select

dookie

hi, i made a "select"(combobox) that load data from a very simple table from Postgre. The select load the description of several item, not the id. Let suposse that i have a table called PRODUCTS with 2 fields: id and description. The select i made show only the description so user can select one of them.
I want to post certain info, with that select and obtain the ID from that description..
I have this:

$combo = $_POST["combo"];

to pass to the $combo variable the selection, and it works cause i tested with an "echo $combo" obtaining the description selection.

Then i have.:

$codcombo=pg_query("select id from producto where descripcion='$combo'");

pg_exec("insert into subproducto (nombre, codtipo) values ('$subproducto','$codcombo')");

The problem is that in the first query, $codcombo returns Resource Id #7 and i dont know why.. :bemused:

any help?
thanks.

konrad

pg_query function returns resource that has to be fetched.

Try this one:

<?php
$codcombo=pg_query("select id from producto where descripcion='$combo'");
$row = pg_fetch_array($codcombo);
$codid = $row['id'];
pg_exec("insert into subproducto (nombre, codtipo) values ('$subproducto','$codid')");
?>

Your solution works with unique description only. It would be better to create combobox with id as a value, so you can have 2 identical descriptions:

<select name="combo">
 <option value="id1">Desc1</option>
 <option value="id2">Desc2</option>
 <option value="id3">Desc3</option>
 <option value="id4">Desc1</option>
</select>

leatherback

Hehe,
Konrad: Of course, having two descriptions which are the same is a bit silly! However, I agree with you on the using an ID as value in the combobox: You can check wether an ID is numeric, and therefor avoid some SQL-inject reject, you need to do less user-input processing.

konrad

Of course, having two descriptions which are the same is a bit silly!

It's sometimes usefull when U use it with optgroup.

dookie

thanks, eve i have unique descriptions, the second option is better, cause i have less query to db and is faster to write it down too..
the code i put was

echo ('<td><select name="combo">');
		$consulta = 'select codtipo, nombre from tipoproducto;';
		$result = pg_query($consulta) or die('Consulta fallida: ' . pg_last_error());

echo "<option>Select Product...</option>";
        while ($row=pg_fetch_array($result))
       {		{
	echo '<option value='.$row["codtipo"].'>'.$row["nombre"].'</option>';  

        }
	echo ('</select></td></tr>');

So if in other page i have

$combo = $_POST["combo"];

i obtain the id 😃

thanks again