I am soo confused

Anon

Hey I keep getting help on here. And everyone is just awsome on here. Well I have a problem. What is wrong with this script??? I can manually go in there (SSH) in and change it with the Update function. But when i try to do it from a php file it just wouldnt work. The host says that they did it and it worked (Jumpline.com) So I don't know what is up. Can someone please help me not be so confused. Thanks!
Chad

<?php
$db = mysql_connect("localhost","olentang","Winblows");
mysql_select_db("olentangriver_org", $db);
$super = "UPDATE general SET homemission='This updated.'";
mysql_query($super);
?>

Anon

looks like you need a WHERE condition in your SQL statement.

Anon

hey this is my first time on here and i don't know nothing about php i just wanted to know if u can tell me how can i add the php and whats a good php builder i can get and if u know any good books to teach me php or a baisc site to get me started thank you much

toma42

Don't you need to pass a database handle to the mysql_query function?

You really should be using a database abstraction layer and not worry about this...I recommend pear (pear.php.net)

Anon

Mike Essentials of PHP from Princeton Hall Books. Just look it up on Barnes And Nobles. Its a great book that will teach you the essentials of PHP (Hint being teh name) and then you come on here where real professionals will help you with your coding. You guys are great! Tom (I did have that in there and still didnt work) David (You don't actually need a "where" clause. It will update the whole database) So anymore help? Thanks!
Chad

Anon

i like pears they taste good

ranam

I assume you're running the script from the server (ie the script is not in your hard drive)? Try something like this:

$SESS_DBH= mysql_connect($SESS_DBHOST, $SESS_DBUSER,$SESS_DBPASS) or die("Could not connect");

mysql_select_db($SESS_DBNAME,$SESS_DBH) or die("Could not select database");

$qry = mysql_query("UPDATE table_name SET field_name=\"value\"",$SESS_DBH) or die("Query failed");

If you are having errors atleast you'll know where.

ranam

Mike,

there's a lot of very very good tutorials on the net for free. Try them out.

http://www.devshed.com/Server_Side/PHP/PHP101/PHP101_1/page1.html

http://www-106.ibm.com/developerworks/education/r-php.html?n-l-5171

and not to mention this site. 🙂