Hello ! Thanks for great application... I'm a newbie in php...
I need a button on list page that will show custom data from SQL ..
So i made:
- Add HTML code:
<input class=button type=submit value="CUSTOM LIST" name=submit2>
- Add code to the ListOnLoad event.
global $conn;
if ($_REQUEST["submit2"])
{
$str = "select * from TABLE where Data >= 'DATE1' and Data <='DATE2'";
$rs = db_query($str,$conn);
while($row = db_fetch_array($rs))
{
print_r($row); //<This will list the result but outside of list table
}
}
I don't know how to display the result of query in _list.php table .... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8057&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />
Help me please. What is correct syntax?.. Thank You...