11,093 Topics
 | |
| | Hi, Fairly new to MYSQL, still learning. I have create basic web databases before but the project i am working on just now is slightly more complex than before and need some advice. i have had some help qith queries which has been great however i need some advice from … |
| | Hi everyone. I'm currently working on a project whereby I'm creating a small client/server website. For the server side programming, I have no ideas to how to upload and download images. I'm am using Xampp and Mysql database. I really need your help. Please help. Thanks in anticipation. |
| | |
| | I am looking for a platform to build a manual and function reference for my open source software-in-development. Something that is easily organized. I spotted a very nice and simple solution here: [url]http://mpdf1.com/manual/index.php[/url] But contacting the author has not resulted in information what that software is and by the look …  |
 | What the hell is up with [URL="http://www.oracle.com"]Oracle[/URL] lately? First, they stopped giving away the Solaris operating system and now they have some big announcement planned for next week at the [URL="http://en.oreilly.com/mysql2010"]MySQL Conference[/URL]. Should we hide our wallets before we listen? To me, Oracle has morphed into [URL="http://www.microsoft.com"]Microsoft[/URL] II with all …  |
| | |
| | [code] <?php if (isset($_GET['id'])) { $id = abs((int)$_GET['id']); $sql = "SELECT *, ((`hit_head` + `hit_chest` + `hit_stomach` + `hit_leftarm` + `hit_rightarm` + `hit_leftleg` + `hit_rightleg`)/`shoot`) AS 'acc' FROM `zp_weapon_stat` WHERE`id_weapon` = $id"; $r = mysql_query($sql); $row = mysql_fetch_assoc($r); if ($row) { $template = 'weapon.xsl'; $weapon = $root->appendChild($data->createElement('weapon')); foreach ($row as … |
| | Hi everybody, I'm having trouble with my query on line 19. I'm supposed to search for a name and return the balance and credit limit. I'm not sure why I keep getting a parse error. Thanks in advance! [CODE=php] <?php $find=$_POST['find']; $name=trim($_POST['name']); if (!$name) { echo 'You have not entered …  |
| | Hi Im trying to pull out a list of meetings, and the associated number of comments attached to each meeting. Comments are assigned a category (ie meetings) and a linkid (the uniqe id of the meeting) - Im using this query, buts its cutting out all meetings that don't have …  |
| | I've got a situation with minibus repair database design, where it looks like in the Repair table I could do with a 3-composite primary key: jobID from the JobType table (types of maintenance with price and time), mechanicID (Mechanic table), minibusID(minibus table). This way, I've got type of job performed … |
| | Hi there Im getting this error message with a script im trying to use. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/rideron1/public_html/join_form.php on line 67 No database selected The script im using works on my local server but as soon as I upload it to … |
| | Hi there, I've been having some issues with MYSQL. I have three tables, Blog, which has the fields: [LIST] [*]Id [*]Headline [*]Author [*]Articlebody [/LIST] Tags, with the fields: [LIST] [*]tagId [*]tagName [/LIST] and Lastly, article_tags (which is the relation), with the fields: [LIST] [*]tagId [*]blogId [/LIST] My issue is, I'm … |
| | Ok, I'm new to php and MYSQL aswell. I have a couple programs actually that are getting this error and I don't see what could be causing this at all. Here's the situation. I have a job interview page. The user enters the information from the candidate and submits the … |
| | Hi, I have a query: [CODE=sql]SELECT h.id, h.creator uid, h.haiku, h.title, h.likes, h.approved, cat.name category, count(c.id) comms, h.anonymous, CASE h.anonymous WHEN 1 THEN 'Anonymous' ELSE u.username END username FROM haiku h left join categories cat on cat.id= h.category left join comments c on c.haiku=h.id left join users u on u.id=h.creator … |
| | i have one table, which has three fields and data. Name , Top , total cat 1 10 dog 2 7 cat 3 20 hourse 4 4 cat 5 10 Dog 6 9 i want to select record which has highest value of "total" for each Name so my result … |
| | The code below is what i am using to upload a photo to store it in a database, is it being stored correctly?? as it will not let me view them properly, any help is great!!! [code] $title = $_POST["title"]; $userfile = $_FILES['userfile']['tmp_name']; $userfile_name = $_FILES['userfile']['name']; $userfile_size = $_FILES['userfile']['size']; $userfile_type … |
| | I'm making some dynamic drop down boxes for a site that get their contents from a database, i belive i have the correct code to do this [CODE]<?php echo "Product Code"; $sql = "SELECT DISTINCT Product_Code FROM product_supplier"; $result = mysql_query($sql, $odbc) or die("could not run"); echo"<select name = Product_Code>"; … |
| | Hey lads, Firstly apologies for the long message. I just thought it might be easier to explain my issues. I'm doing a website for myself and have been getting some amazing info from this forum. I've moved onto the database part to it. Now, for my website, user can sign … |
| | Hi, I'm trying to code a league table system and I was wondering if there's an easy way of doing this: [CODE]$result=mysql_query("UPDATE Championship SET played="++1" WHERE team_name='$home_team'") or die(mysql_error());[/CODE] The problem lies in the played="++1" part, I can set it to be any integer, but that's not much use, I … |
| | Hello friends this is something weird... when i insert some italian characters in mysql. like [B]è ò à ù ì[/B] i got this in database [B]è ò à ù ì [/B] my table charset is latin1. thanks in advance. :)  |
| | Hiya All, Not sure if i should be putting thi up on the SQL section but i think the problem lies in the PHP part of my code. This is what i've got. I'm counting the number of times a category shows up in my database returning the name of … |
| | I have been writing a program that accesses data via a text file. I have recently been turned on to MySql which seems like it would be a more efficient way of organizing my data. If I am using Visual Studios to create both my database and my C++ program …  |
| | Hi, I'm fairly new to php and am having a lot of trouble with a simple little select problem. I have tried it about 20 different ways and it just keeps spitting out errors and not working My code is: [code] <?php session_start(); // built in php function to start … |
| | Having a little issue with a from and MYSQL. I created a Job Interview form that takes certain criteria from the interviewer and places that information into a database so you can extract the information later. What my problem is I'm getting no error messages or successful output. It's not … |
| | Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 … |
| | Hi people, My issue is more of a MySQL issue than php. I am trying to store a 3digit integer value with a leading Zeros in front such as 001 i have a company table , which auto increments the id as 001, 002, 003...and so on... In the company … |
| | Hi peeps... A good day to all of you yea~ as i know, i can retrieve only the first row by using the keyword [B]limit 1[/B]: [CODE]select * from tblTesting limit 1[/CODE] for selecting the first two rows are: [CODE]select * from tblTesting [B]limit 2[/B][/CODE] is there any solution to … |
| | Hi guys, I'm a bit of a newbie to PHP/MySQL, so please excuse me if I seem ignorant of something seemingly obvious. I'm writing a booking system for a holiday home rental company. I'm building it up slowly. What I have so far is trying to calculate the number of … |
| | Hello, I have been searching for a solution on how to solve this problem for almost a month now. I'm at a point where I feel like I've traveled around the world 7 times and still haven't found the answer. I hate introductions so I'm just going to go ahead … |
| | [URL="http://www.mysql.com"]MySQL[/URL] users listened intently Tuesday, April 13 at O'Reilly's MySQL [URL="http://en.oreilly.com/mysql2010"]Conference[/URL] to Edward Screven, [URL="http://www.oracle.com"]Oracle[/URL]'s chief corporate architect, while he announced Oracle's grand plan for MySQL. What they heard was that Oracle is interested in MySQL, will invest in it and nothing should change for the community version of MySQL. … |
 | hello everybody i have a big problem with the connection of mysql connect i want to connect to an other data base with out binding Ip adresse in the host server . i have an application and i want to manage 2 web sites with this appliction because the tow … |
| | Hi Guys , Have you any idea what does mysql.sock used for and where we can find in windows system. rgds |
| | Hi, I am a php newbie. I am doing a sports site, and trying to get the team name to display in an admin area. I have tried the code below and many variations of it, however it continues to error the message : Notice: Undefined index: team in ... … |
| | hello and thank you in advance to anyone who can help me with this problem. I've scoured the internetz for a while trying to find a solution to what must be a common question, but I can't find anything that relates to what I am trying to do. I have … |
| | Hi, i've been working on this simple homework assignment and the only thing stopping me from finishing it is passing a c++ variable to a mysql query using mysql_query. I've searched around for about an hour and every potential solution I have found hasn't worked, so I figured maybe if … |
| | While I've been working with MySQL for years, this is the first time I've run across this very newbie-esq issue. Due to a client demand, I must host their website files (PHP) on a IIS server that is not running MySQL (instead, they are running MSSQL). However, I have developed … |
| | I have the following php code: [CODE]$query = "INSERT INTO flashcards VALUES (null, '".$_POST['front0']."', '".$_POST['back0']."', ".$link.", ".$details.", NOW()); INSERT INTO bundleflashcardlink VALUES (null, ".$flashcardbundleid.", LAST_INSERT_ID());"; $result = mysql_query($query);[/CODE] which gives me the following error: [CODE]DB Connection error: You have an error in your SQL syntax; check the manual that corresponds … |
| | Hi guys, I hope you can help me with a bug. I have an update form to update data in a mysql database. Whenever a user wants to update the picture they uploaded it through the html form. For some reason my mysql querie on line 67 is not updating … |
| | Hey I am using a trigger, if the trigger returns emtpy I want it to keep the data it already has. This is my trigger: [code]BEFORE INSERT SET NEW.calling_num = (SELECT users_name FROM cdr_phone_system_data WHERE extension_number = NEW.calling_num);[/code] How can I check if the return is blank? The idea is … |
| | I'm trying to create a form that updates stock in mysql database. I have created the forms to upload new stcok and they work fine. However, i'm including a link that will take the user to an update php that will then update the required fields, but i can't seem … |
| | Hi Guys! I am a Python noob. I wanted to merge data and eliminate duplicates. I have the solution. Now I am stuck at dumping the dict contents to MySQL. Any help is really appreciated. Data : [QUOTE]a b c d e f key dupe -------------------- 1 d c f … |
| | Hi, I’m going to calculate a ratio between two entities but are having some trouble with the query. The principal is the same to, say a forum, where you say: A user gets points for every new thread. Then, calculate the ratio of points for the number of threads. Example: … |
| | I have a table with about 150,000 rows. The table never changes and the rows are physically ordered by one of the columns. That column is the only column I ever need to query against. The values (TEXT) in that column are not distinct. Creating an index on this column … |
| | mytable1 contains the customers information (phone, address, first name, customer code, last name...) mytable2 contain the flights (charter, date, destination,customer code...) They are joined by the customer code. My goal is to print names of customers that have more than the average number of charters [CODE]SELECT cu.cus_fname, cu.cus_lname, COUNT(ch.char_trip) ch …  |
| | I am trying to code an update sql command which can be seen in the code below, however, i am getting the following error: - Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/qchqsdju/public_html/project/lines/update_line.php on line 40. The code is: - [CODE] <? // Connect database. … |
| | Hi, I have a text data type field in MySQL table that I need to read out to a page. When the value is entered into this text field the value will have returns as follows: ------------------ TEST TEST aaaaaaaa asdasdasdfas 3rd lineasadas ---------------- When I read this value out … |
| | hi, i have been trying to write a query which will return all clients and the related tables so that i can then allow the users to filter in a php website. at moment i tried this but returned no results even though there are records: [CODE]SELECT * FROM clients …  |
 | Hi guys, Here is my problem.. I have two computers with Win XP pro. The one has static IP and i want it to be used as a web server. I want to create a database such as Mysql and put it on the web server and using the application … |
| | Hey guys. First of all, its been 2 days, and already 2:30am in the morning. I've eaten a steel fork, jumped over the moon, broke an arm, and cant get it to work. Will somebody please assist me in this; The end result sound simple, and maybe it is, but … |
| | I running MySQL 5.1.30 on Solaris 10. As I have a table which I partition into 12 according to each month. The table structure as follow [CODE] mysql> desc my_events; +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | event_id | bigint(20) | … |
The End.