Hey thanks! I will give this a try too. Scott pointed me to a great
example he made and it solved the problem!
/Benjamin
Josh Mellicker wrote:
Wow! One I might be able to help on.
___
In Revolution, put this script into your option menu:
ON menupick pChoice
put pChoice into queryValue
put pChoice chosen into field status
get libUrlFormData(queryvalue, queryValue)
post it to url
http://www.yourweburl.com/thepathtoyour/phpscript.php;
IF the result is empty THEN -- executed OK
put it into fld listOfFiles
ELSE
put the result into field task_desc -- there was some
error in executing the PHP script
END IF
END menupick
___
Now, make a text file on your server (called phpscript.php or
whatever.php):
?php
require_once('dbinfo.inc'); //this is the file with your connect info
$sql =
SELECT
myFileName
FROM
fileNameTable
;
$result = mysql_query($sql) or die(Error # . mysql_errno() . : .
mysql_error() );
if (mysql_num_rows($result)) {
//found at least one
while ($row=mysql_fetch_array($result)) {
echo $row['myFileName'].\n;
}
} else {
//didn't find any
echo I did not find any records.;
}
?
On Feb 16, 2006, at 9:59 PM, Benjamin Bacon wrote:
Hi everyone,
I am trying to create two pull down menu's that are based on MySQL
query's. Then based on what the user choses from the pull down menu's
they can get a listing of available files based on what is already in
the database. Can anyone help me on this one. I greatly appreciate
the help. I am quite fresh with Revolution development and I have
look in the manual and searched the web/documentation.
Thanks!
Benjamin
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution