I am fairly new to PHP and MySQL and I have a problem which I have been trying to resolve for days. I just can't figure it out and can't find anything on the web that is helping me work it out.
I hope someone out there can assist.
Ultimately I want to display the data as follows (this is just an example of how I want it displayed, it does not mirror the data set below)...
<h2><a href="procedure.php?number=f1>Finance Procedure 1 - F1</a></h2>
<ul>
<li><a href="form/f1_fm1.pdf" target="blank">Finance Form 1</a></li>
<li><a href="form/f1_fm2.pdf" target="blank">Finance Form 2</a></li>
<li><a href="form/f1_fm3.pdf" target="blank">Finance Form 3</a></li>
</ul>
<h2><a href="procedure.php?number=f2>Finance Procedure 2 - F2</a></h2>
<ul>
<li><a href="form/f2_fm1.pdf" target="blank">Finance Form 1</a></li>
<li><a href="form/f2_fm2.pdf" target="blank">Finance Form 2</a></li>
<li><a href="form/f2_fm3.pdf" target="blank">Finance Form 3</a></li>
</ul>
<h2><a href="procedure.php?number=f3>Finance Procedure 3 - F3</a></h2>
<ul>
<li><a href="form/f3_fm1.pdf" target="blank">Finance Form 1</a></li>
<li><a href="form/f3_fm2.pdf" target="blank">Finance Form 2</a></li>
<li><a href="form/f3_fm2.pdf" target="blank">Finance Form 3</a></li>
</ul>
I have 2 tables (procedure_name and procedure_form). and run the following query which gives me the required data set.
$sql = "SELECT procedure_info.id, procedure_info.name, procedure_info.number, procedure_form.form, procedure_form.form_file
FROM procedure_info
LEFT JOIN procedure_form ON ( procedure_info.id = procedure_form.name_id )
WHERE procedure_info.procedure_area = '14'
ORDER BY procedure_info.procedure_area ASC";
My problem is that I don't know how to output the result set I achieve into the exampled display. my data set looks like this.
id ---name ------------------------------number --form ---------------------form_file
33 ---Referral ---------------------------E2E1 ----NULL ----------------------NULL
34 ---Employer led E2E referral -----------E2E1a ---NULL ----------------------NULL
35 ---Centre Start & Induction -----------E2E2 ----NULL ----------------------NULL
39 ---Programme activity plan & review ---E2E4 ----NULL ----------------------NULL
38 ---Inital Assessment ------------------E2E3 ----Additional Information ------e2e2_fm4.pdf
38 ---Inital Assessment ------------------E2E3 ----E2E Weekly Batch Header ---mi1_fm2.pdf
40 ---Placement -------------------------E2E5 ----NULL ----------------------NULL
41 ---E2E Health & Safety review ---------E2E5a ---NULL ----------------------NULL
42 ---E2E Health & Safety Monitoring -----E2E5b ---NULL ----------------------NULL
43 ---E2E Basic skills ---------------------E2E6 ----NULL ------------------------NULL
44 ---Leavers ----------------------------E2E7 ----NULL ----------------------NULL
I think I have to put this data into a multidimensional array but I just can not work it out.
Can anyone help me? PLEASE!!!
Alternate messaging
I have 4 strings in MySQL db1$string1 : Hello$string2 : Hi$string3 : Great$string4 : ThanksAnd I have 3 accounts MySQL db2$User1 : $Pw1$User2 : $Pw2$User3 : $Pw3expected result---------------Hello
can i optmize image to 50% quality before uploading 2 server
Hi therei have jus written a php program to upload and display images but when i try to upload them it takes a long time to upload if the file is big. But the big problem is when i try to display
My XSRF Prevention code isn't working
First of all, thanks for the generous help you guys have given me in the past on this forum.Second, I apologize in advance if my code is hard to read, most of it was done in a rush.Here
Final year project, please point me in the right direction
hi there for my final year project I'm aiming to build a php script shell to use as an expert system ( I got a feeling this is gonna be difficult, VERY )The idea is that i create txt / csv file with
Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo friendly links.The code that ive used many times before.....Code: $_SESSION['lang'] = $lang =
Gridview Not updating in Update Panel
I have a gridview, three dropdown list boxes, and a button on my form. What is displayed in the gridview depends on the values entered in the dropdown list boxes. The button calls a stored procedure
Weekly Calendar
Hi, I am looking at creating a weekly calendar. The calendar will read from Monday - Sunday. Does anyone know of any examples or tutorails on how I can achieve this, as I have tried searching without
Compare user input to flat file data
Help...Am a complete newbie to programming so my code is prolly quite long. Am trying to verify a users details entered into a login form against details stored in an existing flat file.No matter what
Prevent PHP mail( ) from appending hostname to from address
Hey guys,I want to be able to send texts to phones via email (since each phone has their own address), and for specifying the from, I want to specify my own number, is there a way to do this?For
Alternate messaging
I have 4 strings in MySQL db1$string1 : Hello$string2 : Hi$string3 : Great$string4 : ThanksAnd I have 3 accounts MySQL db2$User1 : $Pw1$User2 : $Pw2$User3 : $Pw3expected result---------------Hello