MySQL?

[cdkid]

ok...i have an ASP page that writes a form with a bunch of fields to a DB....i wanna read the Varchar field called 'Charname' & assign a variable to that...any help would be much appricaited

--thanks

[computergeekxp]

I only know php but an example would be:

Quick piece of code:

mysql_connect(localhost,"USERNAME","PASSWORD");
@mysql_select_db($_GET["DB"]) or die( "Unable to select database");

$query = "
    SELECT `".$_GET["VAR"]."`
    FROM `".$_GET["TBL"]."`
";

$result=mysql_query($query);
//if u want, add some error handling here

echo mysql_result($result,0,$_GET["VAR"]);

//close the DB here

Then just call the webpage from autoit (query.php?DB=database&TBL=tablename&VAR=variablename)...This isn't too secure though and you might want to find a way to do a "post" from autoit so the user name and password can be passed, not allowing just anyone to acces your database

Edited January 18, 2006 by computergeekxp

[cdkid]

alright, thanks...it doesn't really need to be secure it's just for a SuperGroup (like a guild) in COH...making auto-join script

--thanks for ur help