php/mysql query

Anon

I have created a form that will be used to query a MySQL db. Some items on the form may be left blank. Let's say ALL items are left blank, I would want it to return ALL records from the database.

If you wanted to narrow your search, you would then enter info in various fields on the form.

Here's what I tried to do, but it doesn't work

if ($reviewer == NULL) {
$reviewer = "*";
}

If the above makes no sense, I can try to explain in more detail.

Anon

Put quotes around "NULL" and it will work... NULL is a string to PHP...

Anon

Err... And if you're testing to see if the variable is actually EMPTY, you can use the empty function...

if(empty($reviewer)) {
$reviewer = "*";
} # End if

Anon

After giving the insert statement.Try using
Select * from <tablename>;
it will show all the records

Anon

i use the following in one of my scripts (to browse through all the links in the database):

$dbcnx = @mysql_connect($server, $login, $password);
mysql_select_db($db_name);

// The basic SELECT statement
$select = "SELECT DISTINCT link_url, link_name";
$from = " FROM links";
$where = " WHERE link_id > 0 and link_view='y'";

if ($cid != "") { // A category is selected
$where .= " AND link_type_id=$cid";
}

if ($searchtext != "") { // Some search text was specified
$where .= " AND link_name LIKE '%$searchtext%'";
}

$links = mysql_query($select . $from . $where);

if you then still want to add some ordering (like ORDER BY link_name), make sure you add it to the query after the $where statement...

Anon

Still doesn't work. My goal is that if the form is left blank, then ALL records will be displayed. Then you can specify criteria to narrow your search. here's what I have now:

<?
if (empty ($reviewer)) {
$reviewer = "";
}
if (empty ($username)) {
$username = "";
}
if (empty ($age_min)) {
$age_min = "";
}
if (empty ($age_max)) {
$age_max = "";
}
mysql_connect("localhost", "", "") or die ("Unable to connect"); //connect to db
$sql = "select * from patient where reviewer = '$reviewer' AND age >= '$age_min' AND age <= '$age_max'"; //sql statment that uses the username from the cookie and status field to find assigned forms.
$r = mysql_db_query("medicala",$sql); //execute sql

Anon

$sql = mysql_query("select * from patient where reviewer = '$reviewer' AND age = '$age_min' AND age <= '$age_max'") or die("Error Executing The Query");

printf("<table>");
printf("<tr>"
<td>reviewer</td>
<td>username</td>
</tr>\n");
while($row=mysql_fetch_object($sql))
{
printf("<tr>
<td>%s</td>
<td>%s</td>
</tr>\n",
$row->reviewer,$row->username);
}
printf("</table>");

Use the above code after your select Statement. One thing you should remeber while using the above code is that the form field name should be used properly.