problem whit dinamic list/menu (select form object)

[rsantos]

hi,

"be patient. my english is poor, very"

i have a update form with 2 field list/menu (select object):

this field must be to show some data of the your source table but the select record must be equal to X field of the primary table.

ex:

table Person (id, name, last, idcountry, idstate)
table Country (idcountry, country)
table State (idstate, state)

if me have a Person update form. i have two select form object:
sel_country(Country table) and sel_state(state table). ok?

this select form object must be show too the value of de idcountry and idsatate of the Person current form record.

well,

php show me only one select but not 2. the page is blank.

there is a code:

    <select name="idcountry">
      <?php 

do {

?>
<option value="<?= $row_country['idcountry']?>" <?php if (!(strcmp($row_country['idcountry'], "$row_person['idcountry']"))) {echo "SELECTED";} ?>><?= $row_country['country']?></option>
<?php
} while ($row_country = mysql_fetch_assoc($country));
?>
</select>

Where this code set the person's value to show

<?php if (!(strcmp($row_country['idcountry'], "$row_person['idcountry']"))) {echo "SELECTED";} ?>

without this code, the page work succesfull, but with it, no work.

php send a message: too many server behaviors

some help please,

I hope you understand me

thanks

[paulnaj]

Hi,

Does this work?

<select name="idcountry">
<?php 
$idp = $row_person['idcountry']; // Assumes $row_person is already defined
while ($row_country = mysql_fetch_assoc($country)){
  $idc = $row_country['idcountry'];
  echo '<option value="'.$idc.'"'.($idc == $idp? ' SELECTED': '').'>'.$idp.'</option>';
}
?> 
</select>

P.

[rsantos]

thanks, but this code do not work.

select do not take the Person value and do not work 2 select a the same time.

the other code work one per page but not 2 per page

thanks again

[paulnaj]

You have ...

