Hi Chris,
Here is the corrected code. Yes, call the function before the SQL SELECT like so. You may have to work with it a bit. This was just off the top of the head.


But now that I look at it, I think Jim may be right.
What's the purpose of the inputs having 1, 2, 3, etc and not the 0-250kbps, etc? If there is no purpose, I would make the values of the inputs the values you want to store in your database.
Muuch easier..

Otherwise try this. You should be able to copy an paste.

//your form code...

function getSpeed($val) {
        if($val != 'undefined') {
                switch ($val) {
                        case "1":
                                $post_speed = "0-250kbps";
                                break;
                        case "2":
                                $post_speed = "250-300kbps";
                                break;
                        case "3":
                                $post_speed = "300-400kbps";
                                break;
                        case "4":
                                $post_speed = "400-600kbps";
                                break;
                        case "5":
                                $post_speed = "600kbps-3.8mbps";
                                break;
                        default:
                                $post_speed = "Speed Undetected"; // or 
"0-250kbps"
                                break;
                }
                return $post_speed;
        } else {
                die("Error, no speed value set");
        }
}

//This part may need to be worked. Basically you want; posts.post_tptest to equal the result of getSpeed($_POST ['post_tptest']). //however you can get it there in your code. Or just try this, see if this works and go from there.

$_POST['post_tptest'] = getSpeed($_POST['post_tptest']);

$posts_sql = "SELECT
                                                posts.post_store,
                                                posts.post_content,
                                                posts.post_tptest,
                                                posts.post_date,
                                                posts.post_by,
                                                users.user_id,
                                                users.user_name,
                                                users.first_name,
                                                users.last_name
                                        FROM
                                                posts
                                        LEFT JOIN
                                                users
                                        ON
                                                posts.post_by = users.user_id
                                        WHERE
                                                posts.post_store = " . 
mysql_real_escape_string($_GET['id']) . "
                                        ORDER BY
                                                posts.post_date DESC ";    

//... rest of your code

HTH,
GL,
Best,

Karl

On Jun 23, 2011, at 3:17 PM, Jim Giner wrote:

If you put the "0-250kbps" as the value= of your html <input> tag, php would
give you that when you did this:

$rb_picked = $_POST['post_tptest'].

No need for a switch or anything to re-interpret what the user picked.



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Karl DeSaulniers
Design Drumm
http://designdrumm.com


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to