What I do is create a shell script file and utilize OS' pipe function and a text browser to create the HTML file.
For example: create a text file called generate.sh
lynx -source http://someURL.com/yourCode.asp > yourStaticASP.html
lynx -source http://someURL.com/yourCode.php?Var=123 > yourStaticPHP.html
and do a chmod on the file, make sure it is executable, e.g., chmod u+x generate.sh
You may then schedule this script file in your cron table ;-)
<form name="aform" action="somewhere.php" method="post">
<input type="hidden" name="firstName" value=" <?php echo $firstName ; ?> ">
<input type="hidden" name="lastName" value=" <?php echo $lastName ; ?> ">
<input type="hidden" name="section" value="0">
</form>
Simply add a little JavaScript somewhere in the <head> ... </head> part of your page and we're done. The JavaScript would look something like this...
function clickpost(param)
{
document.forms.aform.elements .section.value = param;
document.forms.aform.submit;
return true;
}
Let's suppose we have a table look like this
Name PhoneNumber
-------------- --------------------
Peter 415-895-5689
John 408-854-4587
Louis 408-975-5986
RowNumber Name PhoneNumber
----------------- -------------------- ---------------------
1 Peter 415-895-5689
2 John 408-854-4587
3 Louis 408-975-5986
SELECT rownum, Name, PhoneNumber from table;However, MySQL does not offer such convinience as rownum. In MySQL, we need to do the following instead.
mysql> SET @rownum := 0;
mysql> SELECT @rownum := @rownum + 1 AS RowNumber, Name, PhoneNumber from table;Hope this tip can help you solve your current problem :)
