10,946 Topics
 | |
| | 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... |
| | 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 … |
| | 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. |
| | 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"); … |
| | Hello there, How to add items in combo box from mysql database? 'mySQL statement 'tryCatch method ComboBox1._______ = myReader.GetValue(myReader.GetOrdinal("Uname")) I'm trying use this: ComboBox1.items = myReader.GetValue(myReader.GetOrdinal("Uname")) but an error occured. |
| | 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 … |
 | Hi all, I've problem with inserting data values from .csv file to MySQL data table. My query as follows; LOAD DATA INFILE 'C/Customers.csv' INTO TABLE pc.customers FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (CustID, RegDate, CName, CAddress, CPhone1, CPhone2, Order_OrderID) It returns error msg as follows; **Error Code: 1406. … |
 | Hi All, I have made simple CMS with PHP/MYSQL. It make use of TinyMCE as Javascript editor. I can delete as well as add the contents. But How can I load the contents from database to TinyMCE for editing and saving? Here is my PHP code to add contents using … |
| | Hi, I am a complete novice with MySQL but have been persevering with it for a project I am doing at work. I have created a results server to analyse and collect data I receive from quizzes I have created using QuestionWriter HTML5. I have figured out how to run … |
| | My school has an apache/mysql server that we make and host websites from as projects. I am doing an ebay type site where people bid on a product until time runs out. Problem is I don't know how to trigger that the product should be delisted and the buyer and … |
| | I have a MYSQL database that house user names and user numbers. the process is user goes to a url inputs all the information. Goes to the office they search for the user makes sure all the information is correct and assigns them a number inputs it into the the … |
| | Hello guys.. Do you have any idea how to make a Global Positioning System (GPS) using PHP & MySQL? I don't know where should I start. Do you think it's possible in PHP & MySQL? Please help. Thank's ! Regards, amulet_john  |
The End.