Re: [PHP] Re: multiple choice dropdown box puzzle

2009-02-24 Thread PJ
Bob McConnell wrote: > From: PJ > >> Here's my test page and, so far, nothing works... >> > > Please expound on "nothing works...". What do you see in the browser? > What do you see in the server logs? > It's not in the browser that I look, rather in the db: nothing is INSERTed. I have c

[PHP] Re: multiple choice dropdown box puzzle

2009-02-23 Thread PJ
Brent Baisley wrote: > It's actually a very simple solution, and you should do it all in a > single INSERT. Putting INSERTs in a loop will kill your performance > when you try to scale. > > $sql4 = 'INSERT INTO test (example) VALUES (' . implode('),(', > $_POST["categoriesIN"]) . ')'; > $result4 =

Re: [PHP] Re: multiple choice dropdown box puzzle

2009-02-23 Thread Shawn McKenzie
Bob McConnell wrote: > From: PJ >> Here's my test page and, so far, nothing works... > > Please expound on "nothing works...". What do you see in the browser? > What do you see in the server logs? > >> > I strongly recommend changing all of these to That will reduce the ambiguity and possibly

RE: [PHP] Re: multiple choice dropdown box puzzle

2009-02-23 Thread Bob McConnell
From: PJ > > Here's my test page and, so far, nothing works... Please expound on "nothing works...". What do you see in the browser? What do you see in the server logs? > You at least need a space between http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: multiple choice dropdown box puzzle

2009-02-23 Thread PJ
Here's my test page and, so far, nothing works... Choose categories... History Temples Cleopatra Mummies Brent Baisley wrote: > It's actually a very simple solution, and you should do it all in a > single INSERT. Putting INSERTs i

[PHP] Re: multiple choice dropdown box puzzle

2009-02-23 Thread Brent Baisley
It's actually a very simple solution, and you should do it all in a single INSERT. Putting INSERTs in a loop will kill your performance when you try to scale. $sql4 = 'INSERT INTO temp (example) VALUES (' . implode('),(', $_POST["categoriesIN"]) . ')'; $result4 = mysql_query($sql4, $db); That exa