Help with a query

sks1024

I have table that has one text field that has a "Yes" on "No" value. I want to query the db and get some sort of result in an array i assume that I can refer back to each record whether it was "Yes" or "No".

$id_1 = "Yes";

$id _2 = "No";

and so on and so forth.

Only 10 records in the table. Please help.

Stan

OhLordy

I don't really understand. Try asking a question and I may be able to help. 😉

Rob

sks1024

Here is the table

id fldposition fldavailable

1 Position # 1 No
2 Position # 2 No
3 Position # 3 Yes
4 Position # 4 No
5 Position # 5 Yes
6 Position # 6 Yes
7 Position # 7 Yes
8 Position # 8 No
9 Position # 9 No
10 Position #10 Yes

I have a table setup with each position in it

<td>position # 1</td><td>$answer_1</td>
<td>position # 2</td><td>$answer_2</td>

I want to get the value of fldavailable and print it to the variable $answer as shown above

snaack

You want to loop the recordset and print the results right?

why not try something like:

	$table = "<table>\\n";
	while ($row = mysql_fetch_assoc($resultset))
	{	extract($row);
		$table .= "\\t<tr>\\n\\t\\t<td>{$FIELDNAME}</td>\\n\\t</tr>\\n";
	}
	$table .= "</table>\\n";

echo $table;

Hope it helps.. Your question is not very clear :rolleyes:

OhLordy

<?
$sql="SELECT fldposition, fldavailable FROM table";
$result=mysql_query($query,$conn) or die(mysql_error());

?>
<table>
<tr><td colspan=2><h1>This Be The Table!</h1></td></tr>
<tr><td>fldposition</td><td>fldavailable</td></tr>
<?
while($row=mysql_fetch_array($result)) {
?>
<tr><td><?=$row['fldposition']?></td>
<td><?=$row['fldavailable']?></td></tr>
<?
}
?>
</table>

Hope this helps
Rob

sks1024

Good. I have my table setup like this

1 6
2 7
3 8
4 9
5 10

That is the problem I am having guess I should have told you that

OhLordy

If that's what you're getting displayed to your table when using the code provided then what you have in your database is not the information that you expected.

Do you have phpMyAdmin? Are you running this on a Linux Box?

Basically what you need to do is go into your database and have a look at the data you have in your database and see what's happening there.
Good Luck
Rob

sks1024

I got it. I set up 2 different queries on for the first 5 and one for the second 5 Output 2 different tables.

thanks,
Stan

Here is what I am running