Link to home
Start Free TrialLog in
Avatar of fackz
fackz

asked on

INSERT not working

Hey experts, I have a problem with a INSERT command.

I already checked my field names in my database.
I tried to echo out all fields and everything is working fine.

I don't know why my query is not working....any ideas?  
<?php
 
$salvatd = "INSERT INTO garotas (nome, telefone, idade, cidade, tipo, peso, busto, altura, foto1, foto2, foto3, ensaio, plano, lembrete, nomecompleto, nascimento, rg, termo1, termo2, data, login.id) VALUES ('$nome', '$tel', '$idade', '$cidade', '$tipo', '$peso', '$busto', '$altura', '$fotocapa', '$foto2', '$foto3', '$fazerensaio', '$plano', '$lembrete', '$nomecompleto', '$nascidaem', '$rg', '$leutermos','$infoverdadeira','$data','$usuario')";
								mysql_query($salvatd);
									if(mysql_affected_rows() > 0 ){
										echo "<div class=\"rosa\"><b>success</b></div>";
										exit;
									}else{
										echo "<font color=red><b>Error, try again</b></font>";
										echo "<br>Se este erro persistir, entre em contato conosco através do link <i>Suporte/Ajuda</i> no menu ao lado.";
										exit;
									}
?>

Open in new window

SOLUTION
Avatar of itzdarc
itzdarc
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial