niche Posted June 5, 2012 Share Posted June 5, 2012 (edited) I'm doing some debugging and just discovered UPDATE doesn't create a mysql resource (makes sense when I think about it). Is there a work around available? If not I suppose I'll use a timestamp. Edited June 5, 2012 by niche 1 Link to comment Share on other sites More sharing options...
justsomeguy Posted June 5, 2012 Share Posted June 5, 2012 Here's the section in the manual about that: For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error.For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error. I'm not sure what kind of workaround you're looking for. What do you need in a return value? Link to comment Share on other sites More sharing options...
niche Posted June 5, 2012 Author Share Posted June 5, 2012 I want to visually verify the UPDATE without having to visually sort rows. My table has a timestamp so I'll use the in a SELECT. Thanks for your help jsg. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now