Unknown database problem

Homer_simpson · **Posted:** Tue Aug 05, 2003 1:33 am

this is my command

code:

<?
include 'mysqlfunctions.php';
$link=connectmysql();
mysql_select_db("backstabbers");

$query="UPDATE userinfo SET ps='$passid' WHERE id='$id'";
$result = MySQL_query ($query,$link);

?>

I get no error or warning but the thing just doesn't work...!!! Crying or Very sad

Amailer · **Posted:** Tue Aug 05, 2003 1:44 am

Could you post the connectmysql function
(all passwords taken out and replaces with PASSWORD Very Happy

)

Damm mac can't do anything on it!

EDIT:
k try this... hmm

code:

<?
include 'mysqlfunctions.php'; //I think this is the file name hmm...

$link = connectmysql();

mysql_select_db("backstabbers" ,$link);

$result = mysql_query("UPDATE userinfo ". "SET pas='$passid' . "WHERE id='$id'");

?>

if i did not make any mistakes -.- it should be right Very Happy

PaddyLong · **Posted:** Tue Aug 05, 2003 1:07 pm

I think that
$result = mysql_query("UPDATE userinfo ". "SET pas='$passid' . "WHERE id='$id'");

should be more like

$result = mysql_query("UPDATE userinfo SET pas=".$passid." WHERE id=".$id);

you had your .'s in places where they shouldn't be and stuff ...

Amailer · **Posted:** Tue Aug 05, 2003 1:17 pm

Hmm...
It don't matter...

The . is just to seperate the stuff,
cuz i just find it better that way Very Happy

IDK thats how i started off Confused

Still works Very Happy

Homer_simpson · **Posted:** Tue Aug 05, 2003 1:29 pm

well that connectmysqlf function works properly i'm sure of it cuz i use it in everyfile... and i didn't need to use any . when i wanted to insert to mysql... this is one of those errors that's gonna take me sometime to figure out Crying or Very sad

Amailer · **Posted:** Tue Aug 05, 2003 1:31 pm

Wait it did nto get solved?
Hmmm
whats the error?

PaddyLong · **Posted:** Tue Aug 05, 2003 2:27 pm

the . is used to attach two strings ... like in turing you do like
someString := string1 + " " + string2
in PHP it's
$someString = $string1 . " " . $string2

Amailer · **Posted:** Tue Aug 05, 2003 2:42 pm

Ya,
But still i like it that way...thats how i learned it Very Happy

Homer_simpson · **Posted:** Fri Aug 08, 2003 4:08 pm

btw i got it working using connectiong separate strings using . stupid php Razz

Amailer · **Posted:** Fri Aug 08, 2003 5:13 pm

Homer_simpson wrote:

stupid php Razz

PhP is not stupid...

its just the programmer...who makes his script stupid Very Happy

Homer_simpson · **Posted:** Fri Aug 08, 2003 7:06 pm

ah... so that's y people sayi'm stupid...TY Laughing

Amailer · **Posted:** Fri Aug 08, 2003 7:45 pm

hmm....ya.....

	Computer Science Canada Programming C, C++, Java, PHP, Ruby, Turing, VB Username: Password: Register
Wiki Blog Search Turing Chat Room Members