11,093 Topics
 | |
| | hi, i am currently building an application that depends on a third party application written in .net using a mssql server database. i am more of a lamp guy and prefer mysql. to extend the application i would need to add some tables to the database. i am currently thinking …  |
 | I need a really good tutorial on how to alter MySQL databases, and to know how far you can alter a database without loosing or changing the information in the database. Thanx in advance for any help |
| | Hi, I have a query that I would like to be able to decide what fields to select based on the value of the fields in the database... Here is the query I have SELECT mem_id, company, fname, lname, addr1, addr2, city, state, zip, country FROM dc_order WHERE STATUS='W' What … |
| | I think I have a relatively simple problem, but forgive me, I'm new at this. I'm trying to take output from a dynamically created checkbox in php to a foreach statement to make a new string that I can use to request an update from mysql. In the foreach loop, … |
| | I got this error on my page when I tried to login, I don't know what happened please someone help me. What do I need to do? Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'steve_wff'@'208.113.246.18' (using password: YES) in /home/steve_wff/worldfamousflags.com/usssa/system/database/mysql.php on line 6 Error: Could not make a database connection …  |
 | **Hello cool peoples**, so I couldn't figure out if images could be added in the post therefore follow the prescribed link at the end of this post. Problem: I do not know how to create whats going on in the pictures. I try not to use terms to define what's … |
