11,093 Topics
 | |
| | 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 … |
| | I am new to php and mysql I want to crate a query that does the update or adds a new table if it is not in database. I get on else for echo: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/public_html/shop/dokumenti/up2.php on line 53 … |
| | 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']){ …  |
| | Hi, With resources on the internet I have created two versions of a login page :- one with mysql_fetch_object and the other without it. I would like to understand which approach is a better and why. Following is the code with mysql_fetch_object :- <?php session_start(); include "dbconnect.php"; if(isset($_GET["op"]) == "login") …  |
| | hello everyone, i have read through other post but could not resolve my issues. i need someone to see to my code. i am trying mysql_real_escape_string for my datas. but the one without it can insert properly while the one with the mysql_escape does not. from my code, i am … |
| | 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 … |
| | this works fine $view_query = mysql_query("SELECT ip_address FROM view"); but this query below give me a error $view_query = mysql_query("SELECT ip_address FROM view WHERE ip_address = $user_ip") or die(mysql_error()); error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the … |
| | 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 … |
| | when im test in my local machine i dont have any error but when im trying to test in web i have this error, the same DB, the same tables, the same data in both structures any idea???? Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in … |
| | I've been looking into security for PHP and came across MySQLi prepared statements. After doing some research I'm confused about why you would use these instead of normal SQL query. A prepared statement looks something like this: $quer=$db->stmt_init(); if($quer->prepare("INSERT INTO `test` (`first`,`second`,`third`) VALUES (?,?,?)")) { $quer->bind_param('iss',$aa,$bb,$cc); $aa=1; $bb="something"; $cc="testdata"; $quer->execute(); … |
 | hello guys how are you sorry i have another question i want to display images on left side and right side on my website for example in this code i have 9 images and i want to spread them 4 on the left side and 4 on the right side … |
 | Hello to everyone, im having trouble in inserting a date like "2012-12-06" into a database mysql, Im using phpmyadmin+wamp and adobe dreamweaver!I want to use 3 textfields, one for the year, other for the month and a last one for the day, but I always get an error by using … |
| | 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 … |
| | afternoon all! I am having some issue writing a log in script for a website! this is my first ever attempt so i am hoping it is something very straight forward!!!! I am getting the following error message - Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource …  |
| | 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 | | … |
 | I know that this forum is for HTML and CSS, but I have a problem and I am not sure where to take it, so here it is. I am using this code: <div class="edit"> <input type="button" id="bold" style="height:21px; width:21px; font-weight:bold;" value="B" onClick="fontEdit('bold')" /> <input type="button" id="italic" style="height:21px; width:21px; font-style:italic;" … |
 | Hello, How to add multiple data in mySQL 5.1 using vb.net 2008? Do it needs an array?  |
 | 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 …  |
| | Why do I get the following error? and How to fix? Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in/home/gaogier/public_html/pages/monsters.php on line 217 If i add the or die part, I get this message. You have an error in your SQL syntax; check the manual that corresponds … |
 | 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 … |
 | Hello Community, Is there a website that has a database like phpmyadmin that i can access from my website? Please help... |
| | I didn't post this in the regular IT jobs folder because this is strictly PHP/MySQL. I am creating an online community (friend/dating/boredom site) which will rival those such as myspace.com and facethejury.com. At current time the whole user database is complete, which includes the ability for users to create profiles … |
| | Are you a freelancer or programmer for hire? Join, post & bid for projects free. Thousands of skilled programmers, skilled freelancers to choose from. Ultracoder is a developer oriented outsourcing site. Skilled programmers will bid to complete your project right now. Computer Based programs, Training, Web Services, Language Specific programs, … |
| | I am trying to Upload a csv file then split it up into an an array and build a query to insert it into a mysql table I have succeeded in getting this to work with one exception when I come across a field seperated by commas and enclosed by … |
| | 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 … |
 | Hi, I have following code. Dim myData1 As MySqlDataReader Dim sqlquary1 = "INSERT INTO table1 (text1) Values (Value1); INSERT INTO table2 (text2) Values (Value2); INSERT INTO table3 (text3) Values (Value3)" Dim command1 As New MySqlCommand command1.Connection = mySqlConnection command1.CommandText = sqlquary1 myData1 = command1.ExecuteReader mySqlConnection.Close() I need to send few …  |
| | 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 am looking for a script that will allow visitors to my web site to click an image containing a member's name, and receive a validation page. The href, attached to the image, would look something like this: <a href="https://www.mysite.com/validate.php?url=www.memberdomain.com" > If the domain is in the mysql database, the … |
 | hihi, can someone help me with this problem; i want to be able to feed a value from a dropdown list A as a condition for items in dropdown list B. both dropdown list are in the same form. the values for both dropdown list are extracted from my mysql … |
| | Ok, I installed a php program on my website, not nuke, i need forums so i installed phpbb on a stand alone database, when i deleted the php program and install phpnuke, it comes wiht the phpbb already, which u really must use to have all the member names correct, … |
| | Ok, right now i have an array that the user enters into a form and when they submit it, it is loaded into a PHP script that i have set into an iFrame so that you can modify the mysql database in real time (sorta) but heres my problem. i … |
| | Can any of the gurus out there please help? I am having a search problem with PHP and MySQL. I wish to search the MySql database from 2 criteria. Using 2 dropdown boxes. I wish to search from 1 dropdown box called searchtype and another called searchterm. The problem is … |
| | halo every body: sorry ! my english not good,i only can use very simple english.. i use "fgets" get a webpage date,but website is use utf8.. when i use "substr" get some string,then i write into mysql. but mysql filed can't show big5!i don't know solution.... my mysql version mysql-3.23.58-1.9 … |
| | 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. |
The End.