Selecting a row

[Anon]

I have a very confusing problem, i have a row in a database that has been selected, i have tried about 5 different ways to get the data for this row out, i have tried some of the examples from php.net and mysql.com and it still is not geting nething out of the database, i have tried mysql_fetch_array and mysql_fetch_row, i have tried just mysql_query and tried it with some which and foreach functions. There is data in the row because the page before shows everything in the database, there are no errors that come up. Does anybody have any ideas as to what could be wrong.

[[deleted]]

There could be a million things wrong.

You say there is data in the row because the page before shows it. That does ofcourse not mean that the current page selected any rows at all.

Post a codesample and well see what's wrong.

---

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[icaro]

you probaly are using a diferent name in some variable, like: in page that shows the data you used $data and in page that doesnt show anything you are using $data_ ... i do it all the time (and it piss me off)

no ofense, just a possibiliti 🙂

[Anon]

Here is the first page:
$result = mysql_query( "SELECT * FROM hwkset");
while ( $a_row = mysql_fetch_array( $result ) ){
?>
<tr align=center>
<td><?echo $a_row[sets]?></td><td><?echo $a_row[subject]?></td><td><?echo $a_row[hwkset]?></td><td><?echo $a_row[daydue]?>/<?echo
$a_row[monthdue]?>/<?echo $a_row[yeardue]?></td><td><input type=radio name="tick[]" value="<?echo $a_row[id]?>"></td></tr>
<?
}
?>
</table>
<input type=submit value="Amend Homework">
</form>

And this is the second page which is the page im having problems with:
if(count($tick)>0){
foreach($tick as $id) {
$result = mysql_query("SELECT * FROM hwkset WHERE id=1");
while($row = mysql_fetch_row($result));
{
echo "inside while loop";
echo $row[subject];
}