cam you tell whats wrong?

yellowchimp

Hello

Can anyone tell me where I am going wrong in the following code. It doesn't work at all. It works off a form where a user enters a consultte name - using a drop down menu. One of the options is 'all'. Apologies it is a bit long.

<?$dsn="conserve";
$username="sa";
$password="";

$connect = odbc_connect('conserve', 'sa', '');

if ($_POST['consultee_search']!= 'all')

{  
$sql= "SELECT doc_url, doc_title 
FROM documents INNER JOIN
(types INNER JOIN doc_types 
ON types.type_id = doc_types.type_id) 
ON doc_types.doc_id = documents.doc_id
WHERE types.type_id = '" . $_POST['type_search'] . "' 
AND doc_date_yr = '" . $_POST['year_search'] . "'";

$result = odbc_exec($connect, $sql);
while ($row = odbc_fetch_array($result))

{
echo '<ul><li><a href="' . $row['doc_url'] . '">' . $row['doc_title'] . '</a></li></ul>'; 
}
}

else

{$sql="SELECT doc_url, doc_title 
FROM (documents 
INNER JOIN doc_types 
ON documents.doc_id = doc_types.doc_id) 
INNER JOIN doc_consultees 
ON documents.doc_id = doc_consultees.doc_id
WHERE doc_types.type_id = '" . $_POST['type_search'] . "' 
AND doc_consultees.consultee_id = '" . $_POST['consultee_search'] . "' 
AND doc_date_yr = '" . $_POST['year_search'] . "'";

$result = odbc_exec($connect, $sql);
while ($row = odbc_fetch_array($result))

{
echo '<ul><li><a href="' . $row['doc_url'] . '">' . $row['doc_title'] . '</a></li></ul>'; 
} 
}

odbc_close($connect);
?>

PHPMagician

Any errors reported? Can we see the form the data originates from? I have nothing to test such code on at the moment.

Edit: And please use vBulletins PHP vBCODE, it makes looking at code so much easier and the code looks prettier.

yellowchimp

sure. This is the code from the form. I don't get any errors - just a blank page

<?$dsn="conserve";
$username="sa";
$password="";
$sqlconnect=odbc_connect($dsn,$username,$password); ?>

<form action="tuesday.php" method="POST">
Select a type:
<select name="type_search">
<?
$sqlquery= "SELECT type, type_id from types;";
$process=odbc_exec($sqlconnect, $sqlquery);
while(odbc_fetch_row($process))

{
$type=odbc_result($process,"type");
$type_id=odbc_result($process,"type_id");

echo "<option value=$type_id>$type</option>";}

?>
</select>

<br>

Select a Consultee:
<select name="consultee_search">
<option value="all">all</option>
<?
$sqlquery= "SELECT consultee_name, consultee_id from consultees;";
$process=odbc_exec($sqlconnect, $sqlquery);
while(odbc_fetch_row($process))

{
$consultee_name=odbc_result($process,"consultee_name");
$consultee_id=odbc_result($process,"consultee_id");

echo "

<option value=$consultee_id>$consultee_name</option>

";
}

?>
</select>

<br>

date:
<select name="year_search">

<?
$sqlquery= "SELECT distinct doc_date_yr from documents;";
$process=odbc_exec($sqlconnect, $sqlquery);
while(odbc_fetch_row($process))
{
$doc_date_yr=odbc_result($process,"doc_date_yr");
//tell it to print results of query in the drop down menu
echo "<option>$doc_date_yr</option>";
}
odbc_close($sqlconnect);
?>
</select>