[php-mysql] Forum Topics

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 …

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 want to map a field, city, from a MySQL database into Google Maps. I found a nice script to do it, but haven't been able to get it to work. If I hard code an array into locations (var locations = ['Seattle', 'New York']), it works fine. Passing this …

Hi, I'm trying to create a drop down menu with dynamically populated options. So, within a typical HTML form I have: [CODE] $conn = mysql_connect ("localhost", "xxxx", "xxxx"); mysql_select_db ("wkho_TTX", $conn); $query = "SELECT * FROM venues"; $result = mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $option …

Hello, thanks for reading my thread. I'm still new to web development so I appreciate your help in advance. Here is the issue I am having: In my project, I have a index.php page with a sidebar menu and a div id called “content”.The user can select different menu items …

I am just trying to make a php edit script using a combo box or any other method. But I am not sure how to write a script when selecting a sportsid and fetch the related data at the same time. [CODE] $sql = "SELECT * FROM sports WHERE sport_id=2"; …

I have created a search bar using PHP that pulls from my database by keywords typed in the search bar and displays links and descriptions of URLs' associated with the keywords. Is there a way for robots to randomly type keywords in my search bar on my website to list …

hey people . okay . 3 dayz ago i was done from designing and coding my website . it is made mainly in html . okay it is not pure html . it is html with php in .php files and it also contain abit of js & css . …

hey people i wrote this code and i got a problem , i cant register a session . this is the login form : [CODE] <?php if(!isset($_POST['username'])) { $title = "- signin"; include "header.php"; include "nav.php"; ?> <form action="" method="post"> Username :<br /><input type="text" name="username" size="70" /><br /> Password :<br …

hey people . i want to start a free hosting site .i have a doamin name with unlimited sub-domains and unlimited space and email acounts and unlimited ftp accounts . what i want to do is to write a code that creates a sub-domain and a folder with the name …

hey people . i have question . i want to create a social engine like facebook but i dont know where to start from and how to do everything so please tell what do i need to create a scoial engine like elgg and if you know a website that …

heyy . please tell me how to can i connect databases together . couz i am doing a project and i have to like some databases and get some information from at least 5 databases tables and display them in one page . can i do more than a connection …

hi people how can i create a system that creates a mailing system that allow my websites members contact each other throught a private messages . please tell me how to do it step by step , if there is code it will be fine but you can also tell …

hey people . please tell me how to solve this thing . i dont want to see this error again . please tell me . here is the error : Parse error: syntax error, unexpected $end in /home/awah7870/public_html/cms/blog_prog.php on line 26 and here is the code [CODE] <?php if(isset($_POST['post'])) { …

hey ppl how is everything okay , i want ask if i can create a next page automatically by using mysql?? i mean is there is any code that can check for the next page after it displays the previous one . it is somehow comp[licated for me to explain …

wt is wrong here ?? it usually gives me this error : Parse error: syntax error, unexpected $end in /home/a2354076/public_html/cats/programming/includes/topics.php on line 34 here is the code : [CODE] <!-- header ends --> <!-- content begins --> <div id="main"> <div id="right"> <a href="http://www.000webhost.com/" onClick="this.href='http://www.000webhost.com/326472.html'" target="_blank"><img src="http://www.000webhost.com/images/banners/468x60/banner13.gif" alt="Free Website Hosting" width="468" …

Hi Daniweb, I am confused, how to explode the numbers from database. Simply I can Explode, but after explode I have to relate the numbers to another table. If any one not clear abt my problem, pls reply Eg: 1, 2 Relate to Basket, football [CODE] $sql1=mysql_query("SELECT impid FROM customer …

How can I use explode function in php I already implode some data in mysql [CODE] // customer table cust_id, impid, 1, 1,2 // sports table sport id, sport name 1, football 2, basketball [/CODE] How can I explode and make a php/mysql query

I am just trying to link a reference numbers using php/mysql 1) Each reference number will select (see code) 2) Post that number to next page and query the info. How can I post reference ID and query in the page 2. [CODE] <? // Page 1 refno.php $cid= $_SESSION["c_id"]; …

[CODE]<?php include("includes/connection.php");?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <?php echo $sql= "SELECT * FROM forms WHERE today >= CURDATE() - INTERVAL 30 DAY"; $result=mysql_query($sql); while($row=mysql_fetch_array($result)) {echo $City= $row['City']; echo $Name=$$row['Name'];} ?> </body> </html> [/CODE] i just …

Hi, i have made a form in which people fill out their details and its gets saved in database with [CODE] $today = date("F j, Y");[/CODE] now i want to make a search for that forms with date , like Search with in last 3 days or Last 6 months. …

hey people seriously , this code is going to kill me i wrote it yesterday and upto now it cant work i wrote it more than one time and i review it more than 10 times but i didnt found the error so this is my code and bellow is …

hi everyone i need your help i want to write a code that gets for me the latest 5 out puts here is my code [CODE] <?php $con = mysql_connect("localhost","awah","pass"); if(!$con) { echo "cant connect to db".mysql_error(); } $select = mysql_select_db("awah_admin"); if(!$select) { echo "cant select db ".mysql_error(); } $query …

please help me it usually gives me error ( it says cant enter the values ) [CODE] <?php $host = "localhost"; $con = mysql_connect("localhost","awah","password") or die ("error to connect to the server"); // contact the table and enter the form mysql_select_db("kigalifinders_clanteam_admin", $con); $query = mysql_query("INSERT INTO contacts(from, subject, message) value('$_POST[email]','$_POST[subject]','$_POST[messgae]')"); …

Hi All, I need to use the results of this query as an array to exclude files from a tree. The file and folder names that I enter into $exclude work fine but I can not seem to add the results from the query to the array. Below is the …

i need a small project on php and mysql i m beginner in this field can anyone help me out..... plz...... it can be anything like hotel management........ thankyou

Greetings, I got no clue how to make / set a session. When i login on my page and then press a link i get out-logged, I've tried to read on PHP.net but i cant get it together. Anyone got an explaination or code i could go from to keep …

[B]Greetings![/B] Anyone here who can correct my code? I'm abit noob to PHP, just started learning. The Ban file function of mine does the echo but it wont stop the file upload. Any idea? have i inplented it wrong or do i miss a line? Love you long time if …

I tried lot of way to pass the checkbox values from page 1 to page 2. But I only get successes on fruit id, how can pass the fruit charges. [CODE] // how can I pass room charges"$result[room_charges]" to page 2 // page 1 $sql=mysql_query("select * from fruit"); while ($result …

hi, Am having a problem Inserting into SQL 2008 database using stored procedure from a php webpage. My Stored Procedure is: [code=text] Create PROCEDURE [dbo].[udp_AddContact_Insert] @Contact_ID int, @Client_ID int, @STD varchar(10), @Tel varchar(20), @Mobile varchar(20), @EmailAddress varchar(100), @FirstName varchar(20), @LastName varchar(20), @Title_ID int, @Position_ID int, @User_ID int, @SourceURL varchar(1000), @PositionText …