[RESOLVED] Output > If interger between certain values show picture ???

[Clarkie]

Hi there,

Thanks to everyone who helps here. I recently wrote a script, with the help of some brilliant people here, which when you enter a username is either adds it to the database or finds it and gives that user 1 point. In my output code it displays the results in a table.

However I want an extra column. I have a column which outputs the username and a column which outputs the points that person has. I need a column which reads the number of points and if it is between certain values it shows 1 picture etc.

I can replace the output text with the image code but for now if somebody can help they can simply post the text here in:

• 0-2 Private

• 3-6 Corporal

• 7-11 2nd Lieutenant

• 12-18 Lieutenant

• 19-27 Captain

• 28+ Field Marshall

Here is the current output code:

<?php
$con = mysql_connect("DB CONNECT","USERNAME","PASS");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("DB NAME", $con);

$result = mysql_query("SELECT * FROM DB TABLE");

echo "<table border='1' align='center' width='80%'>
<tr>
<th>Username</th>
<th>Rank Points</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['username'] . "</td>";
  echo "<td>" . $row['points'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>

Thanks for any help 🙂

[Pikachu2000]

if( $row['points'] >= 0 && $row['points'] <=2 ) {
     echo "<img src=\"private.png\">";
} elseif ( $row['points'] > 2 && $row['points'] < 7 ) {
     echo "<img src=\"corporal.png\">";
} elseif ( // etc., etc.

[Clarkie]

Wow you guys are clever! Testing now thanks very much for the incredibly quick response. You should be in the rapid response unit! 🙂

Hmm I can't seem to find where to put this to make it function. I'm sure it's the correct script but where exactly does it go?

My guess would be here:

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['username'] . "</td>";
  echo "<td>" . $row['points'] . "</td>";
  echo "<td>" . $row['[COLOR="Red"]CODE GOES HERE[/COLOR]'] . "</td>";
  echo "</tr>"; 

Unfortunately this outputs a blank white screen.

[Weedpacket]

It goes in the spot where you want the image tag to appear (since that is what it produces).

Clarkie wrote:

Unfortunately this outputs a blank white screen.

That's because the code doesn't go there 🙂. Replace that whole line with Pikachu2000's code (with "<td>" and "</td>" added on either side of "<img...>").

[Clarkie]

Ahh! Thank you very much. PHP is complicated... It's going to take a while to learn.

EDIT: I still get a blank page. This is the current code:

<?php
$con = mysql_connect("DB CONNECT","USERNAME","PASS");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("DB NAME", $con); 

$result = mysql_query("SELECT * FROM Clan");

echo "<table border='1' align='center' width='80%'>
<tr>
<th>Username</th>
<th>Rank Points</th>
<th>Predicted Rank</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['username'] . "</td>";
  echo "<td>" . $row['points'] . "</td>";
  if( $row['points'] >= 0 && $row['points'] <=2 ) {
     echo "<td><img src="1.png" alt="Private"></td>";
} elseif ( $row['points'] > 2 && $row['points'] <=6 ) {
     echo "<td><img src="2.png" alt="corporal"></td>";
}
  elseif ( $row['points'] > 6 && $row['points'] <=11 ) {
     echo "<td><img src="3.png" alt="2nd Lietenant"></td>";
}
  elseif ( $row['points'] > 11 && $row['points'] <=18 ) {
     echo "<td><img src="4.png" alt="Lietenant"></td>";
}
  elseif ( $row['points'] > 18 && $row['points'] <=27 ) {
     echo "<td><img src="5.png" alt="Captain"></td>";
}
  elseif ( $row['points'] > 27 ) {
     echo "<td><img src="6.png" alt="Field Marshall"></td>";
}
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>

[bradgrafelman]

You have syntax errors on lines like this:

echo "<td><img src="1.png" alt="Private"></td>"; 

Double quotes must be escaped (e.g. preceded by a backslash) in a double quote delimited string. See this manual page for more information: [man]string[/man].

[Clarkie]

Ah thanks. My mate told me what the slashes before and I solved it by using the single speech mark (') inside the image 🙂

[Weedpacket]

That's certainly a valid way to do it (and probably nicer to look at); both HTML/XML attribute values and PHP strings can be either single or double quotes, so it's often convenient to pick one for one and use the other for the other. It's a matter of personal/house style.

The two quoting mechanisms do have differences, of course. PHP handles 'stri\ng' a bit differently from "stri\ng", as the page bragrafelman cited explains. But there is also a difference on the HTML side, with double-quoted attribute values needing to use &quot; to represent a " and &#39; to represent a ' (it really ought to be be &apos;, but Internet Explorer is a bit dim that way.)