[SOLVED] php mysql help?

[marksie1988]

Could someone tell me how i get a column from a row and if that column has yes to show it but if not then dont show it?

 

basically

 

if(['sold'] == yes){

show any rows with yes in the sold column

}

else{

show nothing

}

 

i basically want to show sold items and then have another script the other way around which shows available ones so ones with no in the sold column

 

please help with me starting it off all i need is the first bit then ill figure it out

 

Thanks

Steve

[AndyB]

Why not just select the rows you need?

 

SELECT * from table_name WHERE sold = 'yes' (and vice versa for the no case)

[redarrow]

dont forget to use $_POST[''];

<?php

// select database

// query database

$query="select * from colum";

// result query

$result=mysql_query($query)or die("mysql_error()");

// while loop with $x being the array

while($x=mysql_fetch_assoc($result)){

// if condition match condition

if($x['solid']=="yes"){

	echo $x['what_ever'];

// if condition dosent match

}else{}

// repeated the same ok.

if( $x['solid']=="no"){

 echo $x['what_ever'];

 }else{}
 
 // end while loop
}

?>

 

 

agree with andy why do it the long way round lol.

[marksie1988]

well good i didnt know how to do that thankyou for teaching me that im learning so much from this site its great