trouble with 'from','to' in Insert New Reservation
Posted: Fri May 22, 2009 3:56 pm
I just installed this today. The installation went along nicely and was pretty slick. Database was made and everything functions, am able to get to localhost/php-residence/inizio.php just fine.
However, I'm running into trouble when I try inserting a reservation. After the surname and name of the titular client, I can't put anything in the fields for the 'From' and 'To' dates. I tried creating a reservation leaving those out. When I hit 'submit' then, it says the dates are wrong. Then when I hit 'back' the displays the insert reservation page again; however, this time it shows these two errors inside the 'From' and 'To' fields (well, between the labels and the fieldsets to be precise):
So, I open up the includes/funzioni_mysql.php file to see what is happening in line 94 and I see this:
I tried browsing the rest of the page to see what $risul is up to, but my PHP skills aren't that great, so nothing looks out of the ordinary. Any thoughts?
Thanks in advance,
Steven
However, I'm running into trouble when I try inserting a reservation. After the surname and name of the titular client, I can't put anything in the fields for the 'From' and 'To' dates. I tried creating a reservation leaving those out. When I hit 'submit' then, it says the dates are wrong. Then when I hit 'back' the displays the insert reservation page again; however, this time it shows these two errors inside the 'From' and 'To' fields (well, between the labels and the fieldsets to be precise):
Code: Select all
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 67 in /tmp/disk/home/mos/Files/WWW/php-residence/includes/funzioni_mysql.php on line 94
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 71 in /tmp/disk/home/mos/Files/WWW/php-residence/includes/funzioni_mysql.php on line 94
Code: Select all
$risul = mysql_result($query,$riga,$colonna);
Thanks in advance,
Steven