[ODBC] Last clan fight

Hello citizens,

I'm Rodi :: I'm releasing this script because alot people are having problems with MSSQL, and im working more on PHP these day's if you want some tutorials or something about PHP you can alway's message me.

From now on i will be on IcreamPIE or something...

live Previeuw : Last clanfight

Connection :

Code:

---

<?php
//Database Connection
        $dns="GunzDB";
        $user="sa";
        $pass="password";
        $connect=odbc_connect($dns, $user, $pass) or die ("Couldn't connect to the database, we're sorry...");
        odbc_exec($connect,"use GunzDB");
?>

---

Code:

---

<?php
include('config.php');
?>

<?php
//get latest clan fight
$query = odbc_exec($connect, "SELECT * FROM ClanGameLog WHERE id = (SELECT MAX(id) FROM ClanGameLog)");
odbc_fetch_row($query);
$winner = odbc_result($query, 4);
$loser = odbc_result($query, 5);
$Roundwins = odbc_result($query, 8);
$Winnermember = odbc_result($query, 6);
$RegDate = odbc_result($query, 12);

//writing the results to the screen
echo "The Clan <b>".$winner."</b>, Has owned the clan <b>".$loser."</b> with a total of <b>".$Roundwins."</b> wins by ".$Winnermember." on ".$RegDate."";
?>

---

Last clan fight OMG this is badass freaking awsome! thx

I love this it shows the stats of the latest fight :)

tnx rodi for giving me some credits?

Quote:

---

Originally Posted by jur13n

tnx rodi for giving me some credits?

---

hmm for?

Quote:

---

Originally Posted by remixgunz

hmm for?

---

lol there are like 5 scripts in the release section made by me and posted by you..
you know i helped allot with it...

Quote:

---

Originally Posted by jur13n

lol there are like 5 scripts in the release section made by me and posted by you..
you know i helped allot with it...

---

another lost soul.

Quote:

---

Originally Posted by jur13n

lol there are like 5 scripts in the release section made by me and posted by you..
you know i helped allot with it...

---

Are you serious? Made by you? Make a list please.
And check your scripts and the ones i posted. please?

-last clan fight > me
-newest char > me

i still got them.