10,942 Topics
 | |
| | 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 table with a timedate collumn. I want to get the text of the article and its creation date, than to output them on my page. How can I just get only the date value from a query or php script manupulation?  |
| | Warning: mysql_query() [function.mysql-query]: MySQL server has gone away in C:\xampp\htdocs\a_upload\upload.php on line 71 Warning: mysql_query() [function.mysql-query]: Error reading result set's header in C:\xampp\htdocs\a_upload\upload.php on line 71 GalleryUploadMessageProfileStatistticsChange PasswordDelete Account if(!$sql=mysql_query("INSERT INTO image VALUES(NULL, '$user_id_db', '$image', '$image_keyword_p' , '$image_full_name', '$image_short_name_p', '$image_des_p','$file_size' ,'$image_resolution', 0)")) Warning: mysql_fetch_assoc() expects parameter 1 to be resource, … |
| | Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\a_upload\index.php on line 114 line 144: while($row = mysql_fetch_assoc($R)) $count = 0; $Q = "SELECT (SELECT image_short_name FROM user) as `image_short_name`" .",`image_id`,`user_id`,`image_short_name`,`image`" ." FROM `image`" ." ORDER BY RAND()" ." LIMIT 5"; $R = mysql_query($Q); echo " <!DOCTYPE html> … |
| | 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 … |
| | Here is the code for my login page <!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>Login</title> <style type="text/css"> #apDiv1 { position:absolute; width:200px; height:115px; z-index:1; left: 608px; top: 201px; } #apDiv1 form table tr td { font-family: "Trebuchet MS"; } </style> </head> … |
| | 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 … |
| | I am trying to add an username and password into a database using JSON. I cannot get it to work, any ideas? Thank you. <?php mysql_connect("localhost","sdr001","************"); mysql_select_db("tristate"); $userID = $_POST['userID']; $password = $_POST['password']; $q=mysql_query("INSERT INTO users VALUES(>'".$_REQUEST['userID']."'"); while($e=mysql_fetch_assoc($q)) $output[]=$e; print(json_encode($output)); mysql_close(); ?> |
| | 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); ?> …  |
| | I have this form that i need to save on Mysql database but i'm stuck on what I should do. This form needs to be done every 3 or 4 months. Every saved information stays saved in a row. This form has alot of radiobuttons,textboxes and comboboxes that I save …  |
 | I have city and its corresponding locality. City is showing dropdwon and Locality in Dropdown-Checkbox I got code Dropdown-Checkbox, when user clicks city then its locality will show in Dropdown-Checkbox. It is showing multilist control in thepage but when I choose city it is showing multilist-box rather Dropdown-Checkbox. How I … |
| | 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 … |
| | Hi, I've made an application and it connects to my database. But the issue is the details of the database can be found out through packet logging or something. How can I stop this from happening and secure it, without having to have a third party such as PHP script …  |
 | Dear friends, This is my table: CREATE TABLE IF NOT EXISTS `exam_student` ( `exam_roll_no` int(10) unsigned NOT NULL AUTO_INCREMENT, `enrol_id` int(10) unsigned NOT NULL, `exam_id` int(10) unsigned NOT NULL, PRIMARY KEY (`enrol_id`,`exam_id`), KEY `exam_roll_no` (`exam_roll_no`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; I am trying to get the field **exam_roll_no reset … |
| | Hi, I want to update a column in **same table** if another column is updated but I'm getting error message. > Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger I tried two different approaches but no luck. Same error. … |
| | Hi all, i have 2 shared host server(www.nextsoftech.com(ip:64.202.123.78) and www.simpletelecomltd.co.uk (ip:208.91.198.107)). i want to access nextsoftech.com 's database from simpletelecomltd.co.uk 's script. that's means i stor all script simpletelecomltd.co.uk this server. Would any one help me how can configure and what is the connect code in php? thanks you sumain |
| | I need some help. I'm loading a .php file using jquery. the php is a mysql query that pulls all the cities from Alaska. The problem is that I wrote my query a certain way and it seems jquery changes it when it loads it. state_alaska.php include 'config.php'; include 'opendb.php'; … |
| | Hi all, I'd like to know if it is possible to create a perl script that would take the names of image files with its extension of say 10,000 images from out of a folder and place them into a database table in separate rows to use as sample data? … |
| | Hi all, I'd like to know if it is possible to create a php script that would take the names of image files with its extension of say 10,000 images from out of a folder and place them into a database table in separate rows to use as sample data? … |
| | Hi I have two Mysql tables, one with the information in and another with payment information in. I want to echo the results that have paid first and then the rest of the results. If information has no payment associated with it it does not appear in the payment table. … |
| | I am developing an sql query to use to grab information from a postgres db. The scenario is as follows: the database I am grabbing information is the backend postgres database of an application (Tableau). My objective is to pull all of the workbooks, views, and datasources (considered objects) that … |
| | Hi, If i want to create a user in MySQL only to allow the Php program file to access the database and show results in my website what priviliges should i give to the user. So that access to my database is never compromised if someone can get the password … |
| | I am using Hindi Font and storing into database. While inserting I use mysql_real_escape_string() function; its working fine on local but not on server. **showing on server** Its adding extra slashes; but in local its showing correct INSERT INTO `tbl` (`num`, `address`, `name`, `father`, `state`, `city`, `gender`, `mobile`, `namdan_date`, `file`, … |
| | I'm trying to develop an interactive website using php and i want to display image(retrived from mysql database) and some text on the home pag. but the image retrived from my database fills the whole page. how can i display both text and image on the same page? |
 | hello there - been awhile since ive been about but im ready to crack on with my learning :) kk i used to have this installed on my last "free" host and it worked fine now im on a paid host (hosting24) it doesnt seem to want to work correctly.. … |
| | i want to go inside the if statment if i have both things in one row. so if i have image_id = $image_id_g and user_id=$user_id_s on same row. i wan tto go inside the if statment. but this is not working. i thinkg this query is testing two things sepeartly. …  |
| | I recently decided to try out a simple PHP/MySQL pagination script I found online. After replacing all the required data and creating a connect.php file with my db information, I got a bunch of errors on the page with the script: here they are, in order: Warning: include(connect.php) [function.include]: failed … |
The End.