query help...

Henri

Hello,

I coded this but it returns "There was a database updating problem"

can anyone tell me what I'm doing wrong?

thanx a lot


$query = mysql_query("INSERT INTO 'RPGI_wallpaper' ('link') VALUES ('$content')", $linkid);
if ($query == TRUE) {
$log .= "The wallpaper was successfully uploaded<br>";
}
else
{
$log .= "There was a database updating problem.<br>";
}
}

echo "$log";

diego25

I don't think you can have single quotes around the table name. Try removing them.

Diego

Henri

I removed the sigle quotes but the problem is still there🙁

any other idea whats wrong?

diego25

Use the function mysql_error to see what's wrong.

Diego

Henri

okay, I get it now.

in $content, it gos kind of like so: onmouseover=\"this.className='opacity_100'\"

the single quotes must be confusing the VALUES(' command. is there a special character that "cancels-out" a single quote, kind of like \ cancels out a double quote?

evo4ever

Get rid of the last brace! whats $linkid? What data is defined to it?

Henri

last brace?

$linkid is info about the sql database ($linkid = mysql_connect('localhost','ffn3t','password') or die("Couldn't connect to database host.);

diego25

Use mysql_escape_string to escape the quotes and whatnot in the string.

Diego

Henri

it worked, thanx a lot😉