10,940 Topics
 | |
| | I have database entrys that have a date column ( mySQL date type ) in this format(2011-5-30). I want to compare that date with the current server date and with 3 days before that day, to automatically send an email to a specified address. |
| | I want to synchronize the data in the record store in mobile phone with mysql database. I connected them through a web service. How can i sync them. What is the way?? i looked in at syncML. Didn't found how to use it properly. Is there any other ways?? please … |
| | hi, i have a table setup where the user selects multiple check boxes from a form and it inserts into the table. this works fine and when i do a report i can do something like this: [CODE]SELECT COUNT(*) as MembersCount, MemberCounty FROM membersDetails WHERE MemOpportWith LIKE '%msg%' GROUP BY … |
| | I think I realized today that I've been going about things entirely backward. I've spent the last little while trying to use software to generate an ER diagram for me from my database only to find that the relationships weren't being created in the diagram. After a little googling I …  |
| | Hello! I've been stuck with this for a while now. First I want to say that this is a school project and not something illegal bet site. The first MySQL table have results from games and the other table contains users bets on different games.. My problem is that I … |
| | Hello i have a problem with protect from sql injection : the problem is: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in My Old Code (working): [CODE] <?php $currentid= $_GET['id']; $q="select * from tbl_car where id=$currentid"; $result= mysql_query($q); while ($row = mysql_fetch_assoc($result)) {} ?> [/CODE] my … |
| | can somebody help me with this select? I'd like to know if I can make it faster? SELECT distinct wb.id FROM websites AS wb LEFT JOIN websites_meta_keys AS kw ON wb.id = kw.site_id INNER JOIN websites_meta AS wm ON wm.site_id = wb.id WHERE kw.keyword like '%test%' OR wm.title like '%test%' |
| | I am thinking to use MySQL with my new Java project, it contains some code that creates database locally and store data in it. It is all fine on my machine as I have all requisites installed like MySQL server but what will happen when I give this developed software … |
| | I am new to MySQL and thinking to use MySQL for my new Java Project which creates a database on the local client machine and uses it to perform all data operations. But before proceeding with MySQL I'm in a bit of doubt that I have MySQL server installed so … |
| | I have an error on opening my site, where is problem in my site [url]www.iphonehdwallpapers.org[/url] Error establishing a database connection |
| | Hi there, I am thinking about the best way, how to update my records in database (MySQL) from XML feed. I have database and this database contains the daily offers from several sales portals. So now - about midnight I am deleting all records from my table and with using … |
| | I am having a lot of problems with the following structure. Please could anybody help me with this. [CODE] SELECT MAX(intermediate.test) FROM ( SELECT SUM(table.field) FROM tabledfsd INNER JOIN .... + SELECT SUM(table.field) FROM tabledfsd INNER JOIN .... ) intermediate //or simplier example SELECT MAX(intermediate.test) FROM ( SELECT SUM(1+4) + … |
| | PHP and MySQL problems with ' and " have been discussed ad nausea on the web. I still don't get it. For example my db has an Author's name field with someone called O'Brien. If I create the DB with phpMyAdmin by reading in a CSV file, that field will … |
 | hi friends, This is Anand, am beginner to jsp, now am trying to connect jsp with mysql. Is this possible to code connection code separately and include each and every page. am trying the following code.I code these lines in separated.and I want to use it other pages.at the same … |
| | Hi, please help me with my code. Javascript function if (document.myform.Available.checked == false) { document.myform.Save.disabled = true; <?php $query = mysql_query("UPDATE rewarditems SET Available = 'Yes' WHERE RewardItemID = '{$_GET['item']}'",$link1) or die(mysql_error()); ?> } else if (document.myform.Available.checked == true) { document.myform.Save.disabled = false; <?php $query = mysql_query("UPDATE rewarditems SET Available …  |
| | Hi all, I am working on a project that requires themes much like the popular Content Management System, Drupal. I notice in their "info" files they use with their system to display information about the theme like its title, description, a snapshot of it, etc, my question is, would it … |
| | Hi guys! This is a continuation post of my last thread regarding login with session..Now the main task is, the login form is now driven with Fancybox.. What i need to know is how to let the fancy box check/compare the value on mysql table if the username & password … |
| | Hi there, I'm having a problem getting values inserting properly. What I'm doing is inserting values into a table with an auto incremented key, I then use select to return this key and then I want to insert that into a few more relation tables. But its inserting 0 instead … |
 | Hey Guys, I need some assistance if possible. I am using MySQL & PHP, I have an "events" table with a row field called "Users_Attending" and can't seem to figure out the best way to add multiple users to an event rows "Users_Attending" field. I want to store user emails … |
| | I am wondering if it is possible to use result of main select inside subquery. I am giving the below example. It is not very clear query, but the only thing you need to know and I am asking about is how to use table1.id inside subquery. I am getting … |
 | hey guys, I need your help for mysql query.let me tell you one thing, it's a dynamic query whatever the user selects in another page, those value will be set in mysql query. The problem is that it's not giveing me any data from that query. So Please give me … |
| | Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/botomul/public_html/whatsnew.php on line 130 [B]Can Anyone tell me, How could i solve this issue, Please I need help immidiately.[/B] [CODE]<?php error_reporting (E_ALL ^ E_NOTICE); ?> <?php $item=$_GET['id']; include ("header.php"); $mark = mysql_query("select * from product order by product_id … |
| | Hello can you help me please, Hi,.I Downloaded the Mysql community server and i installed it to my windows xp.The problem is i don't know how to set up the database.I want to use this in my program because i have never been using Mysql as my database i always … |
| | hi guys, i am working on a project and i am slightly unsure how to structure this in the database. basically it is a job card sheet that could have multiple part numbers selected and suppliers along with quantity. so basically i thought how can i store this in the … |
| | i was using mysql to connect to database in java. but it is throwing an error that is" access denied for use' '@'localhost' to database 'onlinetest' while installing mysql I DIDNT PROVIDED ANY USERNAME AND PASSWORD, IS THERE ANY PROBLEM WITH USER AND PASS AND WHAT TO WRITE IN USER … |
| | Hey guys, I just need a bit of help figuring out what the best way to go about the following using PHP/MySQL: It's basically a registration component So I have a button, let's call it "add_to_list" and I need this button to control a couple of things. When a user … |
| | I've setup the ability for members to select their favorite games. I probably could have built this better from a database design point of view so I'm open to suggestions there. Aside from that I'm trying to build a query that provides me with counts of the games so I … |
| | Hi guys, please help me. $GetList = mysql_query("SELECT ItemID, Available FROM rewarditems",$link1); while($row = mysql_fetch_array($GetList)) { $ItemID = $row['ItemID']; $Available = $row['Available']; echo("<form name='myform' method='post'>"); if ($Available == 'No') { echo("<td width='100' valign='top'><p class='ItemList'><input type='checkbox' name='$ItemID' value='process.php?action=Item Availability&item=&$ItemID&available=Yes' checked></p></td>"); } if ($Available == 'Yes') { echo("<td width='100' valign='top'><p class='ItemList'><input type='checkbox' … |
| | Hi. I guess this is a very simple question, but really cant fint the answer that suits my needs! What I have is 2 tables in a MySQL database: Families - FamilyId - City - Phone Members - FamilyId - Birtdate The family id is of course the primary key, … |
| | Can you help me with the following Mysql question? I get a table, say, three variables: ID, Date and Value, for example, ID Date Value 1 2001 2 2 2005 3 3 1986 7 4 1985 1 How can I add a variable, sum, to each line, with the condition … |
The End.