Read tag and getting information

NZ_Kiwis

Hi have a user board, like a forum on my website and i want my users to be able to type in a text box

[Q/4471] or [R/1051]

if it is the Q/ then it gets the inforamtion from my quotes batabase with the id of 4471 if t's R/ from the results db.... so the numbers are variables...

how could i do this??? i'm thnking str_replace but not sure how it would work??

goldlikesnow

if (strpos($_POST['field'], "[Q/4471]") != false) {
$sql = "SELECT FROM table1";
} else {
$sql = "SELECT FROM table2";
}

devinemke

$string = '[Q/4471]';

$string = trim($string, '[]');
$explode = explode('/', $string);

$tables = array(
'Q' => 'quotes',
'R' => 'results' 
);

$sql = 'SELECT * FROM ' . $tables[$explode[0]] . ' WHERE id = ' . $explode[1];

NZ_Kiwis

remember the number is a variable!! so i would have to first look for the $string... how can i do this when its not always going to be [Q/4471] it might have 505 or 92044 or 3205......

$string = '[Q/4471]';

$string = trim($string, '[]');
$explode = explode('/', $string);

$tables = array(
'Q' => 'quotes',
'R' => 'results'
);

$sql = 'SELECT * FROM ' . $tables[$explode[0]] . ' WHERE id = ' . $explode[1];