7,368 Topics
| |
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 … | |
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 … | |
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 … | |
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) | … | |
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 … | |
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 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 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 … | |
Hi, wonder if anyone can help. I want to insert a jpeg as blob data into a table column holding blob values. So far I just can't seem to come up with the right script to run in mysql workbench. The jpeg is stored on the same machine where mysql … | |
Hi, I can't solve this problem: I have a query which fetches the contents of the page meta tags from a database. It works fine when I have the query on page but when I turn it into a function (which is placed in my functions file) and call it … | |
Hi everyone, I’m having some difficulties with a query which purpose is to give users with more than one thread (called CS) in current year a 5% point “raise”. My relational schema looks like this: Thread = ([B]threadid[/B], threadname, threadLocation) threadoffering = (threadid, season, year, user) user = ([B]name[/B], points) … | |
Hi all, I've looked through this forum for some hours and am absolutely unable to fix my problem; no matter what I do. I'm trying to pass a PHP variable as part of a MYSQL query like so: [CODE] $id = $_GET["bodyid"]; $blog = getEntries("SELECT `Articlebody` FROM `Blog` WHERE id … | |
Hi guys, I'm trying to UPDATE the image that has been already in the database with another image using a form in PHP. I got the uploading working all fine already. Just the edit part. With this code, I get no error, but the MySQL table is not written with … | |
hi, I have written the perogram in perl and i want take previous date in "April 3 2010" in this formate . plz tell me how can i get this. [code=perl]#!use/bin/perl use Date::Format; my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(); my @weekday = qw(Sunday Monday Tuesday Wednesday Thursday Friday Saturday); my @month = … | |
hi, could anyone recommend a free mysql query builder? i have been working on a database and had some help with some small queries, however i need to create a large recordset through dreamweaver and wondered what tool i could use to generate my query visually? many thanks | |
Hi everybody. right now i'm doing a hotel reservation system using php and phpmyadmin. The process involved 1) user inputs check-in and check-out dates (to check what rooms are available during the dates input) 2) database is queried for all room categories AVAILABLE within the dates indicated step 1 and … | |
I have a field Status in my table message Its value when any message is entered in table is 1 but I want to alter it to 0 after 1 day of message posting how can I do so Plz help me | |
I have a small desktop application created, i wan to create a login function for this. i have a database using MySQL which stores user name and password. i wan to know how to compare the user name and password entered in the text field with the data in the … |
The End.