results in citymenue demo real estates

Sam,
all menu items are created in the ListOnLoad event.

Here is a sample code:

$message="";

Hi jane,
thank you for suggestion, it works.
sam <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=15596&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />

Sam

I'm not getting this>

1. Do I add the code on the specific table's Events on the List Page: On Laod - I tried - get parse error.
   
   Parse error: parse error, unexpected $ in /usr/www/users/golfen/golfendb/include/_Tournaments_events.php on line 16
   
2. If I have Table: _Tournamentsand ID: TourID and the table I want the totals on: TournamentName, what would the code look like?
   My code that does not work:
   function ListOnLoad()
   
   {
   
   $message="";
   
   $str = "select count(ID) (Tried TourID as well) as numbers, TournamentName from _Tournaments group by TournamentName";
   
   $rs = db_query($str,$conn);
   
   while ($data = db_fetch_array($rs))
   
   {
   
   $town= str_replace(" ","+",$data["TournamentName"]);
   
   $message = "<a href=\"_Tournaments_List.php?a=search&value=1&SearchFor=".$TournamentName."&SearchOption=Contains&SearchField=_TournamentName\">".$data["TournamentName"]." (".$data["numbers"].")</a>";
   
   echo $message."
   ";
   
   }

Stephan,
there are two sintax errors in your code: you've forgot closed bracket } and used undefined variable $TournamentName.

Here is the correct code:

function ListOnLoad()

I strongly recommend you to learn PHP and SQL before writing your events:

http://www.webcheatsheet.com/php/

http://www.w3schools.com/php/default.asp

http://www.php.net/manual/en/