Hello,
I have created a new column in my bad_link table named 'REASON'. I set the type to varchar(150) and NULL to 'yes'.
Then in my bad_link.html I added the following:
<select name="REASON" size="4" multiple>
<option value="Link doesn't work">Link doesn't work</option>
<option value="Site is overly misleading">Site is overly misleading</option>
<option value="Site tries to send viruses">Site tries to send viruses</option>
<option value="Illegal content">Illegal content</option>
</select>
I also modified the bad_link report so that the column for REASON shows up. Now on to my question :)
How do I pass the reasons into the REASON column in the bad_link table? I think it is handled by bad_link.cgi. I tried this:
$db_bad_links->add ( { LinkID => $id,
REASON => $rec->{'REASON'}
URL => $rec->{'URL'},
Title => $rec->{'Title'},
IP => $ENV{'REMOTE_ADDR'}
} );
But, that doesn't work. I don't know what that section means, I was just taking a random guess. If I manually input a reason using mysqlman then the reason does show up on my bad link report. I just can't figure out how to pass the value from my html form into MYSQL.
I really did try to figure this out on my own, but is beyond me. Any help would be most appreciated!!
I have created a new column in my bad_link table named 'REASON'. I set the type to varchar(150) and NULL to 'yes'.
Then in my bad_link.html I added the following:
<select name="REASON" size="4" multiple>
<option value="Link doesn't work">Link doesn't work</option>
<option value="Site is overly misleading">Site is overly misleading</option>
<option value="Site tries to send viruses">Site tries to send viruses</option>
<option value="Illegal content">Illegal content</option>
</select>
I also modified the bad_link report so that the column for REASON shows up. Now on to my question :)
How do I pass the reasons into the REASON column in the bad_link table? I think it is handled by bad_link.cgi. I tried this:
$db_bad_links->add ( { LinkID => $id,
REASON => $rec->{'REASON'}
URL => $rec->{'URL'},
Title => $rec->{'Title'},
IP => $ENV{'REMOTE_ADDR'}
} );
But, that doesn't work. I don't know what that section means, I was just taking a random guess. If I manually input a reason using mysqlman then the reason does show up on my bad link report. I just can't figure out how to pass the value from my html form into MYSQL.
I really did try to figure this out on my own, but is beyond me. Any help would be most appreciated!!