SQL to php (Beginners....)
I have a SQL task and I need to add this to a cron to automate it. I have
tried to create a .php file to make the routine but really I don't know
why its not working.
The SQL is:
UPDATE software SET nodepsoft = ( SELECT COUNT(*) FROM links WHERE sftwr
LIKE concat('%', software.softwarename, '%') AND approved = 'yes')
This SQL works okay but I need to create a php file with this update
function and I need to output (echo or print) the result of the query.
Can anyone help me, please?
No comments:
Post a Comment