I tried GetSQLValueString($_POST[‘images’], “%s”));getting
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 1
And what does the manual tell you?
$_POST[‘images’]=‘images’; added code and fixed:smiley:
but now is problem name ,comment and images not same row in db
I ran into this problem a long time ago. It’s because newer versions of the MySQL
server requires you to insert data into NOT NULL
columns or have the column set to NULL
. IMO, you should already be setting your columns to NULL
and not NOT NULL
because it doesn’t make sense to have a NOT NULL
column when at times, that column will have nothing in there to begin with. NULL
and being an empty column IMO is pretty much the same thing. Since there is no data to present, the returned value will be a boolean
of false
.
i tried didn work
Set the column to NULL
, try the query again, and report back with what actually happened. Saying the word “doesn’t work” doesn’t really tell anyone anything.
Column ‘images’ cannot be null
that is what am getting
I am talking about setting the image column in the database as NULL
. Not in your code. If it doesn’t work, please provide the exact error message or a screenshot of it so we know what’s going on.
it is same message
Tomcat Started/Stopped with errors, return code: -1073741510
is this cause problem or maybe not
I have no clue what you are doing. Changing a column in your database doesn’t effect your Apache server. Can you please stick to the questions? I am guessing you are touching random things to get this to work which is actually making it worse. Just stick to the questions and directions.
ok
Tomcat is for JSP, not your regular PHP use so what you posted is way way off-topic.
I got fixed,i am good.
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.