RE: [PHP-WIN] SQL to select a set of records

2004-02-05 Thread Svensson, B.A.T. (HKG)
You can for instance insert the top 35 into a tmp table, then delete the top 10 with from-from in the temp table, and then finaly select the rest. Alternative you can select top with decending order form the temp table, but this depends on if you have an ordered set or not of course. Another poss

[PHP-WIN] SQL to select a set of records

2004-02-05 Thread Herhuth, Ron
I am trying to figure out how to bring back only a specific number of records using a SQL statement in Microsoft SQL Server. For example I know how to bring back the first x number of records from the database: SELECT Top x * FROM SQLTable What I would like to do is to bring back only records 2

RE: [PHP-WIN] Problem with form

2004-02-05 Thread Disko_kex
Its not the progress of the form that's the problem. If a want to post more the one value in a "" the name must be "name = "something[]" in php, but if the is named with "[]" my javascripts doesn't understand the name. So it's a javascript question. This works: //update "omr" but then only one

RE: [PHP-WIN] Problem with form

2004-02-05 Thread John Ellingsworth
Is your question a javascript or PHP question? For PHP you can do this: $omr = $_POST['omr'] ; if(is_array($omr)) { for($k=0; $kInsert("insert into omr (omrID,omrNumber) values ('$omrID','$omr[$k]')"); $affected_rows = $sql->a_rows;

php-windows Digest 5 Feb 2004 15:03:27 -0000 Issue 2108

2004-02-05 Thread php-windows-digest-help
php-windows Digest 5 Feb 2004 15:03:27 - Issue 2108 Topics (messages 22732 through 22736): Apache problem 22732 by: Frédéric HARDY RE:[PHP-WIN]Thanks for everyone's help! 22733 by: Marlene Burckhalter 22734 by: Shannon Eric Peevey Re: Converting from ASP to PHP

[PHP-WIN] Problem with form

2004-02-05 Thread Disko_kex
Hi If a have a , what is the name of the "select"? I tried with both "omr" and "omr[]", but no one works. It works fine if the name is "omr" but then it is only one value posted. Maybe its easier to understand if you see it yourself: http://www.lokalguiden.se/index2.php?action=ledigalokaler It