Jump to content

Archived

This topic is now archived and is closed to further replies.

niza

Problems updating the database

Recommended Posts

[code]$connection = mysql_connect($host, $user,$password)
or die ("Couldn't connect to server.");
$db = mysql_select_db($database, $connection)
or die ("Couldn't select database.");
$sql = "UPDATE ad SET adName='$adName', adInfo='$adInfo', adPrice='$adPrice' WHERE adID='21'";
$result = mysql_query($sql) or die("Couldn't modify database.");
mysql_close($connection); [/code]

This is the error I get: Couldn't modify database. Anyone knows what is happening and why I cannot update the database?

I checked all tables in the database for spelling mistakes and the variables. But I found no mistakes.

Share this post


Link to post
Share on other sites
Use this, the error then may be a bit more helpful than what you currently have.
[code]$result = mysql_query($sql) or die(mysql_error()); [/code]

Share this post


Link to post
Share on other sites
I found the problem and I've fixed it. Now it updates the database but with nothing. I have no values in the database, only empty fields.

Share this post


Link to post
Share on other sites
Never mind. The variables were not being passes. I used this to get the variables:

$adName = $_POST['adName'];
$adInfo = $_POST['adInfo'];

And now it works.

Is there any way I can get the variables through a loop or something rather then manually give each variable a value?

Share this post


Link to post
Share on other sites
The variables have to be passed to the page somehow.

Where are they coming from? If we can get a better understanding of this then we can help.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.