[PHP]Last Clan Created

[Military]

Hello , I was working on this script out of the idea of this and because I'm trying to get better at PHP. It was a pain doing this for a newbie like me but after some references from Google and Secured I got it done.

Script

<?php

// Newest Clan - Military

$_MSSQL[Host]               = "\SQLEXPRESS";
$_MSSQL[User]               = "sa";
$_MSSQL[Pass]               = "";
$_MSSQL[DBNa]               = "GunzDB";

$r = mssql_connect($_MSSQL[Host], $_MSSQL[User], $_MSSQL[Pass]) or die("Cant connect to database");
mssql_select_db($_MSSQL[DBNa], $r) or die("Selection Failed");

$newclan = mssql_query("SELECT TOP 1 * FROM CLAN WHERE DeleteFlag = 0 ORDER BY regdate DESC");
$row = mssql_fetch_row($newclan);

if(mssql_num_rows($newclan) != 1) {
	echo "No Data!";
	}
	else
	{
	echo "The Last Clan Created was $row[1] and it was created on $row[9]";
	}

?>

Screenshot



Credits
Secured - Showing me how to get it done after countless mistakes(Didnt use your way)
iCreamPie(Rodi) - Making the script and from where I took the idea
Google - Helping Me along the way
SuperWaffle - Giving me deleteflag.

Please Click The Like Button + Rep If You Like

[MentaL]

[Dave]

Tip: If you want faster queries then select the column(s) which you want to use/show.

SELECT TOP 1 * FROM CLAN ORDER BY regdate DESC
becomes
SELECT TOP 1 Name FROM CLAN ORDER BY regdate DESC

Maybe also change the query so it will not show a deleted clan. :)

[Military]

Tip: If you want faster queries then select the column(s) which you want to use/show.

SELECT TOP 1 * FROM CLAN ORDER BY regdate DESC
becomes
SELECT TOP 1 Name FROM CLAN ORDER BY regdate DESC

Maybe also change the query so it will not show a deleted clan. :)

Thanks for the tips bro.

[Secured]

;) Your getting better haha <3

[Military]

Updated it not to include deleted clans , thanks to SuperWaffle.

[TalkingBot]

nice. its useful

[Choroupaarou]

This is very easy.
Still worth O_o

[Military]

This is very easy.
Still worth O_o

I'm doing tiny scripts as I haven't got a website to code.

[Choroupaarou]

I'm doing tiny scripts as I haven't got a website to code.

So good luck :)

[Vusion]

echo "The Last Clan Created was $row[1] and it was created on $row[9]";

Would be nicer and easier if you'd insert the row's name in quotation(strings)

echo "The Last Clan Created was $row["Name"] and it was created on $row["RegDate"]";