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);

 ?>

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");

Thanks!!! it work!!! you are my savior man

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.