Help with displaying selected dropdown menu on another page with related queries

maxves1 · April 5, 2010

Hello ,

Can anyone help me with displaying results of my php onto another page?

Heres the code I wrote for search category and it works fine :

<?php

include ('db_connect.php'); // DATABASE CONNECTION

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>

<head>

function reload(form)

{

var val=form.cat.options[form.cat.options.selectedIndex].value;

self.location='searchcat.php?cat=' + val ;

}

</script>

<!--

function confirm_dropdown()

{

if (f1.cat.options.selectedIndex == 0)

{

alert("Please select the Category.");

f1.cat.focus();

return (false);

}

if (f1.subcat.options.selectedIndex == 0)

{

alert("Please select the Products.");

f1.subcat.focus();

return (false);

}

return (true);

}

//--></script>

function MyReload()

{

window.location.reload();

}

//--></script>

</head>

<p><font face="Arial, Helvetica, sans-serif" size="2" align="Left">Search by Category</font></p>

<?

@$cat=$_GET['cat'];

if(strlen($cat) > 0 and !is_numeric($cat)){

echo "Data Error";

exit;

}

$quer2=mysql_query("SELECT DISTINCT category,cat_id FROM category order by category");

if(isset($cat) and strlen($cat) > 0){

$quer=mysql_query("SELECT DISTINCT prod_name FROM PRODUCTS where cat_id=$cat order by prod_name");

}

echo '<form method=post name=f1 action="dd-check1.php" onsubmit="return confirm_dropdown()">';

echo "<select name='cat' onchange=\"reload(this.form)\"><option value='' style= width:13em;>Select category</option>";

while($noticia2 = mysql_fetch_array($quer2)) {

if($noticia2['cat_id']==@$cat){echo "<option selected value='$noticia2[cat_id]'>$noticia2[category]</option>"."<BR>";}

else{echo "<option value='$noticia2[cat_id]'>$noticia2[category]</option>";}

}

echo "</select>";

echo "<br>";

echo "<select name='subcat' style= width:15em;><option value=''>Select products</option>";

while($noticia = mysql_fetch_array($quer)) {

echo "<option value='$noticia[prod_name]'>$noticia[prod_name]</option>";

}

echo "</select>";

echo "<br>";

echo '<input type=image src="back.jpg" srcname=btnback id=btnback onclick="history.go(-1);return false;"/>';

echo '<span style="padding-left:10px">';

echo '<input type=image src="button.JPG" >';

echo '</span>';

echo "</form>";

?>

</div></center>

<br>

</div></center>

</div> </center>

</body></html>

Now I saved this file onto my database as searchcat.php

you can check the link at:

http://faculty.poly.edu/~yjeanpie/searchcat.php

only problem is upon submission ,I want it to display results onto a new page "dd-check1" in this case, in such a way, that it displays the category and product selected and along with it, it displays relevant information related with the specific product for the category selected,

like say for example

"if i select software and photoshop "

I want it to show that on the other page along with the tutorial links i have in database and other relevant info "

My databse PRODUCTS looks like the file attached ( from where i want to retrieve other relevant results"

PLEASE HELP ME ASAP , i need to get this done within 2 weeks

any help will be honestly appreciated

[attachment deleted by admin]

Sign In

Help with displaying selected dropdown menu on another page with related queries

Recommended Posts

maxves1

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information