10,946 Topics
 | |
| | 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) | … |
| | hey guys - I'm sort of new to php5 and mysql5 but I'm pretty decent in php4 and mysql4 and thus far I've not seen that many differences. I am, however, new to SSL technology. I am building a site for a friend and am working on the login processing … |
| | I am new to using php and mysql and am really enjoying the experience so far. I want to use an if statement where if the user fills in a field called gamertag and if it is less than 6 char, then it will display "No Gamertag Available" otherwise it …  |
| | Hey guys, I have the following table: persons - name - street - number - regioncode - state - city I want to count the amount of people per region per street. I can do it with the following query: [CODE=mysql] SELECT state, city, regioncode, street, COUNT(*) AS personsStreetRegion FROM … |
| | General Question, no code: I have the daunting task of automating the import of mysql, ms sql and ms access into a central location. I've nailed the microsoft crap using ms sql DTS but even with mysql odbc drivers, cant seem to nail that one. The optional is that I …  |
| | i need some help fixing this .. i've made the td id the counter, which works. In mysql i have a column named position. For this particular row in mysql the position is 1. how do i input this result into the td id='1'? i tried below but it for … |
| | Hello, I have been trying to setup mysql API with C. I followed tutorials but I don't think I am installing the API correctly. Could someone tell me the package to download, and what to do with it. Thank you very much. |
| | Hi everyone, I'm currently working on a assignment and have to write a short (max 3 lines) definition on some different kinds of queries. I've written a definition to all of them but I'm having a really hard time about one particular query: Scan Query. I've tried to look in … |
| | Hey i'm writing my own first full website with PHP and MySQL and i've come to a problem. I know i need to optimalize it with some fewer echo's and more elses, but this is what i have now and apart from the problem, it works. On the site at … |
| | Hi I have a table which have 4 fields. How i can give rights via DB for update, Select, Delete and insert. For example User A only Update Field 1 User B only Update field 2 and select all fields. User C can delete field 3 records User D can … |
| | I'm writing a simple forum system to go along with one of my projects - nothing fancy, just categories, forums, threads, and posts. Some threads, however, are marked as 'stick', which means that they're stickies. No matter how many threads there are or where they're posted on, they always must … |
| | Hi to all, i am trying to set the logon data for crystal reports that i have created. in crystal report builder i manage to connect to mysql by the jdbc driver downloaded from the official site of mysql. [link=http://www.eakes.org/80/connecting-to-mysql-with-crystal-reports-xi/][/link] but i want to change the ip of the mysql … |
| | I have one join query with 3 tables, which takes lot's of time to execute. I need to reduce execution time i.e., optimize it [code] QUERY: SELECT SQL_CALC_FOUND_ROWS p.*, FLOOR(p.prodratingtotal/p.prodnumratings) AS prodavgrating, 0 AS prodgroupdiscount, pi.* , (IF(p.prodname='gold', 10000, 0) + IF(p.prodcode='gold', 10000, 0) + ((MATCH (ps.prodname) AGAINST ('gold')) * …  |
| | Hi I have a table with info that I want to read and display. I can read it and display but I cant seem to format it can anyone tell me whats wrong. [code] <html> <head> <title>comment</title> </head> <body> <form action="postcomment.php" method="post"> name: <input type="text" name="name" ><br> comment: <textarea name= … |
| | Hi All, I am developing a mysql monitering tool , So I don't want to give password inside the script, the script should able to access the database from OS user authnetication. Can you please help me here , how to access mysql database without prompting / or giving password … |
| | how to get popup window if new row inserted into mysql database for a particular table... That to be display inserted values in popup window... Advance thanx... |
The End.