Forum Webscript.Ru

Программирование => PHP => Тема начата: eugz от 20 Марта 2006, 19:24:08

Название: Hide/Show row(s)
Отправлено: eugz от 20 Марта 2006, 19:24:08

Hi All.
I create form/page and would like to show whole row(s) under NOTE-1 if value of field TYPE is 3 exist and hide whole row(s) under NOTE-1 if value of field TYPE is 3 doesn\'t exist`for according ID. And I would like to show whole row(s) under NOTE-2 if value of field TYPE are 1 or 2 exist and hide whole row(s) under NOTE-2 if value of field TYPE are 1 or 2 doesn\'t exist for according ID. That is my code.


include (\'Connections/dbconn.php\');

if (!($connection = @ mysql_pconnect($hostname, $username, $password)))
die("Could not connect to database");
if (!mysql_select_db($dbName, $connection))
showerror( );

$ID = $_REQUEST[\'ID\'];
?>

$query1 = "SELECT ID, Type, Date, Note
FROM dbo.Test
WHERE ID = " . $ID;
if (!($result1 = @ mysql_query($query1, $connection)))
showerror( );
while($row1 = mysql_fetch_array($result1))
{
$formVars = array( );
$formVars[\'Type\'] = $row1[\'Type\'];
$formVars[\'Date\'] = $row1[\'Date\'];
$formVars[\'Note\'] = $row1[\'Note\'];

if ($formVars[\'Type\'] == 3)
{
?>













}
if ($formVars[\'Type\'] == 1 || $formVars[\'Type\'] == 2)
{
?>













}
?>

">
	DATE	NOTE-1
	if(isset($formVars[\'Date\']) && $formVars[\'Date\'] != "") { $formVars[\'Date\'] = date("m/d/Y", strtotime($formVars[\'Date\'])); } ?> " size="20">	" size=107>
	DATE	NOTE-2
	if(isset($formVars[\'Date\']) && $formVars[\'Date\'] != "") { $formVars[\'Date\'] = date("m/d/Y", strtotime($formVars[\'Date\'])); } ?> " size="20">	" size=107>

Thanks.