10,946 Topics
 | |
| | 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 … |
| | hello, [B]Please help me to create and using mysql procedures using php scripts.[/B] I searched in web for the solution but i didn't get a perfect support from anywhere . Thanks Anoop Ravi |
| | [CODE] $qrysc = "select * from `communities` where `name` like \"%$key%\" or `type` like \"%$key%\" or `about` like \"%$key%\" union all select * from `personal` where `fname` like \"%$key%\" or `lname` like \"%$key%\" or `country` like \"%$key%\" or `state` like \"%$key%\" or `city` like \"%$key%\""; $rqrysc=mysql_query($qrysc); $numqrysc=mysql_num_rows($rqrysc); [/CODE] Here communities … |
| | I have a table that contains approximately 22000 rows and I used a Boolean Full-Text Search in order to find what I`m interested in. My problem is that I created a 'dynamic search feeling' that consists of a DataGridView that it is refreshed after every TextChanged event. As you might …  |
| | Hi everyone, I had designed an application with Java as front end and mysql as back end. The client application uses both local database as well as Remote mysql server's database for login and other retrievals. I don't know how to generalize the database connectivity code?, I need to access … |
| | wat's guys? i have a java program and i want to connect it with mysql,how can i get my prob solved?or if i can view any source code that can help me. |
| | I need a script that allows users to privately message each other. How can i do this and where can i find an easy script for this? All it needs to be able to do is send messages to a username and then it would have an inbox for the … |
| | How do I advance the pointer to the next row within a while loop using mysql_fetch_array?[CODE]while ($row = mysql_fetch_array($result)) { $zip11 = $row['postnet ip']; include "postnet2.php"; //SOME MORE PROCESSING //I NEED TO ADVANCE THE POINTER HERE TO THE NEXT ROW //SOME MORE PROCESSING } [/CODE] |
| | Hi all, Sorry for the long post but i need to describe my problem properly to avoid confusion, i hope I have a table with users, and every user has a specific latitude and longitude coordinate. let say user Test_User is logged in and then he decides he wants to … |
| | Hey, We got an assignment to host a website, our members must be kept in a mySQL database. I honestly have no idea where to start. If you could just help me with the basics steps. Ill research the details myself. Here's what I've done so far. 1.I downloaded and … |
| | Hi, I am writing a MySQL script. I used a parameter file to set a user variable [CODE]set @log_file = "C:/logs/table_creation.txt";[/CODE] I used the variable in another file in the tee command as follows [CODE] set @log = concat("tee ", @log_file); prepare stmt from @log; execute stmt; [/CODE] But it … |
| | Hello All, Need help in importing CSV files into Mysql. I have tried all the methods which I can think of but im not able to import it. attach is the CSV file which Im trying to import. Below is my MYSQL table structure: mysql> show columns from test; +---------------------+----------+------+-----+---------+----------------+ … |
| | Hi people, I would love to list the table of my database: could you give me a hint to fix this problem using a PHP script ? Thank you very much begueradj |
The End.