[PHP-DB]how to handle exception in php

2010-05-01 Thread Bavithra R
hi friends I am doing a simple student mark details project. for calculating rank I need to compare the total marks one by one. To do so i use *for loop.* so atlast while reaching the end of the table it shows the following warning. * Warning*: mysql_result() [function.mysql-result

Re: [PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread Karl DeSaulniers
#x27;s printer... - Ron On 5/1/2010 7:53 AM, nagendra prasad wrote: I am not sure if this works for your project but you can first ask user to fill the form in PHP and then convert it into PDF. What say? __ Information from ESET Smart Security, version of virus signature database 5078 (

Re: [PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread Karl DeSaulniers
art Security, version of virus signature database 5078 (20100501) __ The message was checked by ESET Smart Security. http://www.eset.com Ron Take a peek at this http://fpdf.org/ Writing to a pdf from php is very cumbersome, this seems to take some of the sting out. Gary

Re: [PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread listread
can first ask user to fill the form in PHP and then convert it into PDF. What say? __ Information from ESET Smart Security, version of virus signature database 5078 (20100501) __ The message was checked by ESET Smart Security. http://www.eset.com Ron T

Re: [PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread Gary
On 5/1/2010 7:53 AM, nagendra prasad wrote: >> I am not sure if this works for your project but you can first ask user >> to >> fill the form in PHP and then convert it into PDF. What say? >> >> > > > __ Information from ESET Smart Security, version

Re: [PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread Kesavan Rengarajan
Search for pdflib or fpdf. They help you with generating PDF files from a php script. Sent from my iPhone On 02/05/2010, at 7:28 AM, listread wrote: Yes, we can first ask the user to fill in a form, but then comes the part I don't understand - how to covert it to pdf. It would be best if

Re: [PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread listread
Yes, we can first ask the user to fill in a form, but then comes the part I don't understand - how to covert it to pdf. It would be best if we could just fill in the fields on an existing form, but it would also work to print the printer friendly form to the server's printer queue, which could

Re: [PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread nagendra prasad
I am not sure if this works for your project but you can first ask user to fill the form in PHP and then convert it into PDF. What say?

[PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread listread
Greetings PHP gurus! Does anyone know of a way to use PHP to fill in the form fields in an existing pdf document residing on the server? We want the end result to be the creation of a unique pdf document for each visitor which can either be emailed or stored in a directory on the server. W

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Karl DeSaulniers
@Peter To be honest, this is my first one. So the margin for error is probably there, I just cant see it. BUT, I did get this database file pre-made from WebAssist. Its their E-Commerce database file they gave out. (Sorry if I am repeating myself) So the structure was set up by another and I am

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Karl DeSaulniers
GOLD! Thank you. Karl On May 1, 2010, at 4:12 AM, Peter Lind wrote: On 1 May 2010 11:00, Karl DeSaulniers wrote: Thank you Peter... again.. :) Which would be the source field and which the target field? You place the constraint on the table that has the foreign key. Using your example: T

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Peter Lind
On 1 May 2010 11:00, Karl DeSaulniers wrote: > Thank you Peter... again.. :) > Which would be the source field and which the target field? You place the constraint on the table that has the foreign key. Using your example: Table 1 = products * id = primary key Table 2 = productoptions * product

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Karl DeSaulniers
Thank you Peter... again.. :) Which would be the source field and which the target field? Karl On May 1, 2010, at 3:22 AM, Peter Lind wrote: On 30 April 2010 20:49, Karl DeSaulniers wrote: No, please confuse me. I need to know this stuff. @Peter thanks for that introduction to foreign keys

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Peter Lind
On 1 May 2010 10:13, Karl DeSaulniers wrote: > What is the SQL query I can use to get an item that has two IDs? > Something to the effect of... > > $q = "SELECT OptID = '$OptID' FROM ".PRODUCT_OPTIONS." WHERE ProdID = > '$ProdID' AND OptGrpID='$OptGrpID'"; Close but no cigar. $q = "SELECT OptID

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Peter Lind
On 30 April 2010 20:49, Karl DeSaulniers wrote: > No, please confuse me. I need to know this stuff. > > @Peter thanks for that introduction to foreign keys. Since my productoptions > table is based off of items in products, optionGroups and options, would I > use foreign keys for this? If I read

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Karl DeSaulniers
What is the SQL query I can use to get an item that has two IDs? Something to the effect of... $q = "SELECT OptID = '$OptID' FROM ".PRODUCT_OPTIONS." WHERE ProdID = '$ProdID' AND OptGrpID='$OptGrpID'"; Is this correct or am I missing something? A single group ID can have multiple option IDs s