[PHP] Re: Error when I try to display 20 records per page

[Philipp Lutz]

Scott McWhite wrote:
$row = mysql_fetch_array($result); //get a row from our result set
a bit farther down...
while($row = mysql_fetch_array($result)){
Dude !
 You're like pulling the same results from the same query/resultset 
twice (..and stuff). You can't do that, man. You have to redo the query.

(Sorry, I just watched Hurley from "Lost" :-) )
Phil
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] join() , can do that fast?

[Philipp Lutz]

Read closely ! There are extra apostrophes inside the quotes !!
Phil

"Lallous" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> John, what you said would simply produce:
>var x = ['str1,str2,str3']
> and not as I want:
>   var x = ['str1','str2','str3']
>
>
> Elias,
>
> "John W. Holmes" <[EMAIL PROTECTED]> wrote in message
> 002101c26de2$982bf7d0$7c02a8c0@coconut">news:002101c26de2$982bf7d0$7c02a8c0@coconut...
> >
> >
> > > -Original Message-
> > > From: lallous [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, October 07, 2002 6:09 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP] join() , can do that fast?
> > >
> > > Hello,
> > >
> > >
> > > I have:
> > > $x = array('str1','str2','str3');
> > >
> > > I want to convert that array to a valid javascript syntax as:
> > >
> > > var x = ['str1','str2','str3']
> > >
> > > I can do this in PHP:
> > >
> > > echo sprintf("x=[%s]", join(',', $x));
> >
> > echo sprintf("x=['%s']", join("','", $x));
> >
> > > but that would produce:
> > > x = [str1, str2, str3]
> > >
> > > is there is a fast way (other than doing a loop) to have join put
> > quote
> > > around each array value before joining? so final result looks like:
> > > ['str1','str2',...
> >
> > ---John Holmes...
> >
> >
>
>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] need help for a where clause

[Philipp Lutz]

If you are using MySQL you may want to look at the CASE statement in the
"Control flow functions for use with SELECT Statements"
 it would look like
SELECT
CASE A.Afn
  WHEN 1 THEN B.Bfn1
  WHEN 2 THEN B.Bfn2
  WHEN 3 THEN B.Bfn3
   FROM A,B
IN MySQL
Hope That Helps.. Phil

"Alex Shi" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Thanks! This is what I need!
>
> Alex Shi
>
>
>
> "Sascha Cunz" <[EMAIL PROTECTED]> ??
> :[EMAIL PROTECTED]
> A solution on that depends strongly on how much values A.Afn would take.
For
> 3, it's still okay. But i wouldn't do more.
>
> Against what shall the B.Bfn* be checked? What Data do you want to be
> returned
> from the query?
>
> try:
>
> SELECT ### FROM A, B WHERE
>   ((A.Afn=1) AND (B.Bfn1 = ...)) OR
>   ((A.Afn=2) AND (B.Bfn2 = ...)) OR
>   ((A.Afn=3) AND (B.Bfn3 = ...))
>
> where you should replace ### with things you want to select and ... with
the
> things you want to check.
>
> On more than 3 different values for A.Afn, you should use a more
normalized
> version of B.
>
> i.e.: B contains only one Bfn field and a Reference to A.Afn.
>  -> SELECT ### FROM A, B WHERE B.AfnRef = A.Afn AND B.Bfn = ...
>
> Sascha
>
> Am Montag, 7. Oktober 2002 00:33 schrieb Alex Shi:
> > Hi,
> >
> > I need a where clause in following situation:
> >
> > Say I want to query two tables: A and B. In table A there is field
> > Afn, while in table B there are 3 fields: Bfn1, Bfn2 and Bfn3. I want
> > to do a query, in which the where clause must do these things:
> >
> > if A.Afn=1, then check value of B.Bfn1;
> > if A.Afn=2, then check value of B.Bfn2;
> > if A.Afn=3, then check value of B.Bfn3.
> >
> > So how can I create such a where clause to do this?
> > Thanks in advance!
> >
> > Alex Shi
>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php