next »

[TechnicalTalk]

 TechnicalTalk » Programming and Web Development » PHP
 PHP/MySQL cannot update table?

[Anchor]

Anchor  

 PHP/MySQL cannot update table?

Hi guys, I have this simple piece of code and I want to be able to update a field in one of my database tables. It keeps saying that 'Error adding:No database selected'...
Can someone please take a look and tell me what I am doing wrong?

[polas]

polas  

 Re: PHP/MySQL cannot update table?

Cut and paste here what the code is, without that its impossible to know where you are going wrong. Are you logging into and selecting the database correctly - from what you have said it seems like there may be an issue there. This topic may help you figure out where you are going wrong, http://www.technicaltalk.net/index.php/topic,623.0.html - make sure you are opening the database like I did in the 1st two lines of the code I posted

[BusterKeaton]

BusterKeaton  

 Re: PHP/MySQL cannot update table?

'Error adding:No database selected'...
only means that you didnt put your data base info...
make sure you will put the databasehost, databasename. databaseuserand databasepassword...

heres an example:
$dbname = "HERE"; //change to your mysql database name
$dbhost = "localhost"; //database host name
$dbuser = "HERE"; //database user
$dbpass = "HERE"; //database password

[polas]

polas  

 Re: PHP/MySQL cannot update table?

From my understanding, it is not enough to simply set those variables, you need to do something with them (such as the functions mysql_connect and mysql_select_db)

[adiv_rulez]

adiv_rulez  

 Re: PHP/MySQL cannot update table?

Hi guys, I have this simple piece of code and I want to be able to update a field in one of my database tables. It keeps saying that 'Error adding:No database selected'...
Can someone please take a look and tell me what I am doing wrong?

Post your code so we can help you better.

[polas]

polas  

 Re: PHP/MySQL cannot update table?

It is not exactly what you are after, but the code I posted sometime ago on this thread http://www.technicaltalk.net/index.php/topic,623.0.html might be useful