(1) $row_country = mysql_fetch_assoc($country)){

...

That means there should be a line like:

(2) $country = mysql_query('SELECT ... ');

Can you show me the code from (1) to (2).

[rsantos]

the page is build with the dreamweaver form udate wizard:

<?php require_once('conn.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;

case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}

$editFormAction = $SERVER['PHP_SELF'];
if (isset($SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($POST["MM_update"])) && ($POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE clientes SET rut=%s, sucursal=%s, empresa=%s, idgiro=%s, direccion=%s, comuna=%s, ciudad=%s, idzona=%s, telefono=%s, fax=%s, email=%s, contacto=%s, idvendedor=%s, tipocliente=%s WHERE idcliente=%s",
GetSQLValueString($POST['rut'], "text"),
GetSQLValueString($POST['empresa'], "text"),
GetSQLValueString($POST['idgiro'], "int"),
GetSQLValueString($POST['idvendedor'], "int"),

mysql_select_db($database, $conn);
$Result1 = mysql_query($updateSQL, $conn) or die(mysql_error());
}

mysql_select_db($database, conn);
$query_clientes = "SELECT * FROM clientes";
$clientes = mysql_query($query_clientes, conn) or die(mysql_error());
$row_clientes = mysql_fetch_assoc($clientes);
$totalRows_clientes = mysql_num_rows($clientes);

mysql_select_db($database, conn);
$query_giros = "SELECT * FROM giros";
$giros = mysql_query($query_giros, conn) or die(mysql_error());
$row_giros = mysql_fetch_assoc($giros);
$totalRows_giros = mysql_num_rows($giros);

mysql_select_db($database, conn);
$query_vendedores = "SELECT idvendedor, nombre FROM vendedores";
$vendedores = mysql_query($query_vendedores, conn) or die(mysql_error());
$row_vendedores = mysql_fetch_assoc($vendedores);
$totalRows_vendedores = mysql_num_rows($vendedores);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Documento sin t&iacute;tulo</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Idcliente:</td>
<td><?php echo $row_clientes['idcliente']; ?></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Empresa:</td>
<td><input type="text" name="empresa" value="<?php echo $row_clientes['empresa']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Idgiro:</td>
<td>
<select name="idgiro">
<?php
do {

?>
<option value="<?= $row_giros['idgiro']?>" <?php if (!(strcmp($row_giros['idgiro'], "$row_clientes['idgiro']"))) {echo "SELECTED";} ?>><?= $row_giros['giro']?></option>
<?php
} while ($row_giros = mysql_fetch_assoc($giros));
?>
</select>
</td>

<tr valign="baseline">
  <td nowrap align="right">Idvendedor:</td>
  <td>
    <select name="idvendedor">
      <?php 

do {

?>
<option value="<?php echo $row_vendedores['idvendedor']?>" selected<?php if (!(strcmp($row_vendedores['idvendedor'], "$row_clientes['idvendedor']"))) {echo "SELECTED";} ?>><?= $row_vendedores['nombre']?></option>
<?php
} while ($row_vendedores = mysql_fetch_assoc($vendedores));
?>
</select>
</td>

<tr valign="baseline">
  <td nowrap align="right">&nbsp;</td>
  <td><input type="submit" value="Actualizar registro"></td>
</tr>

</table>
<input type="hidden" name="MM_update" value="form1">
<input type="hidden" name="idcliente" value="<?php echo $row_clientes['idcliente']; ?>">
</form>
<p>&nbsp;</p>
</body>
</html>
<?php
mysql_free_result($clientes);

mysql_free_result($giros);

mysql_free_result($vendedores);
?>

[rsantos]

this select code work only 1 per page but 2 not work

[paulnaj]

Ok ... I'm confused ... where is $country etc. ?

[rsantos]

sorry, the case of country is a example because i need to traslate my comments.

this is the true code

Clientes(Client)
Giros (Roll)
Vendedores (sales man)

[paulnaj]

Ok , is this the whole page? ... there seems to be a couple of unusual things.

1) Look for the sprint() function in the code. It is not complete.
But, this problem may only show up if you try to 'update'.

2) Also, if you are updating, the calls to mysql_select_db() and mysql_query() use the connection $conn. But, later, calls to these functions use conn. So, you will have to look in the file 'conn.php' to see if the connection id is ... $conn ... or ... conn

---

I think I need some more explanation:

Do you see any items in the Clientes select box?
Do you see any items in the Giros select box?
Do you see any items in the Vendedores select box?

[rsantos]

is that correct:

1- is $conn
2- error in paste
3- is not there clientes select box. that is my table to update

giros and vendedores select box is show at the same time, only without:

<?php if (!(strcmp($row_vendedores['idvendedor'], "$row_clientes['idvendedor']"))) {echo "SELECTED";} ?>

and

<?php ((strcmp($row_giros['idgiro'] , "$row_clientes['idgiro']")) ? echo "SELECTED"); ?>

but do not show the Clientes current record value.

can show too if there are only one of this select box, inluding the refered code

go the code again:

<?php require_once('conn.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;

case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}

$editFormAction = $SERVER['PHP_SELF'];
if (isset($SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($POST["MM_update"])) && ($POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE clientes SET rut=%s, sucursal=%s, empresa=%s, idgiro=%s, direccion=%s, comuna=%s, ciudad=%s, idzona=%s, telefono=%s, fax=%s, email=%s, contacto=%s, idvendedor=%s, tipocliente=%s WHERE idcliente=%s",
GetSQLValueString($POST['empresa'], "text"),
GetSQLValueString($POST['idgiro'], "int"),
GetSQLValueString($_POST['idvendedor'], "int"));

mysql_select_db($database, $conn);
$Result1 = mysql_query($updateSQL, $conn) or die(mysql_error());
}

