Query Question

[refiking]

Is this runnable?  I want to change the lid of the records using the lid field to identify the records to change.  Here is the code as is:

 

mysql_query("UPDATE dreg SET lid = '$newlid' WHERE lid = '$lid' AND sid = '$sid'")or die(mysql_error());

[947740]

Looks fine to me.

[Fadion]

Why not try it yourself??  ???

[947740]

I was kind of thinking that too, but I thought I would give him an answer.

[refiking]

That's just it.  I tried it and it didn't change the record.

[947740]

Ah.  You made it sound like you had not tried it and were just curious if it would work.

 

Try this:

 

mysql_query("UPDATE dreg SET lid = \"$newlid\" WHERE lid = \"$lid\" AND sid = \"$sid\"")or die(mysql_error());

 

If that does not work, I would double check all of your table and columnames.

[refiking]

Nope.  Didn't work and didn't return an error.

[947740]

You need a connection to the database.  E.G.

 

$cxn = mysqli_connect($host,$user,$password,$db);

$sq1 = "UPDATE messages SET Message=\"$message\" WHERE MessageNumb=\"$id\"";

$result = mysqli_query($cxn,$sq1);

 

In this case:

$connection = mysqli_connect($host,$user,$password,$db);
$query = "UPDATE dreg SET lid = \"$newlid\" WHERE lid = \"$lid\" AND sid = \"$sid\"";
$result = mysqli_query($connection,$query);

[refiking]

I've already connected to the db.  I have about 8 queries before this one that work fine.

[947740]

I doubt this makes a difference, but try removing the spaces on both sides of the = sign in the query.

 

Other than that, I am gathering that some names are wrong, whether it be columnames or something else.  It does not make any sense why it is not working.

[Fadion]

The php/mysql syntax is right. This thread wont get u anywhere with only that code u posted, so check your variables and column/table names, or post the entire code (related to that specific part).