What I am trying to do is on the first webpage. There is a Studio dropdown
(information from the MySQL database) menu. When someone picks a studio
the results go to a different webpage showing just the movies in that
studio. How do I get the results onto the second page?
How can I do it in dreamweaver?
This is from the first page that has the dropdown menu. Is the method=post
or get?
<?php require_once('Connections/videodb.php'); ?>
<?php
mysql_select_db($database_videodb, $videodb);
$query_Recordset1 = "SELECT * FROM studios ORDER BY studios.StudioName ASC";
$Recordset1 = mysql_query($query_Recordset1, $videodb) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_videodb, $videodb);
$query_Recordset2 = "SELECT * FROM titles";
$Recordset2 = mysql_query($query_Recordset2, $videodb) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
?>
<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<body>
<form action="/VOD/results1.php" method="post" name="StudioForm"
id="StudioForm">
<select name="StudioMenu"
onchange="if(this.selectedIndex!=0){document.StudioForm.submit();}"
class="dropleft">
<option value="0" <?php if (!(strcmp(0, $row_Recordset2['StudioID'])))
{echo "SELECTED";} ?>>Studios</option>
<?php
do {
?>
<option value="<?php echo $row_Recordset1['StudioID']?>"<?php if
(!(strcmp($row_Recordset1['StudioID'], $row_Recordset2['StudioID']))) {echo
"SELECTED";} ?>><?php echo $row_Recordset1['StudioName']?></option>
<?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>
</select>
</form>
</body>
</html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
