Answered
Really annoying new error php MySQL
Hi guys.
This is a new error. My dynamic page has been working lovely for 2 weeks till today. I have a php page with 2 recordsets, and two divs that display records from them. Previously I had one recordset with a repeating region that showed all records. My second one showed 3 records only. This worked great.
Now i realised that in some cases, the first recordset would or may have quite a few records, more than Id wish to display at one time in my div (its quite narrow, so made the page really long, also wasn't very readable for more than say 5 records.) . So i decided to change the repeating region to display 5 records at a time, and add a navigation element so the user could flick through the recordset, and the div wouldnt be stretched too large.
I did this and it worked fine on my local testing machine. I uploaded the changed file to the remote server and got this error when I looked at the page: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path of file] on line [line that included the 1st instance of mysqlnumrows()]
I've tried to dismatle the changes i made, but still keep getting the error. So i removed ALL the php from the page and started from scratch in order to try and find the point wherer things stopped working . The following code sample is where i was upto when the error reared its ugly head again.
Sorry for the long message. Hope you lot can help, you normally can! Thanks in advance.
Dave
This is a new error. My dynamic page has been working lovely for 2 weeks till today. I have a php page with 2 recordsets, and two divs that display records from them. Previously I had one recordset with a repeating region that showed all records. My second one showed 3 records only. This worked great.
Now i realised that in some cases, the first recordset would or may have quite a few records, more than Id wish to display at one time in my div (its quite narrow, so made the page really long, also wasn't very readable for more than say 5 records.) . So i decided to change the repeating region to display 5 records at a time, and add a navigation element so the user could flick through the recordset, and the div wouldnt be stretched too large.
I did this and it worked fine on my local testing machine. I uploaded the changed file to the remote server and got this error when I looked at the page: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path of file] on line [line that included the 1st instance of mysqlnumrows()]
I've tried to dismatle the changes i made, but still keep getting the error. So i removed ALL the php from the page and started from scratch in order to try and find the point wherer things stopped working . The following code sample is where i was upto when the error reared its ugly head again.
Sorry for the long message. Hope you lot can help, you normally can! Thanks in advance.
Dave
AdChoices