Forums

[solved]Update sql doesn't work

lopezio 13 May, 2011
Hi
In my server valiadation I need to uplaod one table. I wrote the following code:

$nova_passe='123' ;
$username='Grupo1';
$db1 =& JFactory::getDBO();
$query1 = "
  UPDATE alunos_brotero_tic set Passe='$nova_passe' WHERE Username='$username'  
";
$db1->setQuery($query1);


But it doesn't work. Any help?
nml375 13 May, 2011
Hi,
You are missing the JDatabase->Query() method invocation to actually send your query to the database.
$nova_passe='123' ;
$username='Grupo1';
$db1 =& JFactory::getDBO();
$query1 = "
  UPDATE alunos_brotero_tic set Passe='$nova_passe' WHERE Username='$username' 
";
$db1->setQuery($query1);
$db1->Query();


/Fredrik
lopezio 14 May, 2011
Thank you friend
Works fine
This topic is locked and no more replies can be posted.