Running mysql query on php multiple times but with different condition

Question

screenshot: https://i.sstatic.net/mX29j.png

im currently making an invoice receipt. the numbers you see on the image, 4600 and 33, are the retrieved values from the checklist from the first page. As you can see, it only lists ONE charge where as it should be two.

this is the part of the code:

$procedures = $_SESSION['receipt'];

        foreach($procedures as $key=>$procedureno)
            {
            $query = "select * from `charges` where `procedure_no` = $procedureno";
            echo $procedureno;
            $result2=mysql_query($query,$dbh1);
            if(mysql_num_rows($result2) > 0 ){
            while($row = mysql_fetch_array($result2)){
            echo '
            <tr>
                <td>'.$row[1].'</td>
                <td>'.$row[2].'</td>';

            echo '</tr>';
                }
    }

            }

I want this query $query = "select * from charges where procedure_no = $procedureno"; to be executed several times depending on how many the $procedureno is.

You are about to get a lecture on mysql injection...

christopher
– christopher

2013-01-10 17:34:45 +00:00
Commented Jan 10, 2013 at 17:34 — christopher
– christopher, Commented Jan 10, 2013 at 17:34

Till Helge · Accepted Answer · 2013-01-10 17:34:47Z

2

MySQL understands lists. Try this:

SELECT * FROM charges WHERE procedure_no IN (1, 5, 33, 78)

answered Jan 10, 2013 at 17:34

Till Helge

9,3212 gold badges43 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user1967153 Over a year ago

$procedureno=4600 33. How can I replace the space with comma?

Till Helge Over a year ago

Do you even know what you are doing? Try str_replace($procedureno, ' ', ','). Definitely not the best way, but here's not the place to teach you PHP basics...

user1967153 Over a year ago

It should be str_replace(" " , ", ", "$procedureno"); but either way it doesnt work

Till Helge Over a year ago

Just take my query and send it to the database manually. You will see that it actually does work. It's the most straightforward solution to your problem.

user1967153 Over a year ago

Yeah it works in sql. But my problem is doing it on a php code since there is no comma in the variable.

|

Greg E. H. · Accepted Answer · 2013-01-10 17:36:43Z

0

Create a method and pass the condition as a parameter. Inside that method put your FOR cycle.

answered Jan 10, 2013 at 17:36

Greg E. H.

575 bronze badges

Collectives™ on Stack Overflow

Running mysql query on php multiple times but with different condition

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related