11,093 Topics
 | |
| | I have a large array. Is there an alternate method to check if $value in the array is present in the MySql table vote and if not then insert $value into vote. This is what i am doing currently. Is there a better method? [CODE]foreach($rowids as $value) { $select = … |
| | is there a significant difference between phpmyadmin and mysqlbuddy? i mean does they differ in codes? coz i have to make a website that checks whether the username and password exists in the databse. here is my code for looking up in the databse. [CODE] <?php if(isset($_POST['submit'])) { include 'connection.php'; … |
| | Hi, Can anyone explain to me what does this piece of code mean? [CODE] <roleManager enabled="true" defaultProvider="MySQLRoleProvider"> <providers> <clear/> <add name="MySQLRoleProvider" type="MySql.Web.Security.MySQLRoleProvider, MySql.Web, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/name" autogenerateschema="true" /> </providers> </roleManager>[/CODE] Whenever i run the program, there is this error message that prompted in my web browser Parser Error … |
| | we have our system running but our system needs to be modified because we did something wrong...we are doing an "Internet monitoring System" in our school library where the user can only access the internet 1hr a day, and he/she cannot use the internet within that day if he couldn't …  |
 | Hello first code I need to know the code to get data from mysql table that have a letter a i mean i have a table called "Games" there's a games start with a b c d e f g h I need to retrieve games That begin with (( … |
| | Hi all, just wondering what the best way is to structure time in sql database. For example, at present i use this format ; 19/08/2011 (which is day/month/year). when i call this in a sql statement, it shows all results, but not in a chronological order. Can any body solve … |
 | Hi I just set up my IP Board. Now i want to retrieve some of the data via mysql, so far I have no problem getting a table into a datagridview, but what do i do to get a value from a table right now i got SELECT * FROM … |
| | Hello, I think I made a mistake while connecting my tables with foreign keys :S here's the DB- table 1: [U]Id[/U],[U] year[/U],..... (2 Primary keys) table 2: [U]tbl2Id[/U], ... now the table that connects tbl1 and 2 with m..m relation- table 3: [U]Id[/U],[U] year[/U],[U]tbl2Id[/U] I set the foregn keys for … |
| | I am facing problem on sum of dynamic array value. For example : [B]tablename : totalamt[/B] ref_no | Amount 1 | 58 2 | 12 3 | 11 i am using check box to select the ref_no. now i am selecting 3 check box now and submit it. Now it … |
 | Okay so me and a friend of mine are discussing the following: If you have 1. a table with 10 fields, each a varchar(255) or 2. a table with 10 fields, each a varchar(1billion) [B]Which would be better, performance wise?[/B] I say it won't matter, because MySQL reads the field … |
| | I'm trying to creat a search procedure that will search table game and return all rows where columns title, description, platform, and gameid are LIKE parameter searchtext. This parameter is coming from many different pages as a Session("searchtext"), and I'm using a UserControl to send the Session, all pages in … |
| | Good day. I'm new here and I'm nt sure this post should belong in here or not. I had done my programming on the virtual machine while having mysql database set up in my PC. I was unable to get the data from my PC unless I installed another database … |
| | I keep on getting this error "Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in" from both of my while loop conditions. Can anyone review my code and let me know what I'm doing wrong? [code] <html> <head> <title>Task # 4 - Test Page</title> </head> <body> <?php $link … |
| | I have a page full of user-submitted updates and stuff. Basically the basic stuff. I am taking it out of a database. I have this so far: [CODE]$getnews = mysql_query("SELECT * FROM news ORDER BY $order LIMIT 50"); [/CODE] and $order is determined by a drop down menu on the … |
| | Hi, Basically I'm creating and implementing a dynamic website as part of my uni final year project but i am a beginner in php so need some help. First, I'm not entirely sure about how i should go about creating the database, tables and inserting data. I don't mean in … |
| | [code=php] <?php $conn = mysql_connect("localhost", "root", "dotherz"); //connecting to database if($conn) //testing if the connection was stablished { mysql_select_db("orders", $conn); //selecting database from your localhost $qry = "SELECT * FROM customer WHERE customerId = 1"; //the query to get the first user $result = mysql_query($qry); //executing the qry and passing … |
| | I have hit a bit of a stumbling block with a project I am working on. Basically it tracks football (soccer) results and everything works fine as things are but I there is something else that I hope to do now that I cannot get my head around. Basically, there … |
| | hii all, i've create upload website, i've been stuck with following error i had 3 tables in my database table request, table upload and table feedback table request : id_request;---primary key subjek; isi; pelaksana; table upload : id_upload,----primary key id_request,----foreign key filename, filedata, filesize, filetype table feedback : id_feedback,----primary key … |
| | hi,i want to insert date into mysql table..but the date must not be current date.for example if i am giving 12-3-2003.then ,this date should be insert into the database...... thanks advance  |
 | |
| | I installed a wamp server on my pc and initially, it runs.(localHost&phpmyAdmin) but when I installed mysql for my java subject, I can't access the php database anymore. error message looks like this: MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO) I am thinking that …  |
| | Hi! I'm trying to show 5 random images from my database and i seem to be stuck. Would appreciate some help or tips. I obviously dont want any duplicate images. Have tried to figure it out by googling butt my head hurts too much xD Got thumbnails for the picture … |
| | The code I used isn't working with sql, and not sending a mail message, but it's perfectly formed(Or not)? Please help! [CODE]<?php require_once('recaptchalib.php'); require_once('config.php'); $privatekey = CAPTCHA_PRIVATE_KEY; $resp = recaptcha_check_answer ($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]); if (!$resp->is_valid) { // What happens when the CAPTCHA was entered incorrectly die ("The reCAPTCHA wasn't …  |
| | Hey All, Been banging my head into the wall on this one. I have 2 tables one for users 'myMembers' and one for products 'products'. Each table has a auto increment id. The myMembers id is the user id and the products table id is for the product id. I … |
| | On a project I am doing I am making a Feed Flow of recent updates. Problem is I cant find out to overcome the following. There are two tables, shouts and journals. what I want to do is pull records from them both and print them out with the newest … |
| | Here i have four tables in my Database named "test_center" those are 1) "test_user" --> PK = u_id 2) "test_metadata" --> PK = test_id 3) "student_detail" --> PK = Student_id 4) "test_records" --> PK = test_record_id (Child table) table 4 is child table and 1,2,3 are masters..! i am trying … |
| | My query below has been working okay for 1 year now and suddenly it is giving an exception: [CODE] (SELECT distinct(R.imei),R.mobile,S.msg,S.reply,M.model, left(S.receiveTime,10) as receiveDate, right(S.receiveTime,8) as receiveTime,'' as 'Reason' from dbSAMSUNGmain.tREGDATA R,dbSAMSUNGmain.tMODELS M,dbSAMSUNGmain.tSMS_TRANSACTIONS S where S.mobile=R.mobile and replace(replace(S.msg,'/',''),' ','') LIKE concat('%',R.imei,'%') and (S.reply like '%Registration successful%' || S.reply like '%Reg … |
| | I use the top table as a cart for 1 customer, and the bottom table for order. I wanted to get the productprice, productname, productqty and put it into orderdetail field. Help and suggestions are very much appreciated. Thanks in advance. *attached a pic of the tables. |
| | hi,thank you for your attention.:P I am thinking of if there are some thing in php like event or trigger to inform another php file, :idea: that I'v just insert something into the mysql database . thank you for giving me some advices~ :) |
| | I'm trying to write an SQL (MySQL) Statement here using an if statement but all am getting are countless errors. I've narrowed down to simple instructions but still no breakthrough. [CODE]DELIMITER // CREATE TRIGGER confirmation_triggers AFTER INSERT ON `old_deliquencies` FOR EACH ROW IF new.status='True' THEN INSERT INTO `notifications` VALUES(NULL, new.loan_id, …  |
| | Hi, I don't usually develop for PHP or MySQL, but I am just doing the odd job for a friend. I am having issues with a MySQL query though. A few days ago I must have done something to the code somewhere, and it is throwing up errors now. I … |
| | I am trying to set up a form for potential students to give their information for a language academay. When I tested the form with <input type="text" name"Nombre"> type of fields everything went fine. As soon as I tried to introduced drop down menus or typ radio elements the data … |
| | Dear All, I have a query as below SELECT DISTINCT (productID),totalAmountAfter,transactionDate FROM tbltransaction WHERE transactionDate BETWEEN '2010-01-01' AND '2010-12-31' ORDER BY productID,transactionDate DESC . My problem now I want is that for each product only pick one line that is the last line since I have ordered by the date. … |
| | Hello everybody, This is the first time that I write on. I have working with seven tables, but the wrong when I execute an "insert" is= Cannot add or update show a child row: Error: foreign key: This is a wrong that it was generated, however before that I changed … |
| | hi guys, i am trying to write a query that would basically display me pas 4 week, however if lets say today is Wednesday the pas for week would have to start from last Friday, none the less if i have to run the query on monday i would want … |
 | my table design is [CODE] date income expenses 2011-08-5 1000 500 2011-09-6 7000 400 2011-10-7 2000 300 [/CODE] I have daily expenses and Income in the above table.I need to retrieve monthly(sum of daily) income and expenses for particular year. How should i write query for that . Pls help … |
| | Hi all, I'm trying to insert an array (which I've decoded from a JSON object) into a mysql database (for the first time!) and keep coming back with a "Could not connect - Column count doesn't match value count at row 1" error message. My server and database connections are … |
| | I have php code running fine from the server. but if i use any mysql functions e.g. [CODE]mysql_connect()[/CODE], the server does not render the page. it keeps on "waiting for localhost...". what could be the problem. |
| | Hi everyone, Having a little difficulty getting anything from this. The code appears to me to be correct, then again I have been looking at it for hours, so it is possible there could be a mistake...... :/ Anyway, the code seems sound, should let me login and instead gets … |
 | Hi, I am following the chapter on Replication from the book High Performance MySQL. There it is written that I need to enable binary logging and specify a server ID for my MySQL server. It instructs me to write (or verify the presence of) the following lines in the master’s … |
| | Hi There, MySQL is not my strong point so any guidance or advice will be greatly appreciated. I want to know what's the best way of linking multiple MySQL tables together. I have +-10 tables that will interact with each other. Example Tables : users, logins, communication, sightings etc. When … |
| | The below coding is the javascript coding in which i have used [B]AJAX coding also[/B].its only pagenavigation coding. [CODE]function change(which) { if(which=="page1") { document.getElementById(which).style.borderBottomColor="white"; document.getElementById("page2").style.borderBottomColor="#778"; document.getElementById("page3").style.borderBottomColor="#778"; document.getElementById("page4").style.borderBottomColor="#778"; } else if(which=="page2") { document.getElementById(which).style.borderBottomColor="white"; document.getElementById("page3").style.borderBottomColor="#778"; document.getElementById("page4").style.borderBottomColor="#778"; document.getElementById("page1").style.borderBottomColor="#778"; } else if(which=="page3") { document.getElementById(which).style.borderBottomColor="white"; document.getElementById("page4").style.borderBottomColor="#778"; document.getElementById("page1").style.borderBottomColor="#778"; document.getElementById("page2").style.borderBottomColor="#778"; } else if(which=="page4") { document.getElementById(which).style.borderBottomColor="white"; document.getElementById("page1").style.borderBottomColor="#778"; document.getElementById("page2").style.borderBottomColor="#778"; … |
| | Dear All, I have a table tblEventAlert as below. So what happens when the data gets insert into this table the problem is that the eventAlertID is autoincrement. Then below it I have another table. My problem is that I want the eventAlertID to be stored into the tblSCvData. I … |
 | what's wrong with my code? i'm new to java, can someone help me? the data is not showing. [CODE] public class GUI { private static JTextField fname = null; private static JTextField lname = null; private static JTextField search = null; private JPanel panel = null; private JPanel tablePanel = … |
| | Dear team, Please explain, which one will be faster in Mysql for the following query? SELECT * FROM `userstatus` where BINARY Name = 'Raja' [OR] SELECT * FROM `userstatus` where Name = 'raja' Db entry for Name field is 'Raja' there is no key for the field. I have 1000000 … |
| | I want a ready made database of the countries all over the world, the major cities of those countries and their time difference (in hours) from GMT. Please tell me where to get it. I need it soon. |
| | What im doing is i have a form with 4 inputs like below. and im using the post method to store the fields values so i can send them to the database. what i neeed is each input to be put into a separate row in a databases table. also … |
 | banner_manager.php [CODE] //Cek apakah ada file yang diupload if((!empty($_FILES["uploaded_file"])) && ($_FILES["uploaded_file"]['error'] == 0)){ $gambar = uploadPicture("uploaded_file"); } if (empty($id)) $sqlstr = "INSERT INTO banner(link, gambar) VALUES('".$link."','".$gambar."')"; else $sqlstr = "UPDATE banner SET link = '".$link."',gambar = '".$gambar."' WHERE id =".$id; $result = mysql_query($sqlstr) or die(mysql_error()); $confirmation = ($result)? "Data telah … |
| | Hi, Is there a way i can pass variable column names to a stored proc? Here's what i want to do: i have lots of tables and for each of those i want to select out a few columns. e.g from table titles i want to pick out title_name and …  |
| | php and mysql form Hi all, how I can add values in a table to a combo box in html .. eg: the user's table has the id 1,2,3,4 and that using a query, being able to move to a combo box, to make a selection of id?. Greetings and … |
The End.