zalFG

help needed.... i have 16 values in one row of a table, but i only wanted to retrieve 14 value from that row(FieldValue) the last two values was u-needed. sorry for my bad english... and thank in advance.. [CODE] <?php $con=mysql_connect("localhost","root",""); if(!$con) { die('Could not connect:'.mysql_error()); } mysql_select_db("kiperak",$con); $result = …

[code] <?php $con=mysql_connect("localhost","root",""); if(!$con) { die('Could not connect:'.mysql_error()); } mysql_select_db("test",$con); $result = "SELECT Fieldvalue FROM jos_rsform_submission_values WHERE SubmissionId IN (SELECT FieldValue,SubmissionId FROM jos_rsform_submission_values WHERE FieldValue = '".$_POST['searchterm']."')"; print_r(mysql_fetch_array($result)); --> i dont know what to do with this part.. mysql_close($con); ?> [/code]