How do i pass a variable by url

I've made this script to query my database (done in MySql) via url:

<?php
$db = mysql_connect("localhost", "");
mysql_select_db("archive",$db);
$result = mysql_query("select * from mytable where ID= $ID",$db);
if ($myrow = mysql_fetch_array($result)) {
echo "<table border=1>n";
echo "<tr><td>Name</td><td>Position</td></tr>n";
do {
printf("<tr><td>%s %s</td><td>%s</tr>n", $myrow["fieldone"], $myrow["fieldtwo"], $myrow["fieldthree"]);
} while ($myrow = mysql_fetch_array($result));
echo "</table>n";
} else {
echo "Sorry, no records were found!";
}
?>

The only working field is ID (Unique,Primary). All the other filelds generete a query error. http://www.mysite.com/test.php?ID=34 works http://www.mysite.com/test.php?fieldone=pippo doesn't work.

Any help is appreciated!

Thanks in advance!

Abe

Look at your query. You are querying the column ID with the value $ID. If you don't pass a value for $ID then the query won't work. If you want to specify a field and a value you need to pass like this:

?fieldname=fieldone&value=pippo
or
?fieldname=ID&value=34
etc

and change your query to:

$result=mysql_query("select * from mytable where $fieldname=$value");

IOW, if you want to be able to search on any field you have to specify the field.

Thanks for your time. I tried it with the very same results, which you can see at http://millennio.it/prova.php?field...emin&value=rana
Code is:
$result = mysql_query("select * from users where $fieldname=$value",$db);
The fact that is working only with the ID field makes me think that this kind of query can be done only with primary and/or unique fields. Could be that? If you're willing to help me out pleae tell me anything you need (my MySQL database structure, HTML code, etc.) and I'll provide. Thanks again for your time.

Sorry, my mistake. Since $value might contain non-numeric information it should have single quotes around it:

$result=mysql_query("select * from mytable where $fieldname='$value'");

Well, it definitely worked! Thanks again very much for your support!