Stuart Felenstein wrote:
--- Jochem Maas <[EMAIL PROTECTED]> wrote:
> The problem is when I click the column sorter
link and
> the page re-loads, it looks like the where array
is
> getting wiped out, values are gone. I get a
"divison
> by zero" error. I'm assuming this is becasue the
is this err
the array code to set it properly...then save that array set to the session
var...
bastien
From: Stuart Felenstein <[EMAIL PROTECTED]>
To: Jochem Maas <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [PHP-DB] stumped by "order by"
Date: Sun, 19 Dec 20
--- Jochem Maas <[EMAIL PROTECTED]> wrote:
> > The problem is when I click the column sorter
> link and
> > the page re-loads, it looks like the where array
> is
> > getting wiped out, values are gone. I get a
> "divison
> > by zero" error. I'm assuming this is becasue the
>
> is this erro
hi Stu,
...
>
> Okay I wasn't sure but thought I might need to add
> another query statement in. So it would have made it
> work except! , I found a new problem with this issue.
>
> Hopefully I can clearly explain it.
> There is a default $orderParam_rsVJ set up. So when
> the results are returne
--- Bastien Koert <[EMAIL PROTECTED]> wrote:
> Hi Stu
>
> something like
>
> Bif(!empty($s_Ind)) $aWHERE[] = "Jobs.Industry IN
> ($s_Ind)" ;
> if(!empty($s_State)) $aWHERE[] = "Jobs.State IN
> ($s_State)";
> if(!empty($s_TType)) $aWHERE[] = "Jobs.Term IN
> ($s_TType)";
> if(!empty($JTitle)) $aW
clause
$query_rsVJ .= implode
//then check if the sort element is passed
if (isset($_GET['order_rsVJ'])) {
$orderParam_rsVJ = (get_magic_quotes_gpc()) ?
$_GET['order_rsVJ'] : addslashes($_GET['order_rsVJ']);
$query_rsVJ.= " order by $orderParam_rsVJ ";
}
bastien
My problem is I can't seem to find the right place to
put an "order by" clause in my statement.
I have this select statement:
$query_rsVJ = " SELECT Jobs.PostStart,
Jobs.JobID,Jobs.JobTitle,
Jobs.City, Ind.Categories, VendorSignUp.CompanyName,
US.States, Term.Tax FROM Jobs
INNER JOIN Ind ON
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
>
> --- Jason Wong <[EMAIL PROTECTED]> wrote:
>
> >
> > Also just to be certain that you *are* running
> those
> > lines of code change the
> > echo $to, to echo "Before $to" & echo "After $to"
> or
> > something.
> >
Some may remember my prob
--- Jason Wong <[EMAIL PROTECTED]> wrote:
>
> Also just to be certain that you *are* running those
> lines of code change the
> echo $to, to echo "Before $to" & echo "After $to" or
> something.
>
Well now I feel like a damn jackass. I just
discovered something that doesnt fix the issue, yet
r
On Tuesday 07 December 2004 19:15, Stuart Felenstein wrote:
> --- Jason Wong <[EMAIL PROTECTED]> wrote:
Please be explicit, do you mean this what you get?:
> > What happens when you do this:
> >
> > $to = $rsVendorJobs->fields('Conmail');
Call to a member function on a non-object
> > echo $to;
N
--- Jason Wong <[EMAIL PROTECTED]> wrote:
> What happens when you do this:
>
> $to = $rsVendorJobs->fields('Conmail');
> echo $to;
> echo $rsVendorJobs->fields('Conmail');
> $to = $rsVendorJobs->fields('Conmail');
> echo $to;
>
Same thing: Call to a member function on a non-object
in..
Stuart
On Tuesday 07 December 2004 18:13, Stuart Felenstein wrote:
> Here is what's freaking me out ! :)
>
> Anywhere on the page I can do a
> fields('Conmail');?>
>
> And it will echo out the correct value,
>
> But! as soon as I do a
> $to = $rsVendorJobs->fields('Conmail');
>
> I get a "Fatal error: Ca
--- Jochem Maas <[EMAIL PROTECTED]> wrote:
> I just thought, if your query object ($) is
> returning a
> resultset object then maybe you have to 'loop' the
> resultset object
> in order to retrieve the 'row' object(s) from which
> you can retrieve the
> data.
>
Yes, but the recordset (or r
I just thought, if your query object ($) is returning a
resultset object then maybe you have to 'loop' the resultset object
in order to retrieve the 'row' object(s) from which you can retrieve the
data.
your resultset object doesn't have a GetRowAssoc() method?
[ defined as &GetRowAssoc($uppe
> var_dump($rsVendorJobs);
>
> object(kt_adorecordset_mysql)(33) { ["dataProvider"]=>
Looks like you're using the ADODB library (
http://www.certicamara.com/consulta/lib/adodb/docs-adodb.htm ) or
similar. ( That may not be the official site, I just bounced around a
bit. )
All your previous code
--- "Norland, Martin" <[EMAIL PROTECTED]>
wrote:
> (Bear with me on this, because I've got nothing
> remaining to go on...)
> What do you get from:
>
> var_dump($query_rsVendorJobs);
> var_dump($totalRows_rsVendorJobs);
> var_dump($->SelectLimit($query_rsVendorJobs));
>
Stuart Felenstein wrote:
--- "Norland, Martin" <[EMAIL PROTECTED]>
wrote:
All I can recommend from here is heavy use of
printr() or var_dump() on
your variables.
They are NULL. That is the problem. I can't for the
life of me , figure out a way to initialize these
variables.
be more specific - it
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> They are NULL. That is the problem. I can't for the life of me ,
figure out a way to
> initialize these variables.
(Bear with me on this, because I've got nothing remaining to go on...)
What do you get from:
--- "Norland, Martin" <[EMAIL PROTECTED]>
wrote:
> All I can recommend from here is heavy use of
> printr() or var_dump() on
> your variables.
>
They are NULL. That is the problem. I can't for the
life of me , figure out a way to initialize these
variables.
> Obviously, also, you'll want to
All I can recommend from here is heavy use of printr() or var_dump() on
your variables.
> $totalRows_rsVendorJobs = $rsVendorJobs->RecordCount(); // end
Recordset
This clearly means $rsVendorJobs is an object of some sort, probably
some custom recordset object as you've said - so your best bet is
--- "Norland, Martin" <[EMAIL PROTECTED]>
wrote:
> What is $rsVendorJobs
It's a "recordset" which for lack of a better
definition is a sql query.
>
> Is $rsVendorJobs just the result of a mysql_query()?
> If so, you probably
> just want to be using:
>
> $to = $rsVendorJobs['Conmail'];
Nope, t
:37 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] stumped-mail and database
--- "Norland, Martin" <[EMAIL PROTECTED]>
wrote:
> 1) change
> $to = "$rsVendorJobs->Fields('Conmail')";
> To
> $to = "{$rsVendorJobs->Fields(&#
--- "Norland, Martin" <[EMAIL PROTECTED]>
wrote:
> 1) change
> $to = "$rsVendorJobs->Fields('Conmail')";
> To
> $to = "{$rsVendorJobs->Fields('Conmail')}";
> Or just
> $to = $rsVendorJobs->Fields('Conmail');
>
> 2) change
> $body = '$cl';
> To
> $body = $cl;
>
Well I'm sure
--- Bastien Koert <[EMAIL PROTECTED]> wrote:
> I prefer to assign the db values to loca variables
> to ensure that I am
> sending out exactly what I need to.
>
Well the binding is one where clause that pulls the
correct record for the transaction. Following what
you are saying, how does that
er, I don't know if it would interest you but here is a class I have
been using for ages now (not that I have trouble using mail() for simple
jobs) because its simple, packed with functionality and works well:
http://phpmailer.sourceforge.net/
the following page hopefully demonstrates how simple
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Here is what I tried:
>
> $to = "$rsVendorJobs->Fields('Conmail')";
> $subject = $rsVendorJobs->Fields('RefEm');
> $body = '$cl';
> $headers = "From: [EMAIL PROTECTED]";
mail($to,$subject,$body,$headers);
> echo "Mail
I prefer to assign the db values to loca variables to ensure that I am
sending out exactly what I need to.
Bastien
From: Stuart Felenstein <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] stumped-mail and database
Date: Mon, 6 Dec 2004 10:05:57 -0800 (PST)
I'm trying to se
I'm trying to send mail out based partially on a
recordset/binding.
The fields are available but I'm not sure if they need
to be turned into a variable first or if I can just
reference them in the body of the email.
Here is what I tried:
$to = "$rsVendorJobs->Fields('Conmail')";
$subject = $rsVe
Thank you FG - this is exactly what I needed.
I think I 've got the query perfect, but how best to display like:
5 jane doe send_rep
4 mignon hunter tic 2-3, send_rep
here's my query:
$query = "SELECT cust.id, first, last, company, choice FROM cust, contact
where cust.id = contact.id";
while ($r
Hi all, new to the list :)
I would try something like this:
Select name, company, choice
>From Table1, Table2
Where Table1.id = Table2.id;
Fg
> Can someone please help me or direct me to some scripts that might get
> me unstuck, as I've not done this kind of query before.
>
> To simplify:
>
Tables are listed below the code
I couldnt get the foreach to work properly that Brent sent..I keep getting:
"Invalid argument supplied for foreach() ".
I've tried lots of different stuff but here's an example:
*
$query = "SELECT * FROM cust"
On Wednesday 07 April 2004 21:18, Mignon Hunter wrote:
> I never saw this email come across - I think it got caught in spam software
> on 4-1
Check the archives.
>
>
> Well I'm still working on this off and on - still having problems :|
>
>
I never saw this email come across - I think it got caught in spam software on 4-1
Well I'm still working on this off and on - still having problems :|
I couldnt get the foreach to work properly..I keep getting:
"Invalid argument supplied
Well I'm still working on this off and on - still having problemos :|
I couldnt get the foreach to work properly..I keep getting:
"Invalid argument supplied for foreach() ".
I've tried lots of different stuff but here's an example:
*
$query =
The way I handle queries like this is to use an associative array with
the ID as the named index key. You then loop through the data
consolidating the choices and linking the other data based on id. Since
you are using a named index, it doesn't matter how your data is sorted.
//Consolidate your
need
to query. I guess I can get the data I want by selecting all from the 5
tables then parsing"
Send your tables structure.
- Original Message -
From: "Mignon Hunter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 26, 2004 3:07 PM
Subject: Re:
r" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 26, 2004 3:07 PM
Subject: Re: [PHP-DB] Stumped with proper query & display
Can someone please help me or direct me to some scripts that might get me
unstuck, as I've not done this kind of query before.
Can someone please help me or direct me to some scripts that might get me unstuck, as
I've not done this kind of query before.
To simplify:
Table 1
id 1
Name John Doe
company IBM
Table 2
id1
choice choice #1
id
OK... I have once again thought of something cool to do, and can't
quite figure out how to make it happen. I am developing a user account
request system for work. Things are coming along nicely. The user logs
into the system, kind of, selects the systems that he wants to have accounts
a
:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 10:06 AM
To: NIPP, SCOTT V (SBCSI); 'Hutchins, Richard'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Stumped...
Out of curiosity, what was the solution? It's always good to learn from
someone else's mistakes ... :)
/ecommerce/
---
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 1:42 PM
To: 'Hutchins, Richard'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Stumped...
Nevermind. I just stumbled across the nature of m
, SCOTT V (SBCSI); '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Stumped...
Post your SQL statement.
> -Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 09, 2003 1:37 PM
> To: '[EMAIL PROTECTED]'
> Subject:
, SCOTT V (SBCSI)
Date: Thursday, January 09, 2003 10:41:21 AM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] Stumped...
I am getting an error that is proving very difficult to isolate and
was hoping for help. The error is: Column count doesn't match value count
at row 1. I wo
Post your SQL statement.
> -Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 09, 2003 1:37 PM
> To: '[EMAIL PROTECTED]'
> Subject: [PHP-DB] Stumped...
>
>
> I am getting an error that is provin
I am getting an error that is proving very difficult to isolate and
was hoping for help. The error is: Column count doesn't match value count
at row 1. I would include the code, but it is about 350 lines, and I am not
sure where to narrow it down at. Any ideas? Thanks.
Scott Nipp
Phone
45 matches
Mail list logo
