[ MySQL ] Query Error
#1

// Fixed thanks
Reply
#2

Try:
PHP код:
mysql_format(SQLquerysizeof query"UPDATE `%s` SET `%s`='%d' WHERE `%s`='%d'"tablecolumnsqlIDsqlid); 
Reply
#3

PHP код:
mysql_format(SQLquerysizeof query"UPDATE `%s` SET `%s`='%d' WHERE `%s`=%d"tablecolumnvaluesqlIDsqlid); 
You forgot to pass the value that you wanted to be updated

Quote:
Originally Posted by StRaphael
Посмотреть сообщение
Try:
PHP код:
mysql_format(SQLquerysizeof query"UPDATE `%s` SET `%s`='%d' WHERE `%s`='%d'"tablecolumnsqlIDsqlid); 
That does same thing but worst, it will not gonna use the index for the sqlID so it makes it a bit slower
Reply
#4

Код:
mysql_format(SQL, query, sizeof(query), "UPDATE %s SET %s=%d WHERE %s=%d", table, column, value, sqlID, sqlid); 
mysql_tquery(SQL, query);
Reply
#5

I'm retarted I had a missing parametar...
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)