[RELEASE] Show LW Winner on your site

[corey88]

Hello guys!
this script is to show in ur site the LW winner!
NEEDS CONFIG.PHP!!

PHP Code:

<?
  function LegNome($id){
        $sql = "SELECT * FROM cq_syndicate WHERE id = '".$id."'";
    $res = mysql_query($sql);
    $leg = mysql_fetch_array($res);
    return $leg['NAME'];
}
$lw = mysql_query("SELECT * FROM cq_map WHERE id = '1100'");
$owner = mysql_fetch_array($lw);
$ocupante = $owner['owner_id'];
echo LegNome($ocupante);
?>

Credits: Me.
Enjoy!

[hio77]

good work on this, something i personally didn't look into at all.. just a few little tips you could take into consideration for your next script

it would be better to use sql like this..

SELECT `NAME` FROM cq_syndicate WHERE id = $id

SELECT owner_id FROM cq_map WHERE id = 1100

have a little read into why using wildcard (*) is bad..

but in saying that here is how i would do this sql

SELECT `NAME` FROM cq_syndicate WHERE id = (SELECT owner_id FROM cq_map WHERE id = 1100)

many other ways you could do a joined sql but in all it comes down to how you want to do it, using a code like this you have now reduced down to as little as 1 line (as messy as that would be :L )

myself, ild move onto using PDO, its more universal and just straight out is better without getting down into things, however this gets onto OOP.

-hio77

[Syahmi Eo]

Where To Put It?

<?
function LegNome($id){
$sql = "SELECT * FROM cq_syndicate WHERE id = '".$id."'";
$res = mysql_query($sql);
$leg = mysql_fetch_array($res);
return $leg['NAME'];
}
$lw = mysql_query("SELECT * FROM cq_map WHERE id = '1100'");
$owner = mysql_fetch_array($lw);
$ocupante = $owner['owner_id'];
echo LegNome($ocupante);
?>

[cruey]

In the code of your PHP file that your website uses.

[Sir*DeviL]

Save this as a .php file and define the location...
then add this to wherever you want your script...

<?phpinclude("your directory for your file")?>