PHP - Select from database the same query
- by How to PHP
I created a table that contains the name of the user and his job, and created PHP page that shows me all the users that works doctor, I entered doctor into a variable then I selected from the table where Jobs equal to $doctor, that is great, but I need it to get the same Jobs into a table in the page and the other same jobs into a table in the same page. this is my code that shows only the users works doctor in one table,
<html>
<h1>Doctors</h1>
</html>
<?php
mysql_connect('localhost','root','');
mysql_select_db('data');
$doctor='doctor';
$query= mysql_query("SELECT * FROM `users` WHERE `job` = '$doctor'")or die(mysql_error());
while ($arr = mysql_fetch_array($query))
$name= $arr['name'];
echo $name;
}
?>
That shows me doctors when I put doctor in a variable I want to show all same Jobs in a table.
Is there is a way to do this?
Thanks :)
