No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
 | I git this warning>> [CODE]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files (x86)\EasyPHP 2.0b1\www\HotelCalifornia\sites\reserve_room.php on line 85 Unknown column '' in 'where clause[/CODE] This is my code>> [CODE] <?php $user=$_GET['username']; $Custno=$_GET['Custno']; $RoomNo=$_GET['RoomNo']; $username="jasmine"; $password="price"; $db=mysql_connect("localhost" , $username, $password); mysql_select_db("hotel_cali", $db); $sql="SELECT Email FROM customer … |
| | i have this table named room that contains the RoomNo as the primary key and it needs to pass the primary key to a foreign key in another table called AF and RoomNo as its foreign key. then another table called facilities and FNO as its primary key, it also … |
| | what php code should i add if i need the custno[id no] to be included when i submit the log-in button? this code runs, but i really need the code for the custno to be included. start.php [CODE]<?php session_start(); session_destroy(); ?> <html > <head> <title>Login Form </title> <meta http-equiv="Content-Type" content="text/html; … |
| | how would i pass a auto incremented primary key to a foreign key? example i have this room table that has a Room_No as a primary key that is auto_increment and i need it to pass to another table named AF and Room_No as its foreign key.. what code should … |
| | i have to insert a lot of data where it might be also use as foreign key at different table.is that possible to add 1 time together the value to all table?can give any example?thx in advance!:) |