10,940 Topics
 | |
| | Does anyone know of any PHP and MySQL code that will help me out? I'm looking to translate my website but without the use of Google, Yahoo, Bing and so on, but would like to try drive the website through a database. The idea was to have friends from around …  |
| | Hi all, i don't know how to solve this problem...i want store all the data into database. help pls~ thanks~ <!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" xml:lang="en" lang="en"> <head> <link href="/style.css" rel="stylesheet" type="text/css" /> <title>Insert New Institution</title> <script type="text/javascript"> function addRowToTable() { var tbl = document.getElementById('tblAddress'); … |
 | Hello I'm having trouble solving the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( )' at line 1 I have a php script which I've written in PHP6 which creates … |
| | Hi everyone, I wrote an INSERT for an insert form but for some reason it wont save the data tot he database. In phpMyadmin the rows are taken up with blank nothings. It seems to work but nothing is being stored. code as follows... [CODE]session_start(); $db_hostname = "localhost"; $db_password = … |
| | Hi I am trying to write a query that will return the gold, silver, and bronze medalists for each individual-based event. The relational schemas are: EVENT(Event_id, Event_title, Event_team, Event_gender, Sport_id) GAME(Game_id, Gtype_id, Game_year, game_website, game_cancel, Country_id) GAMETYPE(Gtype_id, Gtype_title) SPORT(Sport_id, Sport_title, Gtype, id) CONTESTANT(Cont_id, Rep_id, Comp_id, Team_id) MEDAL(Medal_id, Medal_color, Cont_id) REPRESENTATIVE(Rep_id, … |
| | Hello all, I am new to php and thus far i'm love the potential this language has as I learn more about it. I have been trying to write a script to no avail. What I am trying to accomplish is to setup a sms site from web to mobile. … |
| | I am having a hard time understanding subqueries. I am pretty sure that is what I need to accomplish my task, but not sure how to put it together. I have a unique ID field that auto-increments, so that a new entry always gets a higher number assigned to that …  |
| | [QUOTE=nav33n;813365]Where are you inserting the value to client table ?[/QUOTE] I have two tables; school and courses and need to insert records into the courses table that have the same school id as the corresponding record in the school table  |
| | Hi, I have the following extract from a table called results. StudentID Course Percent 1005 MAM1 63 1006 PHY2 55 1006 MAM1 71 I need to produce a list of student ID's WHO take MAM1 AND PHY2. I first selected all rows where course is MAM1 OR PHY2, but then … |
 | Hello Guys....i am very happy to interact with u all. Im new to database. i want to display database names into a dropdown list box and at the same time if i select a particular DB it will display all the tablenames into another dropdown list box... Can any one … |
| | i am developing a social networking site as my project in college. i have a doubt on php and mysql.. """ I TWITTER OR FACEBOOK OR IN GMAIL WHEN THERE IS NO ACTION FROM USER(BROWSER) THAT IS, THE USER LOGS IN AND STAY STILL(NOT RELOADING THE PAGE). HOW CAN WE … |
| | hi all, i had 4 text boxes. 1.Emp_id 2.Emp_Name 3.Mobile No 4.Blood group and a search Button. so when i fill any textbox or all the textboxes then it should display the required data. For example: If i want some person details. i know only his name.Then if i enter … |
| | I save prices data for different days. If a day doesn't have any changes, it is not in the database. table prices date | price ---------------------- 2010-10-01 | 200 2010-10-02 | 200 2010-10-03 | 220 2010-10-06 | 260 2010-10-09 | 190 ... Now I need to prices for statistic purposes … |
| | Hi I'm a newbie to PHP and mySQL I have the following problem. I have a database with mp3's which I query by artist name, I then print the results in a table with a maximum of 15 rows. I can then have a next, prev, last and first button … |
| | i have a prob to insert the data that i've select from the mysql database into the textbox in php..[CODE]<!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=utf-8" /> <title>New Doctor Record</title> </head> <body bgcolor="#FFFFFF" text="#000000"> <p> </p> <?php $host = "localhost"; $uname = "root"; … |
 | I have read through the FAQ sticky regarding this topic (and have also searched/read here further on this topic) but I am still receiving the following error: [B][I]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a4542527/public_html/index.php on line 8[/I][/B] The scripting for this is basic at …  |
| | Hi, I have created a program in Python which creates a database called inb104 and loads the data from text files into the mySQL server. The code works perfectly fine. The data is inserted into the table without any issues. The problem is that I would like to place the …  |
| | hi all, i am trying a query but i am not getting the result properly.. Is there any error in my query.. [CODE]$query ="select Emp_Id,First_Name,Last_Name,Gender,Mobile_No,Email_Id,Blood_Group from Employee where"; if($empid!='') { $query1=$query . " Emp_Id like '".$empid."%' and"; // echo $query1; } if($empname!='') { $query1=$query . " First_Name like '%".$empname."%' and"; … |
| | Hi, I am using Tiny MCE as a Textbox to get user generated input which can be bold, italic, underlined, lists and different alignments. When the user submits the form data the information is then saved to a variable like below: [CODE] $jobDesc = mysqli_real_escape_string ($dbc, $trimmed['txtJobProfile']); [/CODE] The I … |
| | Hello I want to do that after submitting form it will insert in a table. the table has auto increment field. name of the field is ID. Now how can I get the ID number of that inserted data's ID number. for example I have a table which field are … |
| | Hi. I want to have a query as below. [CODE] $sql = "SELECT amount FROM payment WHERE id = '$a'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); $amount = $row['amount']; [/CODE] The value for $a variable is getting from the selection on drop down list. For example, the user select id=11, … |
 | Currently I'm working on a microblog just to get familiar with PHP MySQL. I have a pretty big problem though. Here's the php code: [code] function get_all_users(){ $query = "SELECT * FROM ".$this->prefix."users"; if ($stmt = $this->prepare($query)){ $stmt->execute(); … |
| | Pretty new at php and working on my class project. I get this error code on my action page for my log in page plus, it does not redirect when the result is wrong. I still get into the members' area. Code below. Thanks "mysql_num_rows(): supplied argument is not a … |
| | 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 … |
| | Hello. I am making a register/login function, and i want the user to be able to upload files to his account, and can later view these files. I wonder how i can make the upload script insert data in a mysql table only for the current user uploading, i dont … |
 | im currently running on windows 7 and i cant seem to find some suitable installation of mysql for python 3.1.2.. any help on this?my professor havent gave me any links on where to download it, anyone would mind helping me on this? or as i tried import mysqldb and i …  |
| | Hello Everyone, I have triple drop down menu. I want to display the contents of the table based on the third menu selection. The code is in the link [url]http://php.pastebin.com/hgazULxi[/url] I know I need to include a onchange function to <select name="genus"> but as you can see I have a …  |
| | I couldn't register php session from mysql query. Can you tell me what is the correct method to register php session in mysql field. I tried many ways. Still no solution. [CODE] $sql=("SELECT email FROM people"); $result=mysql_query($sql); $email = mysql_fetch_array($result); echo $email['email']; //could not register this way session_register("$email"); [/CODE] |
| | I'm new to mysql and was wondering if someone could help me Im using the following code on search engine on my site I have to table blog and news when i change blog to news and post to article the error disappears but when i change it back i … |
| | create table book(bookid int ,title varchar(50),author varchar(50),book longblob); insert into book values(1,'c#','arun','c:/c#.pdf'); BUT this code is not working properly |
The End.