LinHES Forums
http://forum.linhes.org/

Email query Mysql "SOLVED"
http://forum.linhes.org/viewtopic.php?f=6&t=17652
Page 1 of 1

Author:  glennph93 [ Thu Jan 17, 2008 9:20 am ]
Post subject:  Email query Mysql "SOLVED"

Hello,

I'm trying to use this script which queries Mysql for Html of the recorded programs to email from: http://mysettopbox.tv/phpBB2/viewtopic.php?t=1617&postdays=0&postorder=asc&highlight=sendemail&start=15
and the part thats tripping me up is when I use this part:
Code:
mysql -p xxxx -H -e " select title from recordedprogram where date_sub(curdate(),interval 0 day) <= starttime" mythconverg

All its returning is the help message(long with all switches)
I don't know much about Mysql (1 billion $$).

Any help would be apperciated

I am running R5F27

Author:  glennph93 [ Thu Jan 17, 2008 9:43 am ]
Post subject: 

Ok I figured out my problem it was the space between -p and my password.

Thanks anyways.

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/