You might want to try actually running the query.
mysql_query ($query);
or
mysql_query ($query,$db);
depending on your preference.

-----Original Message-----
From: Beauford [mailto:beauford.2003@;rogers.com]
Sent: Thursday, November 14, 2002 1:53 PM
To: [EMAIL PROTECTED]
Subject: Update help


Hi,

I'm trying to update a table from my webpage but not having much luck,
although it works from the command line. Obviously I am missing
something and would appreciate any help.

Also. Is there a good tutorial or help page for Mysql. I find the one at
www.mysql.com not very helpful.

TIA

The code:

<?

$db =mysql_connect("url","name","pass");
mysql_select_db("dbasename");
$query = "UPDATE counter SET number=number+1";


?>



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to