
Hi techies, I am building a small application that reads vacancies from a database and displays them in a tabular row format, I want to create a link in one of the field say vacancy_id i.e when you display using the following script. All the details are to be fetched from db print("<tr><td bgcolor=$colorbg><a href='*vacanacy.pdf?id=$Field1*'>$Field1</a></td><td align=left bgcolor=$colorbg><a href='apply.html?id=$Field1'>$Field2</a></td><td align=left bgcolor=$colorbg>$Field3</td><td bgcolor=$colorbg>$Field4</td></tr>"); Now the vacacny.pdf is the file to be viewed when you click on the displayed vacancy number that is dyanamic, Techies is it possible or I am just guessing Thank you

Let me ask...is vacancy.pdf supposed to be a pdf file? -- Best Regards, James Mutuku Ndeti Agile Systems Limited +254722490994 www.agile.co.ke mutuku.wordpress.com Has your organization implemented a customer relationship management (CRM)system? visit http://www.agile.co.ke/crm.php and find out how our CRM can help you achieve better customer satisfaction and sales

am assuming the vaccancy.pdf is a link stored in a field in the DB On Tue, Dec 15, 2009 at 10:44 AM, James Mutuku <listmutuku@gmail.com> wrote:
Let me ask...is vacancy.pdf supposed to be a pdf file?
-- Best Regards, James Mutuku Ndeti Agile Systems Limited +254722490994 www.agile.co.ke mutuku.wordpress.com
Has your organization implemented a customer relationship management (CRM)system? visit http://www.agile.co.ke/crm.php and find out how our CRM can help you achieve better customer satisfaction and sales
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general

actually what happens is somebody uploads a vacancy and then there should be a link to that vacancy which is a pdf and has a primary key vacancy id whicha can be used to link to the pdf file

You can find scripts on the net to handle file uploads, move and even rename those uploaded files. It is also quite easy to save the path and name of the uploaded files in MySQL. Infact, you could also save the entire uploaded file in a database. Once the data is in a database, its pretty much easy to link to it and create the links. This should get you started: http://www.webcheatsheet.com/php/file_upload.php On Tue, Dec 15, 2009 at 1:06 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
actually what happens is somebody uploads a vacancy and then there should be a link to that vacancy which is a pdf and has a primary key vacancy id whicha can be used to link to the pdf file
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general

Are u using .net, you can use crystal reports but display as pdf format. On Tue, Dec 15, 2009 at 10:23 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi techies,
I am building a small application that reads vacancies from a database and displays them in a tabular row format, I want to create a link in one of the field say vacancy_id i.e when you display using the following script. All the details are to be fetched from db
print("<tr><td bgcolor=$colorbg><a href='*vacanacy.pdf?id=$Field1*'>$Field1</a></td><td align=left bgcolor=$colorbg><a href='apply.html?id=$Field1'>$Field2</a></td><td align=left bgcolor=$colorbg>$Field3</td><td bgcolor=$colorbg>$Field4</td></tr>");
Now the vacacny.pdf is the file to be viewed when you click on the displayed vacancy number that is dyanamic, Techies is it possible or I am just guessing
Thank you
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- Samson Bungei

Sure that is quite good let me try it out thanks for the advice On Tue, Dec 15, 2009 at 2:11 PM, Samson Bungei <bungei6@gmail.com> wrote:
Are u using .net, you can use crystal reports but display as pdf format.
On Tue, Dec 15, 2009 at 10:23 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi techies,
I am building a small application that reads vacancies from a database and displays them in a tabular row format, I want to create a link in one of the field say vacancy_id i.e when you display using the following script. All the details are to be fetched from db
print("<tr><td bgcolor=$colorbg><a href='*vacanacy.pdf?id=$Field1*'>$Field1</a></td><td align=left bgcolor=$colorbg><a href='apply.html?id=$Field1'>$Field2</a></td><td align=left bgcolor=$colorbg>$Field3</td><td bgcolor=$colorbg>$Field4</td></tr>");
Now the vacacny.pdf is the file to be viewed when you click on the displayed vacancy number that is dyanamic, Techies is it possible or I am just guessing
Thank you
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- Samson Bungei
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
participants (5)
-
Benjamin
-
Calvin Omari
-
James Mutuku
-
Peter Karunyu
-
Samson Bungei