Page 1 of 1

Warning: mysql_result() [function.mysql-result]: HELP

Posted: Mon Dec 01, 2008 10:58 am
by dv_evan
Hello everyone,

I ran into some problem with my php codes pulling from a MYSQL database and am asking for your assistance.
I am running a code to extract contacts from a database, everything is coming out fine such as first & Last names/Emails/Telephone. However, I have two address fields with data and this (see below) is what I am getting for these two address fields:

Warning: mysql_result() [function.mysql-result]: Add_1 not found in MySQL result index 3
Warning: mysql_result() [function.mysql-result]: Add_2 not found in MySQL result index 3

I tried changing the field names around and changing the characters values from 'TEXT' to 'VARCHAR' but no success.
These address fields consist of characters such as (commas, #, P.O. Box, etc) I don't know if these are the faults and what to do.

Its strange because the other fields are comming out perfect.

Please, kindly assist.

Regards
Dave

Re: Warning: mysql_result() [function.mysql-result]: HELP

Posted: Tue Dec 02, 2008 1:05 am
by novice4eva
since the error is for result index 3, maybe the query returned less than 4 rows, have you checked??