Versions of MySQL prior to 5.0 don't support triggers and stored procedures. You need to make sure you're using 5.0. If you've done that and are still having problems, ask a more specific question. Sounds like you're looking to use stored procedures, tho. In your code, you probably are wanting to call stored procedures rather than running queries out of your code from the looks of it, although triggers might help you with validation, integrity, performance, etc. depending on your usage.
--- In [email protected], "Brian E Boothe" <[EMAIL PROTECTED]> wrote: > > > IM using INC Files to run SQL Query's on my database table's > Here is one >> (( " I have 20+ of these to do different things") > My Question is Can't I use this inside MySQL in a trigger or procedure or > function can someone help me on this,, I have like 30 Inc files Floating > about it be nice to have it all in mysql , > <? > /* Select Statement for grabbing total sums of All Electric project Cost */ > $btstotal7 = ""; > $link = mysql_connect("localhost","root","goobers") or > die(mysql_error()); > mysql_select_db("idata", $link); > > $sql2 ="SELECT SUM(BondAm) AS btstotal7 FROM workorders"; > > $result = mysql_query($sql2, $link) or die(mysql_error()); > while ($row = mysql_fetch_assoc($result)) { > extract($row); > } > echo '<h9><font color="#00FF00">' . $btstotal7 . '</h9>'; > mysql_free_result($result) or die(mysql_error()); > mysql_close($link) or die(mysql_error()); > ?> > > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.409 / Virus Database: 268.13.28/518 - Release Date: 11/4/2006 >