mysql_select_db($database, $conn);
$query_clientes = "SELECT * FROM clientes";
$clientes = mysql_query($query_clientes, $conn) or die(mysql_error());
$row_clientes = mysql_fetch_assoc($clientes);
$totalRows_clientes = mysql_num_rows($clientes);

mysql_select_db($database, $conn);
$query_giros = "SELECT * FROM giros";
$giros = mysql_query($query_giros, $conn) or die(mysql_error());
$row_giros = mysql_fetch_assoc($giros);
$totalRows_giros = mysql_num_rows($giros);

mysql_select_db($database, $conn);
$query_vendedores = "SELECT idvendedor, nombre FROM vendedores";
$vendedores = mysql_query($query_vendedores, $conn) or die(mysql_error());
$row_vendedores = mysql_fetch_assoc($vendedores);
$totalRows_vendedores = mysql_num_rows($vendedores);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Documento sin t&iacute;tulo</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Empresa:</td>
<td><input type="text" name="empresa" value="<?php echo $row_clientes['empresa']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Idgiro:</td>
<td>
<select name="idgiro">
<?php
do {

?>
<option value="<?= $row_giros['idgiro']?>" <?php if (!(strcmp($row_giros['idgiro'], "$row_clientes['idgiro']"))) {echo "SELECTED";} ?>><?= $row_giros['giro']?></option>
<?php
} while ($row_giros = mysql_fetch_assoc($giros));
?>
</select>
</td>

<tr valign="baseline">
  <td nowrap align="right">Idvendedor:</td>
  <td>
    <select name="idvendedor">
      <?php 

do {

?>
<option value="<?php echo $row_vendedores['idvendedor']?>" <?php if (!(strcmp($row_vendedores['idvendedor'], "$row_clientes['idvendedor']"))) {echo "SELECTED";} ?>><?= $row_vendedores['nombre']?></option>
<?php
} while ($row_vendedores = mysql_fetch_assoc($vendedores));
?>
</select>
</td>

<tr valign="baseline">
  <td nowrap align="right">&nbsp;</td>
  <td><input type="submit" value="Actualizar registro"></td>
</tr>

</table>
<input type="hidden" name="MM_update" value="form1">
<input type="hidden" name="idcliente" value="<?php echo $row_clientes['idcliente']; ?>">
</form>
<p>&nbsp;</p>
</body>
</html>
<?php
mysql_free_result($clientes);

mysql_free_result($giros);

mysql_free_result($vendedores);
?>

[paulnaj]

Rsantos,

Sorry I haven't replied yet ... not enough time last night ... will look again tonight.

PS Are you Spanish? If yes, explain a little in Spanish if you want. I can get a translation.

P.

[rsantos]

hey!!!!!

i dided!!!

work!!!!!!!!

thanks you very much,

i put this sentences after select box:

$rows = mysql_num_rows($giros);
if($rows > 0) {
mysql_data_seek($giros, 0);
$row_giros = mysql_fetch_assoc($giros);
}

that is, the code was thus:

<select name="idgiro" class="verdana10negra">
<?php
do {

?>
<option value="<?php echo $row_giros['idgiro']?>"<?php if (!(strcmp($row_giros['idgiro'], $row_clientes['idgiro']))) {echo "SELECTED";} ?>><?php echo $row_giros['giro']?></option>
<?php
} while ($row_giros = mysql_fetch_assoc($giros));
$rows = mysql_num_rows($giros);
if($rows > 0) {
mysql_data_seek($giros, 0);
$row_giros = mysql_fetch_assoc($giros);
}
?>
</select>

now all select box works perfectly!!!!!!

you have been a great aid.

it cheers me that in places like this it is
possible to be had people like your that they are interested to help
the others to solve its problems.

I am thankful to you again and
thousand times in addition.

your commentaries and suggestions more
forced to think more to me to be able to transmit better the idea

together we have obtained it

this is very important to me.

thanks again.

P.D. i'm cuban but live in Chile 4 years ago

[paulnaj]

No problemo!

It's a pleasure.