help in updating mysql

bladezzzzz

<?php
echo "<td><a href=\"mailto:xxx@xxxxx.com\" onClick=\"include_once('trial.php');\" ><b>Send a Comment</b></a></td>";
?>

can anyone tell me wat is wrong?? i want to update a field in the database once ppl click on this link....

noimad1

I'm not 100% positive, but I am pretty sure the Onclick event can not execute php code. So whatever you are including in trial.php would not work...

I've thought and though about this one and I don't know if you can accomplish both of the items that you want to do with one user click...It's kind of a strange combination of actions....

Having someone click to send an e-mail and update a database when they do so.

If you really wanted to, I guess you could set up a simple form with a "from", "to", "subject", "message" fields that they would fill out like they would an e-mail.

Then you could post that form to a script and use the mail() function to send and e-mail, and update your database...? But that would force them to actually send an e-mail, where as the "mailto" just opens up their mail client...

bladezzzzz

hmmm becoz i tried it with html code it works... i tried something like
onClick="<?php include_once('trial.php');?>" and it worked... but then i need to put it in pure php otherwise i wun be able to display my info properly as i am using while($row=mysql_fetch_array($result))

noimad1

Originally posted by bladezzzzz
hmmm becoz i tried it with html code it works... i tried something like
onClick="<?php include_once('trial.php');?>" and it worked... but then i need to put it in pure php otherwise i wun be able to display my info properly as i am using while($row=mysql_fetch_array($result))

Oh, maybe you are right. I wasn't really sure. Then I wonder what the echo is doing that is different than just the regular html?

What happens when you view the source after the page is loaded? Does the include information look like it is being echo'd out?

I wonder if because you are echo'ing the information out, the browser is interpeting the include statement right away for some reason and putting the included information where the "onclick" event is, instead of just the "include" statement itself?

Just a long shot there...