Mysql help/PHP

[Jxhn]

Is your database storeing the values as integers or strings? (I don't know too much about MySQL so forgive me if that was a silly question).

EDIT: I think you need to get the script to store them in the database as just numbers and get the php script to convert them to thrones and hcs etc.

[Habtopia]

Is your database storeing the values as integers or strings? (I don't know too much about MySQL so forgive me if that was a silly question).

EDIT: I think you need to get the script to store them in the database as just numbers and get the php script to convert them to thrones and hcs etc.

If i could answer i would lol, do you know how to check

[I replied the second u edited HA]

[Jxhn]

The only solution I can think of without editing the script is to save the values as 001HCs 015HCs etc, but that would look quite bad.

[Habtopia]

The only solution I can think of without editing the script is to save the values as 001HCs 015HCs etc, but that would look quite bad.

Yeah i though of that too but then thougt ud have to filter the '0s' somehow lol

[Jackboy]

Yeah i though of that too but then thougt ud have to filter the '0s' somehow lol

Lookup explode() , I suppose that could be used. Something like that.

If you PMed me explaining what u want I would fix.

[Jxhn]

Lookup explode() , I suppose that could be used. Something like that.

If you PMed me explaining what u want I would fix.

I'm not sure that would work. This should:

$value = $row['valuesorwe'];
if(substr($value, 0, 2 == "00")
$value = substr($value, 2);
else if(substr($value, 0, 1 == "0")
$value = substr($value, 1);
echo $value; 

Still a messy solution. The way they are added to the database should really be changed.

[Habtopia]

I'm not sure that would work. This should:

$value = $row['valuesorwe'];
if(substr($value, 0, 2 == "00")
$value = substr($value, 2);
else if(substr($value, 0, 1 == "0")
$value = substr($value, 1);
echo $value; 

Still a messy solution. The way they are added to the database should really be changed.

where in the script would this be inserted?

[Jxhn]

where in the script would this be inserted?

I think the quotes got messed up in the PMs.

<?php
include("config.php");
include("opendb.php");
$get_cats = mysql_query("SELECT * FROM `categories` ORDER BY `displayorder`") or die(mysql_error());
$get_info = mysql_query("SELECT * FROM `systeminfo`") or die(mysql_error());
$info = mysql_fetch_array($get_info);
while($cats = mysql_fetch_array($get_cats)) {
$get_rares = mysql_query( "SELECT * FROM `rares` WHERE `catid`='{$cats ['id']}' ORDER BY `value` DESC" ) or die( mysql_error() );
echo("<b><center><font face=verdana size=1> &nbsp; &nbsp;".$cats['name']."</font></center></b><br>
<table width=\"466\" border=\"0\">
");
$color1 = $info[stripe1];
$color2 = $info[stripe2];
$row_count = 0;
while($rare = mysql_fetch_array($get_rares)) {
$row_color = ($row_count % 2) ? $color1 : $color2;
?>
<td>
<td width="15%" style="text-align:center;background-color:#<?php echo $row_color; ?>"><font face=verdana size=1><?php echo $rare['name']; ?></font><br><font face=verdana size=1><img alt="" src="<?php echo("".$info[imagepath]."".$rare['image'].""); ?>"><br>
<?php
$value = $rare['value'];
if(substr($value, 0, 2 == "00")
$value = substr($value, 2);
else if(substr($value, 0, 1 == "0")
$value = substr($value, 1);
echo $value;
?> HC</font></td>
</td>
<?php
$row_count++;
if($row_count==6){
echo '</tr><tr>'; //close and open a row if $row_count=;6
$row_count=0;
}
}
echo("</table><br>
");
}
?>

[Habtopia]

Parse error: syntax error, unexpected T_VARIABLE in /home/habjay/public_html/values/show_rares.php on line 23

[Jxhn]

<?php
include("config.php");
include("opendb.php");
$get_cats = mysql_query("SELECT * FROM `categories` ORDER BY `displayorder`") or die(mysql_error());
$get_info = mysql_query("SELECT * FROM `systeminfo`") or die(mysql_error());
$info = mysql_fetch_array($get_info);
while($cats = mysql_fetch_array($get_cats)) {
$get_rares = mysql_query( "SELECT * FROM `rares` WHERE `catid`='{$cats ['id']}' ORDER BY `value` DESC" ) or die( mysql_error() );
echo("<b><center><font face=verdana size=1> &nbsp; &nbsp;".$cats['name']."</font></center></b><br>
<table width=\"466\" border=\"0\">
");
$color1 = $info[stripe1];
$color2 = $info[stripe2];
$row_count = 0;
while($rare = mysql_fetch_array($get_rares)) {
$row_color = ($row_count % 2) ? $color1 : $color2;
?>
<td>
<td width="15%" style="text-align:center;background-color:#<?php echo $row_color; ?>"><font face=verdana size=1><?php echo $rare['name']; ?></font><br><font face=verdana size=1><img alt="" src="<?php echo("".$info[imagepath]."".$rare['image'].""); ?>"><br>
<?php
$value = $rare['value'];
if(substr($value, 0, 2) == "00")
$value = substr($value, 2);
else if(substr($value, 0, 1) == "0")
$value = substr($value, 1);
echo $value;
?> HC</font></td>
</td>
<?php
$row_count++;
if($row_count==6){
echo '</tr><tr>'; //close and open a row if $row_count=;6
$row_count=0;
}
}
echo("</table><br>
");
}
?>