7,368 Topics
| |
hi need to show the duplicates on a column table when they have two other values in common on other column. form_name + field_value name1 | value_x name2 | value_y how can i create the query to search when values x, y, etc have form_name name1 and name2 ? thanks | |
Hi, I’m making an online database (with some help). What I’m having trouble figuring out is how it might be possible to sell ‘records’…or rather the ability to add records. I would sell access to the database based on the number of records a user buys. Once you buy a … | |
Hi! I'm hoping someone can help me here, I've been looking at highcharts as a way of graphing my dynamic data from my sql db....What I've come up with so far is below, it's strange, it seems correct, the data is correct, however, I can't get my chart to render, … | |
Dear all, i am new to php and i am trying to update db table through php form ... there is a form that takes inputs from php form and then update the db ... Below is the update php page ... <?php $host="localhost"; // Host name $username="lpr"; // Mysql … | |
I'm trying to create a PHP script, which would be added to .php files (articles) on my website. This script would automatically add the article in question to a previously created database (and would subseqgently be used to timestamp articles). What would a script like that look like? | |
Hi, I have been trying to import the data from a CSV file (10,000 rows) into a database using SQL and PHP <body> <div id="container"> <div id="form"> <?php $user="root"; $database="test"; mysql_connect("localhost",$user); @mysql_select_db($database) or die( "Unable to select database"); //Upload File if (isset($_POST['submit'])) { if (is_uploaded_file($_FILES['filename']['tmp_name'])) { echo "<h1>" . "File … | |
I have city and its corresponding locality. When user clicks city then its locality will show in Dropdown-Checkbox. How I can do with jQuery, AJAX and MySQL. | |
| hello i want to know that how pass parameters to mysql query inside php function i have written function but giveing me error error: mysql_fetch_array(): supplied argument is not a valid MySQL result resource function d_loader($r_ip){ global $con; $result = mysql_query("SELECT * FROM table WHERE h_ip ='$r_ip'"); $row=mysql_fetch_array($result);} |
**Hi**, #need to generate a report like Table Format(Excel Sheet) # this is an example view of the report which I need of it is for maintaining branch wise details In that product name contin in one table and stock of each branch will contain in another table -------------------------------------------------------------------- | … | |
Hi, I am trying to use mysql select query in a shell script but i need to know how to store a particular value from the output of the query in a script variable. my script file is given below. I need to store the value under field CheckSum in … | |
I have two dropdwon box. First box has names of the states. Choosing a state will populate the second dropdown box that contains cities of that selected state. For all states city names are stored in mysql database table. now I am little confussed how to model the table and … | |
Hey experts. I have two database, i want to fetch values from one of the table from one database and then insert that into another table on another databse, server is same. can i do it? if yes please give some suggestions how to make it hapoen. many thanks in … | |
i have created database for our site. but i wanted to know that how can i secure my website using session. | |
Hi. I wanted to make a page that I can update a table in a database. But for some reason, I get this error: ***Warning: mysql_query() [function.mysql-query]: Access denied for user 'a1092592'@'localhost' (using password: NO) in /home/a1092592/public_html/folder/file.php on line 10*** and this error: ***Warning: mysql_query() [function.mysql-query]: A link to the … | |
Hi guys, Just looking for some advice on database design. I'm relatively competent in MySQL (competent at a push, haha) and I'm in a bit of a pickle right now when I'm trying to generate products for a Magento store. Well, Magento is where it ends up, I currently use … | |
Hi, I want to change this code as given 1 result. I don't need 10 line results. I just need 1 line result. When I tried to change 10 with 1 it doesn't work. Please help me about that. while( $row = mysql_fetch_array($query) ) { $id[] = $row['id']; } $id … | |
Hi, I'm creating a website/database that my dad and his partner will use to help manage there business. update new appointments / manage customers ect. My dad wanted to host it on our server, however I'm not confident about setting up security so I was just going to use a … | |
how to add email adress validation code so the validation will dispaly after immideately entered email adress in text box of email adress | |
Hey everyone, I'm having a little trouble with creating a 'dynamic' calendar with events called from a MySQL database. So basically I would like to have the Month automatically change when the month changes, and highlight the days which have events scheduled, and make those days links to my thickbox … | |
Please help me in the following question: Given the following three tables Table 1: specialization (name,department) Table 2: area (a_name,phone,address) Table 3: dep_loc (area_name,department) where the "area_name" attibute in dep_loc references "a_name" in area. Write a query to give a count of the number of people that work in each … | |
Hi i am Trying to delete a page from my site cms and something is not working . the code is: <?php $con = mysql_connect("localhost","matanc_cmd","123123"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("matanc_cms", $con); $id = (int) $_POST['id']; mysql_query("DELETE FROM content WHERE id='$id'"); mysql_close($con); // if successfully … | |
Hello, I have a bit of challenge that I’m wondering if I can solve by SQL. My source table (thinned out) holds the following two columns: TASK_NAME [VarChar], DUE_DATE [Date] My end state is a list (will be a JQM list element) that will list out every task under headings … | |
Dear all experts im now creating a rating system with php using mysql databse, im facing the problem about how to calculate rating!, ex. i have totalscore and numofvotes table, which function that we can use to calculate rating like, 7.4, 4.5 something like that thanks in advance | |
if i have roughly 25 identical tables is it possible to do the following SELECT tm_name, `tablename` as Activity from t1, t2 ,t3 where date = curdate or would it be better to add another column to the table thats hidden from the users and automatically populate with the tablename. | |
Hi, I have a database table filled with interesting data. On my webpage I would like to let a user pick two rows in the table and compare the data to see how it differs. Picking what rows to compare would be done by two dropdown lists. The data in … | |
My table (employee) has this description Field Type Null Key Default Extra Emp_id int(4) NO PRI Null Emp_name varchar(20) YES Null Mgr_id int(4) YES Null Hire_date date YES Null Salary int(5) YES Null Commission int(4) YES Null Dept_id int(3) YES Null I ran this query alter table employee modify Emp_name … | |
Hey. So here is my code... config.php <?php $localhost = "localhost"; $dbuser = "root"; $dbpass = ""; $dbname = "test2"; $connect = mysql_connect($localhost, $dbuser, $dbpass); mysql_select_db("$dbname", $connect); ?> regprocess.php <?php include"config.php"; $username = $_POST['username']; $email = $_POST['email']; $password = md5($_POST['password']); $insert = 'INSERT into users(username, email, password) VALUE("'.$username.'","'.$email.'","'.$password.'")'; mysql_query($insert); ?> … | |
Hello Everybody please help me out i am in big problem the problem is my organization people gave me the WEB Application to edit it (the application was written in the C# language and it is web application so it is designed in ASP.NET MVC3 ) and i have to … | |
Hi. i was wondering if somebody could help me. Im looking for a php function to check a get and post methods for any type of hack or injection i.e. xss php java html mysql injection. the function needs to check the get or post methods prior to using it … | |
Hi, I am in urgent need for converting sql procedure to postgre sql procedure.Please help me ASAP. CREATE FUNCTION sp_get_id_des (IN cellid INT, IN mcc VARCHAR(3), IN mnc VARCHAR(3), IN nwtype INT, IN mlac INT , IN mrac INT ) returns SETOF record AS' declare pscnt int ; declare cscnt … |
The End.