Posted by UKuser on 03/13/06 23:36

Hi Guys,

I have some wierd MySQL queries. Although I am using ADODB (an
abstraction layer) - the queries will probably be quite general.

1) When I post data in a url (i.e. post.php?id=120) and I use this
code: $var = secure_field($id); it will work (on the
"recieve_page.php"). However if I use $secure_field($_POST['$id']) or
any POST/GET/REQUEST type option, it won't work. Its fine, because
secure_field does what I need, however I'm just not sure why its not
picking it up. (If I probe $var - the result is blank)

2) I have a table, where I want a delete button at the end of each row
(as opposed to when only one record is displayed on the screen). I also
don't want to have to post to an external delete.php file. Is there a
way to do this?

For example:
print "<tr>
<TD>{$rs->fields[0]}</TD>
<TD>{$rs->fields[1]}</TD>
<TD>{$rs->fields[2]}</TD>
<TD>{$rs->fields[3]}</TD>
<TD><a href='another_page.php?id=$id'>Edit</a></TD>
<TD><a href='this_page.php?id=$id2'>Delete</a></TD>

Where $id = $rs->fields[0]

Even with hardcoded MySQL I have never been able to resolve this delete
per row problem. Any help would be great.

Thanks

[Back to original message]