Nothing works

[EPierre]

Please help
I have serious problems.
1.-) Although the table looks correct, there is a warning I don't undrestand ("mysql_rows returned an empty result set (i.e. zero_rows)").

2.-) 'dim' and 'fig' are 2 dropdown lists which value determine a given price.
Ajax/MySql/PhP/ are used for this purpose. (see details in 2 attachments).

By clicking on "Submit" we have a "not available" result instead of the hoped price.

I don't see really what is really wrong.

Firstly, I think that the "empty_row" was responsible of this situation.

Some help, please.

E. P.

[code green]

You are reading the result resource into one variable but
using another for mysql_num_rows

$qresult = mysql_query("SELECT {$fieldname} FROM price WHERE fig='{$num}'");  
if(mysql_num_rows($result) > 0){

I have no idea what this is doing here

$ret = mysql_query ($query) or die(mysql_error());