Few vbcoding queries

[Marco van Herwaarden]

What is the value of $result['colscore']?

[veenuisthebest]

any integer between 1 to 10. But when 10 is the value, it doesn't select in list box !

[Dismounted]

Is that value "10" when it's meant to be "10"?

[veenuisthebest]

YES... sure !

I told in my second last post that 10 displays fine when using text-field BUT does not select through list box.

[Marco van Herwaarden]

Then what are you trying with:

PHP Code:

$score["$scor[0]"] = 'selected="selected"'; 


Why use $scor[0] when it is just an text value and not an array? $scor[0] will just return the first character, so if the value is "10" it will return "1":

PHP Code:

<?php
$result['colscore'] = "10"; 
$scor = $result['colscore']; 
echo "<br />Var result[colscore]: " . $result['colscore'];
echo "<br />Var scor: " . $scor;
echo "<br />Var scor[0]: " . $scor[0];
 
?>

PS It is not an integer, but a text with the value "10".

[veenuisthebest]

$scor[0] will just return the first character, so if the value is "10" it will return "1":

Yes.. I was getting exactly the same problem and I also noticed that this was happening with all 2 digit numbers like 10, 11, 12 and so on.

BUT I just figured it out and this WORKED:-

PHP Code:

$scor = explode('-', $result['colscore']);
$score["$scor[0]"] = 'selected="selected"'; 


I just put explode and its working perfect. But may I know plz what explode did, that the list box is now selecting 2 digit numbers.

[Dismounted]

An explode makes $result['colscore'] an array, since it is the first and only element, it is assigned the ID of 0. You know you could just have done this:

PHP Code:

$score["$result[colscore]"] = 'selected="selected"'; 


[veenuisthebest]

I have a similar problem again but this time related to retrieving text values in select box.

I have this in template:-

<select name="category" size="1" id="category">
<option value="Arts and Literature">Arts and Literature</option>
<option value="Blogs and Personal">Blogs and Personal</option>
<option value="Cartoon and Animations">Cartoon and Animations</option>
<option value="Technology">Technology</option>
</select>

Suppose, the value in the database is Technology, How do I retrieve it automatically selected in the select box.

Thank you