PHP - Moved: Advice On Architecture And Design

Hi All,

I currently have a ticketqueue that show's all tickets assigned to a group of people, but split into personal queues, but the way that I wrote it, means that it needs manually updating if a specific person leaves/joins the department. For example, to get the queue details, I use the following query:

Code: [Select]
$username1 = mssql_query("select id,subject,body,priority from queue where assignedto = username1";)
$username2 = mssql_query("select id,subject,body,priority from queue where assignedto = username2";)

I have repeated this code for all of the users in our team. Which seams a waste, as I have all the information on our team stored in a DB called "sysadminusers". Is there an array I could use that would look at all the usernames in the table, and then repeat the query for me?

I would also need this array to display the results on the page, currently I use the following:

Code: [Select]
while($username1_tickets = mssql_fetch_assoc($username1)){
echo $username1_tickets['id'],$username1_tickets['subject']$username1_tickets['body'],$username1_tickets['priority'];}
while($username2_tickets = mssql_fetch_assoc($username2)){
echo $username2_tickets['id'],$username2_tickets['subject']$username2_tickets['body'],$username2_tickets['priority'];}

I am just looking for some design advice and code examples that would help me tidy up my code for this page, it seams a lot of code for quite a simple page.

Thanks
Matt

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=328588.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=313548.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=349906.0

Hello, I have a table with people and some details insde. So, my question is if my MySQL architecture down below is good or not. Should I devide the table into two tables and kept only p_id, p_name and p_slug inside my table (people_tbl). Thank you!

p = person
p_description = bio
p_category = occupation (people_category_tbl)

people_tbl
 

+------+---------+---------+---------------+-------------+-------------------+-----------+------------+---------+
| p_id | p_name  | p_title | p_description | p_seo_title | p_seo_description | p_country | p_category | p_slug  |
+------+---------+---------+---------------+-------------+-------------------+-----------+------------+---------+
|  1   | John Li | title   |  johns bio    | 70 charsets | 170 charsets      | Germany   | 1          | john-li |
|  2   | Bob Stu | title   |  bobs bio     | 70 charsets | 170 charsets      | Italy     | 2          | bob-stu |
+------+---------+---------+---------------+-------------+-------------------+-----------+------------+---------+

 

Edited February 16, 2020 by mactron