Drop Down List Page Direct

[chr158]

Hi There,

I have a simple drop down list that a user will use to select the DB that they wish to modify.
Question 1;
How can I create an alias for the table so that rather than showing xyz it would show Table 1?

Question 2:
Dependant on the table the selevted I need to direct the user to the page relevant to their selection. The pages are called TABLENAME.php, but i couldn't get the direct to work at all.

<form action="main2.php" method="GET">

<table width="350" border="0" align="center" bgcolor="#CCCCCC">
<tr>
<td colspan="2"><div align="center"><font size="2" face="Arial"><strong>Please select the table that you would like to modify, using
the selection list below</strong></font></div></td>
</tr>
<tr>
<td><div align="right"><font face="Arial">Table Name:</font></div></td>
<td>


<?php


$sql = "SELECT id, name, xtype FROM sysobjects WHERE (xtype = 'u') ORDER BY name";

$sql_result = mssql_query($sql) or die("Couldn't execute query.");
$row = @mssql_fetch_array($sql_result);

echo "

<select name=\"table_select\">";

while ($row = @mssql_fetch_array($sql_result))
{
$Name = $row["name"];
$Id = $row["id"];

echo "
<option value=\"$Name\">$Name</option>";
}
echo "
</select>
";
?>


</td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<input type="submit" name="Submit" value="Continue">
</div>
</td>
</tr>
</table>
</form>

Anyhelp would be much appreciated

[paulnaj]

Question 1: If you don't want your users to see the 'actual' database name, then you could use an associative array in the script to translate ...

$nice_name = array("xyz" => "Table 1", "abc" => "Table 2");

$res = mysql_query("SELECT ...");
while($obj = mysql_fetch_object($res)){
$display_name = $nice_name[$obj->actual_name];
...
}

Question 2: You are going to have to let us see the file main2.php or whatever the file is that responds to the form action to understand your problem.

[chr158]

Cheers PaulNaj

I have sorted question 2 myself using onclick jacascript - silly really.

Do you know why the code below is now returning me the correct number of options in the list but the text isn't visable (apart from the please select)? The value is right for my redirect because that works still.

<?php
$sql = "SELECT id, name, xtype FROM sysobjects WHERE (xtype = 'u') ORDER BY name";
$sql_result = mssql_query($sql) or die("Couldn't execute query.");
$row = @mssql_fetch_array($sql_result);

$nice_name = array
("itcommodity" => "Commodities",
"mnparams" => "Parameters",
"srcty" => "City",
"srsic" => "SIC CODE",
"srvat" => "VAT",
"srvrate" => "VAT RATE",
"srvregister" => "VAT Register"
);

while ($row = @mssql_fetch_array($sql))
{
$display_name = $nice_name[$row->actual_name];
}

echo "
<select name=\"table_select\" onChange=\"return jump(this);\">
<option value=\"\">Please Select</option> ";
while ($row = @mssql_fetch_array($sql_result))
{

$Name = $row["name"];
$Id = $row["id"];
echo "<option value=\"$Name.php\">$display_name</option>";
}
echo "
</select>
";
?>

[sdjensen]

$display_name is not set. Shouldn't you be using $Id?

echo " 
<select name=\"table_select\" onChange=\"return jump(this);\"> 
<option value=\"\">Please Select</option> "; 
while ($row = @mssql_fetch_array($sql_result)) 
{ 

$Name = $row["name"]; 
$Id = $row["id"]; 
echo "<option value=\"$Name.php\">$Id</option>"; 
} 
echo " 
</select> 
"; 

[paulnaj]

Yes, you were just getting a bit mixed up ... this'll do it (Bsdjensen(/😎[/B] is correct, but isn't including the 'nice_names').

<?php
$sql = "SELECT id, name, xtype FROM sysobjects WHERE (xtype = 'u') ORDER BY name";
$sql_result = mssql_query($sql) or die("Couldn't execute query.");
$row = @mssql_fetch_array($sql_result);

// I'm assuming that the values "itcommodity", "mnparams" etc. are from the 'name' columns
// as opposed to the 'id' column from sql query.
$nice_name = array
("itcommodity" => "Commodities",
"mnparams" => "Parameters",
"srcty" => "City",
"srsic" => "SIC CODE",
"srvat" => "VAT",
"srvrate" => "VAT RATE",
"srvregister" => "VAT Register"
);

echo "
<select name=\"table_select\" onChange=\"return jump(this);\">
<option value=\"\">Please Select</option> ";

while ($row = @mssql_fetch_array($sql_result)) {
$Id = $row["id"];
$Name = $row["name"];
echo "<option value=\"$Name.php\">".$nice_name[$Name]."</option>";
}
echo "</select>";
?>

---

paulnaj

[chr158]

Yes - i realised about 20 minues after posting.

Thank you both for your help.

Certianly makes my project stand out a bit an dwork superbly.

Cheers