vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi there, hope you can help me. Newly I use mysqli and procedure. In my form I check 9 radiobuttons altogether. In due I have a query in variable 'sql' like following.. $sql="SELECT * From table1 WHERE club=$_POST[1] OR disco=$_POST[2]"; //And so on, it depends on true-false value of variables..then.. $temp = mysqli_prepare($this->db, $sql); mysqli_stmt_bind_param($temp, "ii[...]",$_POST[1],$_POST[2],[...]); How can I manage the right allocation? The problem is here you need to fill out the variables in equal number of given variables (e.g. 'iis' so three variables) And I can only use when the post variables is true.. What is maybe a real better solution? Need something like pointer or so? Greedings, Bjoern |
| ||||
| On Wed, 30 Jan 2008 08:46:20 -0800 (PST), rince78 <jacksch_1@hotmail.com> wrote: >Hi there, >hope you can help me. Newly I use mysqli and procedure. >In my form I check 9 radiobuttons altogether. In due I have a query in >variable 'sql' like following.. > >$sql="SELECT * From table1 WHERE club=$_POST[1] OR disco=$_POST[2]"; >//And so on, it depends on true-false value of variables..then.. > >$temp = mysqli_prepare($this->db, $sql); >mysqli_stmt_bind_param($temp, "ii[...]",$_POST[1],$_POST[2],[...]); > >How can I manage the right allocation? The problem is here you need to >fill out the variables in equal number of given variables (e.g. 'iis' >so three variables) >And I can only use when the post variables is true.. > >What is maybe a real better solution? Need something like pointer or >so? > >Greedings, >Bjoern That's a good question for comp.lang.php And you weren't the first one to ask, so a search in Google groups in comp.lang.php for comp.lang.php radiobutton mysql will likely produce some interesting results amongst the 56 hits it returns. -- ( Kees ) c[_] As scarce as truth is, the supply has always been in excess of demand. (#351) |
| Thread Tools | |
| Display Modes | |
|
|