Hi
I have a situation that need to do
[CODE]
$sql2="select * from agents where id='$id' limit 1 ";
$result2=mysql_db_query("DB",$sql2);
$regist2=mysql_fetch_array($result2);
$name=$regist2["name"];
and so on....
TO CHANGE EXISTENT USER DATA:
<table>
<tr>
<td>
<? if($id){ ?>
ID: <? echo $id ?>
</td>
</tr>

<? } ?>
TO CREATE A NEW USER:
<tr>
<td>
<? } else if ($activ==0 ) { ?>
Register: New User
</td>
</tr>
<? } ?>
</table>

DATA COMMON TO BOTH SITUATIONS:
<table>
<tr>
<td width="121" align="right"><span class="style3">Nome (Broker/Agent)</span></td>
<td colspan="2" align="left"><input name="nome" type="text" class="input" id="nome" value="<? echo $nome ?>" size="62" /></td>
</tr>
and so on...
<tr>
<td align="center">&nbsp;</td>
<td align="left"><input type="submit" name="<? if(!$id) { echo "Save"; } else { echo"Change"; } ?>" id="button" value="<? if(!$id) { echo "Save"; } else { echo"Change"; } ?>" >
</td>
</tr>
</table>

Now: The first situation is no problem. The changes are saving in the DB.
But the second is not saving.
can somebody explain-me why?
thanks

I don't understand your issue....
If you want to include code, include it all.
If you want to give us pseudo code, give it complete.

You gave us some bit of php, without sql logic and out of context, and you expect us to tell you where the problem is ?

Originally Posted by tripy

I don't understand your issue....
If you want to include code, include it all.
If you want to give us pseudo code, give it complete.

You gave us some bit of php, without sql logic and out of context, and you expect us to tell you where the problem is ?

Thanks for your reply.

here it is the two file attached that with a full codes.

I hope that you can understand better now.

Thanks

1. Where from $id comes?
2. Is there some error/warnig messages? (switch on the messages display)

Originally Posted by MapMaster

1. Where from $id comes?
2. Is there some error/warnig messages? (switch on the messages display)

At the begining I made a code without the else if, just to create a NEW USER. It worked ok. But now due the fact I need time to time to change USERS DATA I introduced the statment else if, then I end up having problems to create NEW USERS, but manage to change USERS DATA without a problem.

the steps are :

1. register new user. That's where I have a problem. If I don't use the else if situation I can register the new user. It record into DB.

2. If a user is created, it's Id is the ID of the DB (autoincrement).
That is working. The <? echo $id ?> is to give-me the ID of the already created user.

Hope this clarify you.

I can't see the $Salvar variable creation in you code. And you?

Originally Posted by MapMaster

I can't see the $Salvar variable creation in you code. And you?

Hi

I'ved translated the code for you due be in portuguese language. It is $Save ($Salvar)

Thanks for the trouble