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
