Right, I am not on any list for a line by line feed /
analysis. Actually I tried signing up twice yesterday
for the PHP general and never received email
confirmation. Anyway sure I'll find my way !
Thank you
Stuart
--- [EMAIL PROTECTED] wrote:
> i would suggest that your questions would be more
> appropriately asked
> on the php mailing list. one suggestion, however.
> look at the php
> documentation and get a general understanding of
> things first.
> [there's been a spate of people basically asking for
> line-by-line
> debugging of their code which has caused the "read
> the manual" bar to
> be pushed somewhat higher.]
>
>
> ---------- Original Message ----------
> > From: Stuart Felenstein <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> > Date: Thursday, August 26, 2004 02:19:34 AM -0700
> > Subject: Re: PHP / Mysql people question
> >
> > First let me say thank you for all the responses.
> > Now, let me say I'm not sure what exactly I need
> to
> > do. Explanation - Primarily I have absolutely no
> > experience with PHP , but I can learn, so that's
> > helpful :)
> > The thing I'm trying to figure out is what I need
> to
> > learn, because currently I'm developing in
> > Dreamweaver, using a set of extensions from a
> company
> > call Interakt (this isn't a advertisement or
> > endorsement). Specifically using the Impakt
> > extensions. So , the bottom line is this is a PHP
> > -Adodb model. Now all I know is that Adodb is an
> > abstraction layer to PHP.
> >
> > The code that wound up working for me is the
> following
> > (the KT_id are the session variables to identify
> the
> > user):
> >
> > global $DBconnection, $HTTP_SESSION_VARS;
> >
> > $colname__Recordset = '-1';
> > if (isset($HTTP_SESSION_VARS['KT_id_xxx'])) {
> > $colname__Recordset =
> > $HTTP_SESSION_VARS['KT_id_xxx'];
> > }
> > $query_Recordset = sprintf("SELECT * FROM
> LurkCerts
> > WHERE LurkID =
> > %s",
> > $colname__Recordset);
> > $Recordset =
> > $DBconnection->SelectLimit($query_Recordset) or
> > die($conn_name->ErrorMsg());
> > $totalRows_Recordset = $Recordset->RecordCount();
> >
> > if ($totalRows_Recordset >= 10)
> > $tNG->setError(-1,"Too many table records for
> current
> > user!");
> >
> > Bottom line I have no idea what "language" this
> is.
> > Anyway , hope this is not a confusing post.
> >
> > Thank you ,
> > Stuart
> > --- Dobromir Velev <[EMAIL PROTECTED]> wrote:
> >
> >> Hi,
> >> First mysql_fetch_row() returns an array so it
> >> doesn't make much sense to
> >> compare it to 5. If you want to check tne number
> of
> >> records the query has
> >> returned you should use mysql_num_rows() - like
> this
> >>
> >> if(mysql_num_rows($result)>=5){ }
> >>
> >> or if you want to check the value returned by the
> >> query something like this
> >> should work though I would personally add some
> >> additional error testing.
> >>
> >> if(mysql_result($result,0,0)>=5){ }
> >>
> >> HTH
> >> --
> >> Dobromir Velev
> >> [EMAIL PROTECTED]
> >> http://www.websitepulse.com/
> >>
> >>
> >> On Wednesday 25 August 2004 18:02, Stuart
> Felenstein
> >> wrote:
> >> > Thought earlier that I could get by on just
> plain
> >> SQL.
> >> >
> >> > Php needed. I'm getting a parse error on the
> "if"
> >> > line.
> >> > This is supposed to be a trigger then before
> >> > transaction counts the number of rows , id
> already
> >> > inserted, if exceeded , kick back error message
> ,
> >> halt
> >> > transaction.
> >> > Not sure where I need to go with this statement
> to
> >> > make it work. Ideas , help, suggestions
> welcome!
> >> >
> >> > //start trigger Trigger1
> >> > function KT_TriggerSTARTER_Trigger1(&$tNG) {
> >> > $result = mysql_query("SELECT
> LurkTitleTim.LurkID
> >> > WHERE
> >> > LurkID='$new_input'");
> >> >
> >> > if ($row=mysql_fetch_row($result) >= 5) {
> error-
> >> data
> >> > already exists }
> >> >
> >> > else { go ahead and add data with INSERT
> >> statement
> >> > }
> >> > }
> >> >
> >> > Thank you ,
> >> > Stuart
> >>
> >>
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> >>
> >
>
http://lists.mysql.com/[EMAIL PROTECTED]
> >>
> >>
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> >
>
http://lists.mysql.com/[EMAIL PROTECTED]
>
> ---------- End Original Message ----------
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
