0

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..

<?php

   $con=mysql_connect("localhost","root","");
      if(!$con)
    	{
	   	 die('Could not connect:'.mysql_error());
         }

mysql_select_db("kiperak",$con);



$result = mysql_query("SELECT Fieldvalue FROM kid_rsform_submission_values WHERE SubmissionId IN (SELECT SubmissionId FROM kid_rsform_submission_values WHERE FieldValue = '850830126317')");


while($row= mysql_fetch_array($result))

{
   -->" this code will show all the values in the row(FieldValue)"  echo $row[0];

      }
 mysql_close($con);

 ?>
Attachments 2-13-2010_11-52-08_AM.png 34.66 KB
2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by zalFG
1

Do you mean like this?

$result = mysql_query("SELECT Fieldvalue FROM kid_rsform_submission_values WHERE SubmissionId IN (SELECT SubmissionId FROM kid_rsform_submission_values WHERE FieldValue = '850830126317') LIMIT 14");
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.