if this is this then do this sql and echp this or...

[yellowchimp]

How do you code

if (this variable is this)

{do this sql}

and echo this

else

{echo this}

my code is like this:

if ($_POST['date_search']= 2004)
{
$result = odbc_exec($connect, "SELECT doc_date_yr, doc_url, doc_title
FROM documents
WHERE doc_date_yr=2004");

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

}
else
{
echo "you didn't search for 2004"
}

i can't get it to work. I know the form is working properly and the variable date search is all done correctly. It is something wrong in the code above but I can't find any help anywhere on google that is appropriate.
Where am I going wrong???

Thank you for help.

[micmac]

Hi,
Your code is a little messy...besides that the big stand out was this line;

if ($_POST['date_search']= 2004)

it should be...

if ($_POST['date_search'] == 2004)

[yellowchimp]

sorry I am messy.
I am only new to it and I'm not really sure how you are supposed to lay ii out.

I have tried putting another = sign in so that it looks like how you say it should be. But it still doesn't wot=rk :-(

[micmac]

Hi agian,
Nothing to be sorry about... 🙂
Try this:

if ($_POST['date_search'] == 2004) 
{ 
$result = odbc_exec($connect, "SELECT doc_date_yr, doc_url, doc_title 
FROM documents 
WHERE doc_date_yr=2004"); 

while ($row = odbc_fetch_array($result)) 
{
echo "<ul><li><a href='" . $row['doc_url'] . "'>'" . $row['doc_title'] . "'</a></li></ul>"; 
} 
} 
else 
{ 
echo "you didn't search for 2004" 
} 

[yellowchimp]

no that doesn't work either. Thanks anyway for trying

[micmac]

Are you getting any errors?....i need more info to help....i'm also about to crash so my thoughts aren't the best.

[yellowchimp]

I am not getting any errors.

I shall copy and paste my form code and then the code of the page that the form goes to (the code above basically)

I am also about to go so I will check back tomorrow

my form code is like this:

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

<!--create form-->
<form action="maria.php" method="POST">
<br>
Select a date:
<select name="date_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");

echo "

<option>$doc_date_yr</option>

";
}

?>
</select>

<input type="submit" />
</form>

and maria.php looks like this

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

if ($_POST['date_search'] == 2004)

{

$result = odbc_exec($connect, "SELECT doc_date_yr, doc_url, doc_title
FROM documents
WHERE doc_date_yr=2004");

while ($row = odbc_fetch_array($result))

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

}

}

else

{

echo "you didn't search for 2004"

}

odbc_close($connect);
?>

I use the form to select a year and I get a blank screen for maria.php.

It is the end of a long day and I am sure I have done something mind numbingly stupid.

I will check back tomorrow to see if anyone has seen anything wrong.

Many thanks

yellowchimp

[micmac]

OK..this should do it.
Change maria.php to:

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

if ($_POST['date_search'] == "2004") 
{ 
$result = odbc_exec($connect, "SELECT doc_date_yr, doc_url, doc_title FROM documents WHERE doc_date_yr=2004"); 
while ($row = odbc_fetch_array($result)) 
{ 
echo "<ul><li><a href='" . $row['doc_url'] . "'>'" . $row['doc_title'] . "'</a></li></ul>"; 
} 
} 
else 
{ 
echo "you didn't search for 2004"; 
}

odbc_close($connect); 
?>

[yellowchimp]

thank you very much. That seems to have done the trick. I did have to add some apostraphes round 2004 where it said doc_date_yr = 2004. I don't know why cause its a number - maybe becuase I have it as a text field in my table design.
I can carry on now and do more difficult things. Thank you again

[micmac]

You could have also passed the variable like:

$result = odbc_exec($connect, "SELECT doc_date_yr, doc_url, doc_title FROM documents WHERE doc_date_yr='" . $_POST['date_search'] . "'");  

Glad i could help 🙂