RE: [PHP] R: [PHP] SQL Query Not Kosher?

2004-02-04 Thread Ford, Mike [LSS] 
On 03 February 2004 13:45, Alessandro Vitale contributed these pearls of
wisdom:

 try removing curly braces as follows:
 
 $query = mysql_query(UPDATE stories SET status='approved'
WHERE story_id={$id}); |

Nothing wrong with the above, it's perfectly valid -- just a slightly
different way of writing:

 $query = mysql_query(UPDATE stories SET status='approved'
 WHERE story_id=${id}); 

Cheers!

Mike

-- 
Mike Ford,  Electronic Information Services Adviser,
Learning Support Services, Learning  Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS,  LS6 3QS,  United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730  Fax:  +44 113 283 3211

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] R: [PHP] SQL Query Not Kosher?

2004-02-03 Thread Alessandro Vitale 
try removing curly braces as follows:

$query = mysql_query(UPDATE stories SET status='approved' WHERE
story_id={$id});
   |
   |
   |
  \/
$query = mysql_query(UPDATE stories SET status='approved' WHERE
story_id=$id);

or

$query = mysql_query(UPDATE stories SET status='approved' WHERE
story_id=${id});



this applies if story_id is of type int in mysql table definition, or you
should enclose it among '' if is of type char, varchar or similar.

cheers

alessandro




-Messaggio originale-
Da: Mr. Austin [mailto:[EMAIL PROTECTED]
Inviato: martedì 3 febbraio 2004 5.35
A: [EMAIL PROTECTED]
Oggetto: [PHP] SQL Query Not Kosher?


Hi all:

I am trying to get this to work, but always get the same error: that the
resource in mysql_affected_rows() is not valid.  Anyone see why this would
be?  All variables have been tested for accuracy.

$query = mysql_query(UPDATE stories SET status='approved' WHERE
story_id={$id});
  if(mysql_affected_rows($query) == 1) {
print(Your approval of \$title\ was successful.  If this user entered
an email address, they have been sent a notice of its approval and
publication on the site.);
  } else {
print(The approval of \$title\ was not successful.  Please check with
the site administrator for assistance.);
  }

The above SQL statement works perfectly with phpMyAdmin (and, oddly enough,
works with the above script, yet the Warning is produced and the 'not
successful' message is displayed)  Any thoughts are appreciated!

Mr. Austin

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php