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!!!
Different payment methods with different cross company requirements in F110
We are implementing SAP in a company in the shipping industry. They have the following requirement:
Just wondering what you think about my site
I am new to phpfreaks i just seen this form and thought it would be cool to see what other thought about my site, feel free to sign up an post items to see how that all works or if you dont want to
firefox wouldnt stream mp3 files completely from my php page
hi everyone,I have a php file trying to read and stream mp3 files. It works fine in IE but my problem is Firefox streams only 3 seconds of them.$direction =
Help With editting and deleting form
Hallo !!So look at this image :http://img194.imageshack.us/img194/8272/snapshot5f.png This table prints the titles of entries from a table in a database.. The code that i use for this table is this
DELETE rows based on content
I have a link in my rows$bit="http://bit.ly/abcd";$query = mysql_query("DELETE FROM *table* WHERE sentence........");//I need to delete all sentence rows which DOES NOT contain my
PEAR in appliactiond development
When I was picking up PHP I went from procedural programming, fairly quickly into OOP, then after writing a bunch of custom libraries and applications I discovered CodeIgniter. I pretty much
Code clarification
Hi In the following code what could be the "search_print()" and where it could be placed.Couldn't find within the page or included pagesCode: [Select]<td align="right"
Agency Business Process
Hi,
Delete all files in folder except with certain name
I have a script that I want to delete all files in a folder (taken from a database) except for one named thumb1.jpgI have this, but this deletes all the files and a subfolder if there is one. How can
Save file by click
Hello. I'm not understand how to save file from page. I'd like make link to file with save ability.<?phpchdir('upload/');foreach (glob("*.*") as $filename) { $uploadfile =
