7,368 Topics
| |
Hello to everyone, im having some trouble in setting a position on a table in php. I learn how to display a table in php on school and with some research through the internet, but not how to customize it. Is it possible to display a mysql table from a … | |
I am unable to execute the editProfile() method in MainMenu class. The purpose of the method is to be able to extract the bean values and display them on the empty textfield. I am not sure if i did it correctly. any recommendations for any changes to editProfile() method. public … | |
I don't quite understand how to make a Procedure as most of my processing takes place in my scripts. I have a set of 3 Queries that are almost identical that I would like to combine them to return a result set. The queries are: SELECT Date, Location, Sum(SubTotal) FROM … | |
| I need to update values form one table to another and create values if they are not there How can I do this for all values or form values from one ID to another This is the query but I need to run it for every ID and that is … |
| Hey if anyone could help me out, that would be superb. It is probably something simple but i am always getting undefined index messages. This is the latest example. [B]Notice: Undefined index: savebtn in C:\xampp\htdocs\practice\editprofile.php on line 20[/B] And this is the php. [CODE] if ($username){ require ("scripts/connect.php"); if ($_POST['savebtn']){ … |
Dreamweaver 8 in windows 8 with xampp following 2 errors 1) Unidentified error occured 2) There is no testing server found on this server machine /.php> These are occured When clicking on plus then MySql Connection dialog box opens Connectin name - Con MySQL server - localhost user name - … | |
script in file 1 <?php // Check if he wants to register // - Make sure that param exists // - Check length if (isset($_POST['username']) && strlen($_POST['username']) > 0) { // Check if passwords match. // - Make sure that params exist // - Check length // - Check matching … | |
i have a server called OAS-VB and a network pc what i need is the sql that installed on pc see the OAS-vb server to reach the database file ??? or some one can tell me how to configure the sql server for network to reah the pc ?? i … | |
Hi, I have been trying to create a login facility using PHP/mySQL and so far I have managed to get everything working apart from changing/updating the stored user password. The code I have used is basically just the registration script with a few changes so that it will update a … | |
Hey guys, have a quick multiple database connection question I hope will be simple to answer. I've worked with this type of situation several times, but I must be missing something. I have a newspaper website that has 8 databases (news, obituaries, opinion, etc..) which can hold about 7 counties … | |
Hi, I have this website which I am developing, but it is having display problems. I have a directory called 'includes' which contains 'header.php', 'login.inc.php' and 'login_form.inc.php' 'header.php' - displays the normal doctype, meta tags, styles, etc. 'login.inc.php' - is the actual process of the login form once the form … | |
I have a problem with retrieving a value from a query. I know what the problem is but not sure how to solve it. Pretend I have this code: $sql = mysql_query("SELECT * FROM sometable WHERE thisvalue = '$_SESSION["value"]'"); // This will always return one result. $result = mysql_fetch_row($sql); echo … | |
Hello :D I am using the twitter API to perform a search for a certain author, and storing the results in a database so that I can perfrom an action on each entry. However, there are many duplicate results that have small differences at the beginning of the string or … | |
I am totally new to vb.net, still I am planning to try it for a project, in which there will be standalone machine using an access database to query and update different tables. While in VB6 I was able to define recordsets using Microsoft.jet.oledb.4.0, in VB.net I have become a … | |
Hi, In order to be able to display the graph I want I have to run two queries. The first query looks like this. SELECT PercentageScore,COUNT(*) AS 'IndividualFrequency' FROM resultsets GROUP BY PercentageScore I than want to take the IndividualScores and use them again in this Query. SELECT PercentageScore,CONCAT(100*(IndividualFrequency/32),"%") AS … | |
Hi, This has been troubling me for the last hour and I cant think of a way around it. My SQL table looks like this: **Name, Cost** Matt, $5.00 Carl, $4.50 Tom, $6.00 Tom, $7.50 I need to make a query so that it puts anything with the same **Name** … | |
Hello, I am a newb all the way around and I hope that I explain this thoroughly in order to get the help I need. I have a mysql db inside of my python program that generates a hint. I need to have a random number (which will later be … | |
I habe table one with Col 1 (PK) Col 2 (NN) Col 3 (NN) Col 4 (NN) Col 5 (NN) Col 6 Col 7 Col 8 Then I create table two with Col 1 (PK) (AI) Col 2 Col 3 (FK) That col 3 from table two is col 1 … | |
I am creating a basic PM system for my website. I have just a basic table for a pm: mysql>describe PM; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | PMID | mediumint(9) | NO | PRI | NULL | auto_increment | | … | |
hi i have a dropdown which is connected with a database and containing some sort of items, and a gridview. i want to show only those values into the gridview which is select from the dropdown. for example if i have the following values in to the database: value item … | |
Hey there, I need help with a query. The typical situation is like this: I expect, say, 1000 rows out of a query that is based, say, on lastName column. One column is, say, firstName. I know I only have like twenty unique names that occur on multiple rows. I … | |
Dear all, I would really appreciate your help and assistance with a bug i'm facing in myphpadmin Mysql table. I have a table which is named as total amount. I also have a front end php. interface where i do my data entry from. When I enter for example (100000) … | |
I have the following code which is intended to supply the family and given names of people who are in the users table but not in the quiz table. Can I even do this, and this throws an error anyway? `$query = mysql_query("SELECT quiz.userGroup AS q_userGroup, quiz.userDate, users.userGroup AS u_userGroup, … | |
Dear all, I would really appreciate your help and assistance with a bug i'm facing in myphpadmin Mysql table. I have a table which is named as total amount. I also have a front end php. interface where i do my data entry from. When I enter for example (100000) … | |
I have a table in a database that contains two columns username and bids.I want to select the unique and lowest value from the bids column.I tried using SELECT DISTINCT and then limiting with one,it shows the lowest value but the value is repeated a number of times in the … | |
Does anybody have any experience with changing an INT column to BIGINT so it will handle larger integer numbers? I have read a lot from searching the subject, but still a little leary of changing it on a live database. Would be nice if someone here has done it without … | |
I'm not sure why I suck so bad at this. I was recommended by my prof to use date as opposed to timestamp. I'm starting to think going back to timestamp would be easier due to built in php functions I can use. so in my original addproduct.php form I … | |
Hi I am planning to create web based association Management project. Can any one please provide me some sample or details which would me more helpful for me to develop the project. | |
A lot of code here. Basically I'm making an auction type site. This segment of code is for a user to upload a product: I'm pretty sure there isn't anything wrong with addproduct.php but for completeness I feel like I should post it. addproduct.php: <?php require_once('checklogin.php'); require_once('validate.php'); if(!isset($_SESSION['user'])) { //die("redirect"); … | |
Dear all, I have a huge problem and cant figure it out how to resolve it. I have a mysql database. which has plenty of entries in the table. I have linked my search.php page with my database everything is working fine the data is being fetched and showing the … |
The End.