search code

NZ_Kiwi

if you select bartercard Cup it will list only items which have BCC set to 1 on my mysql table

this lists all my news not just the one with say BCC set to 1...

										
<form method="POST" action="index.php?action=ALL">
											<p> <span lang="en-au">


 <select name="area" size="1">
                  <option value="MAIN">General NZ</option>
                  <option value="BCC">Bartercard Cup</option>
                </select></span></p>
																			<p align="center">
											<input type="submit" value="Submit" name="B1" style="border-style: solid; border-width: 1px"></p>
										</form>




			 <?php


if ($action == "ALL")
{ 


mysql_connect (localhost, root, y4worl);
mysql_select_db (bevan);

$result = mysql_query ("SELECT * from news where $area = 1");

while ($row = mysql_fetch_array($result)) {
?>

<a href="http://www.rugbyleaguenz.com/news.php?id=<?php echo $row["id"];?>">
<font color="#000000"><?php echo $row["header"];?><br>
</font></a><?php



}

}

?>
										<p></p>

TheDefender

What exactly do you need help with here?

I will say this... This doesn't look right:

$result = mysql_query ("SELECT * from news where $area = 1");

My guess is that it should look more like this:

$result = mysql_query ("SELECT * FROM news WHERE area = '".$_POST['area']."'");

NZ_Kiwi

Originally posted by TheDefender
What exactly do you need help with here?

I will say this... This doesn't look right:
$result = mysql_query ("SELECT * from news where $area = 1"); 
My guess is that it should look more like this:
$result = mysql_query ("SELECT * FROM news WHERE area = '".$_POST['area']."'"); 
[/B]

well in my SQL table with my news ect it has options such as BCC... if i want to add news to this area of my website i set the value of this to 1!! now i want a general web form with a drop down menu of all the sections as options and if a user selects one such as BCC it will then display all the results with BCC set to 1..... do you know what i mean??

what you told me did not work

TheDefender

Yeah, it makes sense. There's probably better ways to accomplish this, but if that's how you are doing it, then your query should probably look more like this:

$result = mysql_query ("SELECT * FROM news WHERE ".$_POST['area']." = '1'");