11,093 Topics
 | |
| | [code=text]mysql_query() [[url]http://www.mysql.com/doc]:[/url] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'into kiwanis_info ( 'identity', 'firstnam', 'lastnam', 'phonenum', 'emailaddr', ' at line 1[/code] Above is waht I get when inserting into a file from … |
| | Hi there. I'm having a problem getting values from a drop down to insert into a table. What I want to do is get the key for the value and then insert that. For example: I have a table called format which holds an auto incremented ID key and a … |
| | Can you show me the way about storing the special characters into mysql database using php. Actually,I'm working on such a website where user can upload text and programming codes into mysql. Thank you in advance.  |
| | Hi All , I tried to update the field RANGE_ALLOC_BLOCK_SIZE in table GLOBAL_VARIABLES of information_schema database.But i face the error Access denied for the root user.Can anyone help me to update the field. Thanks, Arun T |
 | Hey Guys, I have a quick question for you. I display a new event every day that allows users to attend that event. The event id and user id are added to an event participants table. I have 3 tables in my DB: "userinfo" which holds stuff like id, Name, … |
| | Hi everyone, Can anyone tell my why this does not work? I created a stored procedure that uses a variable / input value as table name, but it does not do what it's supposed to do. Here is the code: [CODE] delimiter // DROP PROCEDURE IF EXISTS userpages.respondtoconnectionrequest// CREATE DEFINER … |
| | Hi guys i have an assignment and it's asking me to let the user enter data into one of three text boxes to search for something in a database it also has to show the results in a table and be hyperlinked to the next page being bookingdetail.php and the … |
| | I'm having trouble getting my queries to insert properly. this is my table structure books(ISBN(pk), authorID(fk), formatID(fk), publisherID(fk), titleID(fk), yearPublished) the ISBN and year are past directly via a form but the foreign keys are all auto incremented in their own tables. I was trying this: [code] mysql_query("insert into authors(authorName, … |
| | Hello people, When I call my function ReadMyTable::readAdmin(); i get an error where it says I have not the right to use self::admin within that function, please, help me to fix this problem ! here is my code : [CODE]<?php class ReadMyTable{ public static $admin="admin"; public static $presentation="presentation"; public static … |
| | 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 … |
 | Hello DaniWeb, this is my first view at this forum as a member! I have an issue with my code. The application interacts with a MySQL database on a remote server, I have access to this server. When my app is running the insert into code I m getting this … |
| | |
| | I am following a course on lynda.com First I had XAMPP, but I had some problems with it, and when the guy who was explaining everything used WAMP, I thought it was easier to just uninstall XAMPP and install WAMP. So i did that, but the XAMPP installer said it …  |
| | Hey all, Can any when tell me how to loop and put if-conditions in sql query? as I am new in SQL i am a bit confused about this please help me i have very short time. Thanks in Advance |
 | Hi Forum, I'm currently working on a project where I create a form in Javascript/HTMl(easy). By form, i mean an actual form where it shall contain combo boxes, drop-down lists, buttons etc. Something like a questionnaire. That's all good and simple enough. However, how can I use this questionnaire/form to …  |
| | I had a file info.php with class named xyz and functions within it, I am trying to fetch data from data base from another file show.php..but it is not working and shows "Notice: Undefined variable $info"....is there any help wht am i doing wrong... my code is.. in dblink() // …  |
| | i have a little syntax problem in php mysql, and i cant figure it out, hoping that u guys can help me out....mysql error and code are below Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right …  |
| | Hi i have problem in my login code. Firts someone fill in login informations this is checking code [CODE] // mysql connection $username=$_POST['username']; $password=md5($_POST['password']); $username = stripslashes($username); $password = stripslashes($password); $username = mysql_real_escape_string($username); $password = mysql_real_escape_string($password); $sql="SELECT * FROM users WHERE username = '$username' and password = '$password'"; $result=mysql_query($sql); $count=mysql_num_rows($result); … |
| | I have this page that you can do a search on the site. However, if I do a search that contains an apostrophe ('), it breaks and doesn't display anything although I have entries that have them. Does an easy fix exist for this problem? This is an example of … |
 | Hi All, I hope somebody can help. I would like to make 1 large query from a mysql database. Once called I want to get whatever i want from that stored array, which is where im having trouble. What i have so far is the following code, but each time … |
| | Hi, I have a MySQL DB and I am trying to set up a report page. To do so I need to be able to add the data in 6 or 7 fields into a single field for use in a summary report. How can I do that? SUM() seems … |
The End.