While not working

From: Date: Thu, 19 Apr 2001 18:19:15 +0000
Subject: While not working
Groups: php.windows 
Request: Send a blank email to php-windows+get-6885@lists.php.net to get a copy of this message
Hy There; I'm trying to get a string from one table in my db. I'm using while to get get this data. But it's not working: Please see the following code , In the while tag I'm trying to get the USER_ID from my table, but it returns zero instead. What I'm doing wrong??? Thanks for a while !! Danilo Meles <? //conexão com o Banco include ("db.php"); //Selecao do db mysql_select_db("$DB") or die("Db não encontrado"); //Querys do programa $quser= "SELECT id_User, login, senha FROM user Where login ='$usuario'"; $qinsuser = "insert into user (login, senha) values ('$usuario', '$senha')"; $qbaseuser = "INSERT INTO AddressUser (Id_AddUser, UrlUser, IndiceUser) SELECT Id_User, Url, Indice FROM address"; $qveruser = "SELECT id_User, login, senha FROM user Where login = '$usuario'"; $qupuser = "UPDATE AddressUser SET Id_AddUser = '$id' WHERE Id_AddUser ='5'"; //verificação da caixa postal $mbox = @imap_open ("{paraisonet.com.br:143}INBOX", "$usuario", "$senha"); if (!$mbox): echo "Ooopsss !!!<br><br> Por favor se você é assinante da ParaisoNet, tente novamente. <br><br> Caso contrário clique aqui."; exit; endif; // pesquisa se usuario existe $queryuser = mysql_query("$quser")or die("a pesquisa de usuario falhou"); $Num = mysql_num_rows($queryuser); if (!$Num): //inserção de novo usuario $queryinsuser = mysql_query("$qinsuser")or die("a inserção falhou falhou"); // copia de registros de uma tabela para outra $querybaseuser = mysql_query("$qbaseuser")or die("a inserçao da base falhou"); // here is the while command. But the $id variable get zero (0) , and it should get the ID_USER from my db. What I'm doing wrong?? while ($dados = mysql_fetch_array($queryuser)): $id = $dados[id_User]; endwhile; // atualização do id do usuario $queryupsuser = mysql_query("$qupuser")or die("A atualização falhou"); if ($queryupsuser): echo "deu ceto"; echo "$id foda"; else: echo "deu errado"; endif; else: echo "usuario existente "; endif; ?>

« previous php.windows (#6885) next »