Two options, either you extend the CustomFields addon to create a new field, "DropDown from DB" or something. If you know Perl you could probably use the info allready in CustomFields and FakeSQL to accomplish this, but since you donÃ‚Â´t I think this is to much hazzle. The other scenario (since you know PHP) is that you create a PHP script that fetches the content from the movie table and create a file instead, then you use the "DropDown From File"-field which is available in CustomFields. Read more in the addon how the file should be formatted.Fenice wrote:1) When a user post a news, he can select to which movies already in the mysql database the article is related. I would like to let them do so by selecting one or more movies from a list populated with movie titles in the movies table in the database. How can I do this?
I would say that using the LWP::Simple module would be a good idea, with that you can execute a URL. Do a search for LWP in the forum and you will end up with some threads. A very simple example of how to use it would be:Fenice wrote:2) Once the news has been posted, I would like to execute a separate php script to update my movies mysql table's "last updated" field with the date the news was posted. I would do this through Coranto, but I am no good in perl. So I prefer to execute a separate php script on my server and pass it the game id and the new date (updatemovietable.php?gameid=20&date=2004-06-05). How can I do this?
my $result = get("http://www.domain.com/updatemovietable.php?gameid=20&date=2004-06-05");
Users browsing this forum: No registered users and 1 guest