This might be easier using the mysqli extension, but the function mysql_info
will give you a string result indicating information about the most recent
string, just as you would from the command line.
The rows matched is what you're looking for, which appears first in the
string, so you should
whats the col type of the bible-verse_ref field? If its not a numeric field
(ie autonumber key) then perhaps consider adding one, and updating on that
key...
Bastien
From: "Ron Piggott" <[EMAIL PROTECTED]>
Reply-To: "Ron Piggott" <[EMAIL PROTECTED]>
To: "PHP DB"
CC: "Bastien Koert" <[EMAIL P
did test to see if $id was actual the value you were expecting? is $id an
auto increment field?
Chris Payne <[EMAIL PROTECTED]> wrote in message
000c01c1a23a$ef779900$0200a8c0@chris">news:000c01c1a23a$ef779900$0200a8c0@chris...
Hi there,
Can anyone see what is wrong with this query? I am trying
Off of MySQL.com:
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]
So a typical UPDATE command could be
UPDATE email_table SET email = '[EMAIL PROTECTED]' WHERE id =
'1';
For explanations of all args and options,
A few things to check:
1. You have a connection to the database (I'm assuming you do).
2. mysql_query() is a php function so you should not put a dollar sign
before it (indicating it is a variable. If you want mysql_query() to return
a variable, do something like this: $result = mysql_query("UPDA
