wicked mysql parse

phatmoon

My ISP is running mysql 3.23...

Their server hates me...

This mysql_query...

UPDATE tbl_dealers SET passwd = password( 'test456' ) WHERE username = 'testuser'

MySQL said: Unknown column 'passwd' in 'field list'

Anyone familiar with IPOWERWEB Host's mysql setup? Because the column exists...

kerodeon

im not a hundred percent sure, but i think ur not supposed to quote the column names, that may be ure problem, and also password( 'test456' ) is a variable, should have $ sign in front.

eg, right code:

UPDATE tbl_dealers SET passwd = $password( 'test456' ) WHERE username = 'testuser'

dunno if this works, cant try it on my server, different MySQL version.

laserlight

Quoting the column names with backticks is generally okay.

Are you sure the name (and case) is correct?

Run a DESCRIBE query or something to confirm.

phatmoon

Thanks for your help...

What I've discovered from Googling around is that Mysql 3.23 doesn't support UPDATE...SET...WHERE...too well. BTW backticks make this server happy. What I'm thinking is I need to develop a script that substitutes for UPDATE...SET...WHERE...

This works:

$result = mysql_query("SELECT passwd FROM tbl_dealers WHERE 1 AND username = 'testuser'")
or die('mysql_query: failed');
$num_results = mysql_num_rows($result);
echo $num_results;

So I probably can't just reassign:

mysql_num_rows($result)=password('test456');

can I?

laserlight

That's strange, I think that version of mysql is quite common, and I've never had such problems with it.

I'm not sure what are the alternatives to that, you'll might have to try the mysql manual at mysql.com

Trying to re-assign with
mysql_num_rows($result)=password('test456');
simply wont work.

phatmoon

Thanks for your help...

OK... I was mistaken. UPDATE...SET...WHERE...works. It is just a finicky server. It needs a space between the backtick and the field_name.

Like:

UPDATE tbl_dealers SET passwd = password('test456') WHERE username = 'testuser'

instead of:

UPDATE tbl_dealers SET passwd = password('test456') WHERE username = 'testuser'

and notice also that username doesn't need backticks in this instance.