Query with Form field

[Jack2003]

Hi,

In my PHP page I have the following query:
"SELECT Url.Field1 FROM Url GROUP BY Url.Field1"

The query needs to have a Where clause with a Form field.
I tried this one:

"SELECT Url.Field1 FROM Url GROUP BY Url.Field1 WHERE Url.Field2 = Form1.Field"

But that does not work.

Who can help?

Thanks in advance,
Jack

[steve8557]

Hi,
I think you'll find that the query will fail as you do not have any agregate functions in the "select" bit of the query.
Group by is used with Aggregate functions like select count(field) from table group by field.

From you description i believe you are trying to do this:

$sql = "select field1 from url where field2 = '$form_field'";

This will get the values in field1 for all the records that match the where clause. IE field2 is equal to the value of the form field value.

Perhaps you could post some real code.

regards
Steve

[Jack2003]

Hi Steve,

This is some more code:
mysql_select_db($database_jlmdigital, $jlmdigital);
$query_Rubriek = "SELECT Url.Rubriek FROM Url GROUP BY Url.Rubriek WHERE Url.Categorie = ???????";
$Rubriek = mysql_query($query_Rubriek, $jlmdigital) or die(mysql_error());
$row_Rubriek = mysql_fetch_assoc($Rubriek);
$totalRows_Rubriek = mysql_num_rows($Rubriek);

In de page is a form (a part of the form)
<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="form1">
<table width="506" border="0">
<!--DWLayoutTable-->
<tr>
<td width="68" height="26"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Categorie</font></td>
<td width="420" valign="top"><select name="Categorie" id="Categorie">

What parameter do I need at .. WHERE Url.Categorie = ???????

Jack

[steve8557]

Hi Jack
Your form passes ALL fields to PHP as variables so "categorie" will be available for you to use as $categorie. SO....

your query will be:

$query_Rubriek = "SELECT Url.Rubriek FROM Url GROUP BY Url.Rubriek WHERE Url.Categorie = '$Categorie'";

Simple eh? 😉

Let me know if it works for you.

Steve

[Jack2003]

Steve,

That doesn't work. The variable $Categorie contains the value Resource id #2

I have changed the structure of my PHP page. I put a new question on the board asking how to refer in a Form action to a Form variable.

Thanks,
Jack

[steve8557]

Doh!!!

I left the Group By bit in. Sorry!! 😕

the query will be:

$query_Rubriek = "SELECT Url.Rubriek FROM Url WHERE Url.Categorie = '$Categorie'";

Try that.

I noticed that your form field is type "Select" is that what you need?

Regards
Steve