web, connecting to SQL - need help!

[Faraonekkk]

Please help, how i can make a web script that search. I mean i already have script but how to make it search this:

If vocation = 1
than on site is icon with gold coin
when vocation 2
icon with crystal coin ;P

Please help

 

[Faraonekkk]

found this

if($redskull == 0) {
$main_content .= '<TD><img src="images/deer.gif"/></TD></TR>';
}



HEEEEEEELP

 

[Milice]

$l = mysql_connect("localhost", "root", "toor");
mysql_select_db($l, "db");
$x = mysql_query("SELECT * FROM players");
$y = mysql_fetch_array($x);
$voc = $y["vocation"];

if($voc == 1){
$main_content .= '<img src="images/gold_coin.gif"/>';
}

change root / toor to your username / password for the database

 

[Faraonekkk]

thanks my hacker i'll check it

 

[Faraonekkk]

i just added it and its still write 0 and 1 ;/

its to search

$l = mysql_connect("localhost", "root", "pass");
mysql_select_db('db');
$x = mysql_query("SELECT * FROM players");
$y = mysql_fetch_array($x);
$redskull = $y["redskull"];

if($redskull == 0){
$main_content .= '<img src="http://otland.net/images/rotworm.gif"/>';

and

echo '<tr><td></td><td><font color="white">'.htmlspecialchars($a['redskull']).'</font></a></td></tr>'."\n";

not works ;/ help

 

[Faraonekkk]

also tryed:

echo '<tr><td></td><td><font color="white">'.$redskull.'</font></a></td></tr>'."\n";

and its same, write 0 or 1 :/ no image ehh please help..

 

[Faraonekkk]

Now i see, there is problem with

$main_content .= '<img src="http://otland.net/images/gold_coin.gif"/>';

any other ideas how to print screen?

 

[Faraonekkk]

have it but part of select from sql not works ;/

 

[Faraonekkk]

its not reading from sql

$redskull = $y["redskull"];

heeeeeeelp

 

[Faraonekkk]

$serwer = "localhost"; // nazwa serwera mysql
$login = "root"; // login do bazy
$haslo = "xxxx"; // haslo do bazy
$baza = "xxxx"; // nazwa bazy
$tabela = "players"; // nazwa tabeli
$dzial = $y["redskull"]; // red skull test
if (mysql_connect($serwer, $login, $haslo) and mysql_select_db($baza)) {
if ($dzial == 0) {
echo '<span style="color:white"><img src="http://otland.net/images/rat.gif" ></span>'."<br/>\n";

dude, when its 0 its showing image BUT, one player have redskull 1 and its showing for him too :/

Really please help guys, or just small idea for me how to make?