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
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'
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
3 matches
Mail list logo