Re: [PHP] need help for a where clause

2002-10-07 Thread 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 S

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

2002-10-07 Thread 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'

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

2004-11-16 Thread 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