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]
