select * from ...

[nomad9]

Hi, in my DB table, i've got 2 fields :

formName +++ formQuestion

typeOne +++++++ question1
typeTwo +++++++ question4

typeThree ++++++ question2

First, i need to detect if, for example, typeOne exist. If typeOne exist, i need to echo the value of formQuestion associate with the typeOne row.

How can i do that ???

select formQuestion WHERE formName = typeOne ???

[router]

You can know if the fields exist using this consult:

SELECT count(*) FROM BD WHERE formName = typeOne;

If (result!=0)
{select formQuestion WHERE formName = typeOne ;}
else
{nothing...doesn't exist}

I hope that it helps you!!
Router 🙂

[nomad9]

thanx alot router

[router]

i'm happy for helping!!
😉

[nomad9]

... i've got a problem ... why it doesn't work ???

if($analyse > "1") {
// Detect DB Info -- Check For Analyse Name
$sql = mysql_query("SELECT formQuestion FROM f".$clientRef." WHERE formName = 'typeOne'"); 
?>
<td align="right"><span class="formText3"><?=$sql>
</span><br>
...

[router]

please, can you teld me more ?
What's it happening?
Does it return an error? Doesn't it select the correct row?
Tell me more, please! 🙂
Router

[nomad9]

sorry .... i found it ... a problem with the table name ...

thanx again

[router]

Don't worry and good luck!
Router