Re: CREATE PROCEDURE with variables?
Lose SELECT ...
> INSERT INTO Blogs
> VALUES( Title, Body, Top, Bottom, CURDATE(), CURTIME() )
If Title, Body, Top, Bottom are column names, MySQL will have no way of distinguishing those params from column names, so your Insert will insert Nulls. Best to adopt a param convention like prefixing each name with a param-indicator eg ptitle, pbody &c.
And against possible table changes, it's always best to specify the column names.
And proper-casing & Hungarian casing of database object identifiers can cause mischief in MySQL, best avoid them.
So ...
insert into blogs (title,body,top,bottom,datecol,timecol)
values( ptitle,pbody,ptop,pbottom,Curdate(),Curtime() );
BTW is there some reason you are keeping data & time in separate columns? It appears these cols track current events. Why not use Timestamp?