| | hi i'm trying to create a search function for my website and I keep getting this error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a7526299/public_html/SearchResult.php on line 158 <form action='SearchResult.php' method= 'get'> <input type='test' name='k' size='50' value='<?php echo $_GET['k']; ?>' /> <input type='submit' value='search' /> … |
| | Hi all, I created a database for my web application in VB and I'm trying to insert data in my login table but its keep giving me error i have login table which contains loginID UserId Acctype Password My PK is LoginID MyFK is User Id which connected to three … |
| | first off hi again. Now i dont know where to start this one script or let alone how to execute it. This is what i would like to learn how to do. I would like to output the current DB structure then take that and update another db with the …  |
| | I am new to PHP/MySQL and currently working on a project to learn it a little better. I have a bit of PHP code and it has a problem that I'm having a little trouble figuring out. Basically, it is taking session data and writing it to a MySQL database. … |
| | I have the following warning only when paword is wrong Warning : mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\mijn_stamboom\login\login.php on line 23 <?php include_once '../common.php'; include("config.php"); if($_SERVER["REQUEST_METHOD"] == "POST") { $myusername1=addslashes($_POST['username']); $mypassword1=addslashes($_POST['password']); $ip = $_SERVER["REMOTE_ADDR"]; $pass1 = md5($mypassword1); $sql1="SELECT * FROM stamboom_admin WHERE username='$myusername1' and password='$pass1' … |
| | Ok I am not getting any other errors in php or mysql but I keep getting returned Query was empty in my table. Any help is appreciated, if anybody needs more info on the code just let me know. This is basically a multi search tool for a huge database … |
| | **Hello cool peoples**, so I couldn't figure out if images could be added in the post therefore follow the prescribed link at the end of this post. Problem: I do not know how to create whats going on in the pictures. I try not to use terms to define what's … |
| | Hi, this is part of a script used to verify paypal payments and update a mysql database if the payment is verified. I had it working in a separate mysql table but I have now changed the table and it doesn't seem to be working. When the verification from paypal … |
| | create trigger ins_notification after insert on transaction_detail for each row Begin insert into sell_notifications(user_id, product_id, quantity) values(new.transaction_id , new.product_id, new.quantity); End; Can any one see where's the problem? :( |
| | Hi all, I'm trying to display the average of each row displayed in my table but am having a bit of trouble, any assitance would be appreciated. Basically the table displays the name, the score you gave them, and their average score. Here is my code below (example, names modified. … |
| | Hi I have never done this before and am having some trouble. Could someone tell me where I am going wrong: $sql = mysql_query("UPDATE `gigs` (txnid, payment_amount, payment_status, itemid, createdtime) VALUES ( '".$data['txn_id']."' , '".$data['payment_amount']."' , '".$data['payment_status']."' , '".$data['item_number']."' , '".date("Y-m-d H:i:s")."' )WHERE (gigname)=".$data['item_number']."'" , $link); In case I have … |
| | i have a table with day_date and price each record is displayed as below: Day_date Price Allotment 2012-05-20 500 2 2012-05-21 500 2 2012-05-22 500 2 2012-05-23 600 4 2012-05-24 600 4 2012-05-25 500 7 2012-05-26 500 7 2012-05-27 700 2 2012-05-28 700 2 what i want to do is … |
| | I have uploaded the database file and the error i get is Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'ethar'@'localhost' (using password: YES) in /home/eth/public_html/Connections/taking.php on line 9 Fatal error: Access denied for user 'etha'@'localhost' (using password: YES) in /home/eth/public_html/Connections/taking.php on line 9 What cud the problem be... Plz help. |
 | I want to pass my all database from windows to ubuntu on my computer. I think passing all releated data files will be enough so I need to find the files in my windows. Do you know what isthe directory path for these files? Also is it enough to carry … |
| | How do i insert this into my sql database? I have tried a few things like putting the array bracks on the upload file. when i do this it saves the image location but doesnt upload the image. This is my upload snippet for ($i=0;$i<4;$i++) { if($_FILES['userfile']['name'][$i]) { $uploadfile = … |
| | Really really need help with this one! I need to convert from php to mysql so that it reads language information from mysql, i made mysql table already but I just don't know how to change from php to mysql <?php session_start(); header('Cache-control: private'); if(isSet($_GET['lang'])) { $lang = $_GET['lang']; $_SESSION['lang'] … |
| | Hi. I'm a newbie in php, and I recently bought a book called PHP and MySQL Web Development by Luke Wlling and Laura Thomson. I was able to make an order form in Chapter 1, but in Chapter 2, I have to process orders so that every time I fill … |
| | Hi I am trying to allow users to update records in a MySql database through php forms. One problem I am having is with a drop down field for dates. I want to echo the date already in the database so that the drop down menus is set to that … |
| | I don't have any proper experience with MySQL but need to make a query from python to a database that would return a list of vacant apartments. So, I know the number_of_beds, start_date and end_date and need to get a list of available apartments. The two MySQl tables that I … |
| | Hi I am trying to run a query where the user enters a number, and it searches the table for it and displays any results within 50 of that search. e.g. user searches for 500, anything from 450-550 would be shown. I have the code for showing an exact result … |
| | hi everyone, I am looking into a small problem I have with a mysql database. At the moment users can upload upto 4 images per item. I am using php to display the images from the database, but if a user has only uploaded 2 images I am getting empty … |
| | I want to allow registered members to upload files to the file system I have two mysql tables members for registered users and a table files to have a trace which member uploaded which file. now, I only would like to allow the upload of PDF's to the file system. … |
 | Hey I have the following code private void buttonInicio_Click(object sender, EventArgs e) { MySql.Data.MySqlClient.MySqlConnection conn; String constring = "server=localhost;database=bd;uid=user;password=pass;"; try { conn = new MySql.Data.MySqlClient.MySqlConnection(constring); string query = "COUNT (*) FROM table WHERE usuario=" + Globales.usuario + " AND pass=" + Globales.contra; MySqlCommand cmd = new MySqlCommand(query,conn); cmd.CommandType = CommandType.Text; … |
| | Hi All, Don't know if this is the right forum for this query, but couldn't find anything more suitable. I have written a new app in VB.net as a front end to a mySQL database held on a PC on the LAN running Windows XP. This worked fine for a … |
| | hi, I’ve got a big problem. Could anyone give me a hand? My aim is:Remove the duplicate data, that is, the various entries of EndTime and Qos for a same ServiceID due to the repeated feedback. The rule is to only keep the records with the lowest Qos for a … |
| | During some recent project issues I found myself asking this very question: **Does MySQL short circuit WHERE clause statements?** After doing some research and finding that several other people and technical forums have posed this question, with several answers pertaining to be intelligent but that amount to *"i don't know"*, … |
| | I have created a simple database designed to accept domains and their associated TLD values: **CREATE TABLE domains(name VARCHAR(50) NOT NULL, PRIMARY KEY(name), tld ENUM('.com', '.net', '.info', '.org', '.co.uk', '.co', '.biz', '.info', '.de', '.me', '.nl', '.it', '.ch', '.li', '.us', '.name', '.ws'));** ...and I now need to display a form with … |
| | Hi! I have started learn about Query and PHP, and i don't know what to do next. I have made table with query help i can show in table records from my Database, so far i have well, but next what i want to do is every record in table …  |
| | |
| | i have little problem with one algo . first i have two tables there are above one lac records in each table . table 1X structure id domain 1 google.com 2 daniweb.com 3 yahoo.com table 2X structure id domain 1 google.com 2 facebook.com 3 youtube.com now my task is to … |
| | Hello, I'm trying to set up a website where user can upload files to which should be readable by everybody. Logged users should be able to comment on the files and rate the files. I'm new to MySql and quite new to PHP so it has taken me already lots … |
| | Ok, so the scenario is a database which stores customer contracts (to keep it simple) so that every time a contract is expired and renewed a new version is created in the database to reflect any changes (terms, price etc). My page needs to display a list of the latest … |
| | Hey I want to search for a text string but I dont know what table or column it is in. I just know the database that it is in. I know also that the type is a text type. Any query I can do or in MySQL Workbench? Thanks! |
| | OK, this is probably a variation on a previous question but the original question was never resolved, so I will present it on it's own to avoid confusion. I have a member data table called 'members' Primary key is 'mem_id' I have 7 different 'position' tables called position_1, position_2, position_3, … |
| | hi guys... i really need reference ASAP what i'm trying to do now is: -creating API from my website so that -other website can read certain content for my website database and put it in their website. i don't know if i explain it correctly, i tried to googling for … |
| | I've had nighmares about this since 3 days ago and couldn't find anything by googling so here I am. As the title says so i need to find a way to store and then retrieve images from a mysql database I have tired the code below to do so (the … |
| | Hi, I am trying to query a MySql database based on which search fields are filled in and ignoring those that aren't. I have only got as far as the first part and it isn't working, could anyone tell me why? It doesn't seem to be finding anything in the … |
 | I need to transfer the sql server databse tables to mysql . How can i do that?.  |
| | Hi there, I would like to make an email form that would select all the emails from a MySQL db and then send that message to all addresses. I got this script but was unable to get it working. Any help would be great. [code] <?php //Connect to database mysql_connect("localhost","user","password") … |
| | Hey guys, I'm just wondering if it's possibe to get the results from a query and then assign the results to a variable. So I will run a query which will return the names of the tables stored in the database, then I want them to be stored in a … |
| | I am having problems getting getJSON call to work. At the moment it doesn't retrieve any data, however when I change the '$.getJSON' to ' $.get' it retrieves the data in it's encoded format: [{"Page":"User Journey","Description":"Interactive User Journey Diagram","Bounce_Rate":"0","Avg_Time_On_Page":"0","Page_Views":"0","Click_Rate":"0"} What am I missing from the $.getJSON call? getstatistics.php: $query="SELECT Page, … |
| | Hey all, Some rows of a single table in a database that I administer manage to have gone missing. Not that big of a problem: I have a backup. The issue is that there has been more information added since the old data was lost, so I can't do a … |
| | I have a query in which I need to display some group function figures SUM COUNT etc from a joined table. I also need to select the latest version (by datetime) of a matching record from a separate table, which I can do using an ordered subquery in the join. … |
| | i have a form and checkloginstudents.php,,but my problem,i can't display the details of a user after login,, this is my form: <form id="form1" name="form1" method="post" action="check_login_students.php"> <label>Name <input name="username" type="text" id="textfield" /> </label> <label>Password <input type="password" name="password" id="textfield2" style="margin-top:5px;" /> </label> <label> <input type="submit" name="button" id="button" value="Submit" /> </label> </form> … |
The End.