10,942 Topics
 | |
| | Hello! I have a query with multiple table joints and where clauses. Tables are huge and query runs for a very long time. I need to run another query, which is exactly the same apart for one Where clause (first time price = "P", second time price = "S"). I …  |
| | Hi, I am using a JSP from to collect data from user and then inserting those values into a table in MySQL.But it is returning 'null' always.I am able to query the DB and view the entire table and everything else is fine. But the INSERT is not working somehow!!! … |
| | I really don't have the patience for this but I'm trying to learn php/mysql and really could use some tutors. The online tutorials are a fair introduction. But I've got a big project I need to make progress on quickly. If anyone here would be willing to give me some … |
 | Example: Navigate: PHP Code Library > PHP > Sub1 > Title V Any ideas, tutorials no how to do that using php & mysql ? each category should be able to have items and more categories under it. It should use a single table to store all the category titles. … |
| | Hi Everybody, i found out that to create a trigger i have to remove the BEGIN and END and it works, but as i put an IF STATEMENT inside like this one: CREATE TRIGGER status_history_upd AFTER UPDATE ON projects FOR EACH ROW IF NEW.project_status != OLD.project_status THEN INSERT INTO project_status_history … |
| | Hi, Im only used to basic sql queries. wonder if anyone can help with the below - or at least get me pointing in the direction of the correct resource to solve. I have a table, with fields a,b,c,d,e,f I need to run a query that shows from the above …  |
| | [B]Warning[/B]: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [B]/home/content/r/a/e/raeyshe/html/fanlisting/admin.php[/B] on line [B]36[/B] [code]<? // select all unapproved members $result = mysql_query ("SELECT * FROM $table WHERE apr!='y'"); [COLOR=darkred][B]if ($row = mysql_fetch_array($result)) { [/B][/COLOR] do { // display all unapproved members ?>[/code] Line 36 is in bold, … |
| | I've two tables where their composite keys are foreign keys that references each other. table1 (projId, userId, name, add) table2 (projId, userId, status, responseDate, reason) I need to retrieve table1(name,add) and table2( status, responseDate, reason) with projId only.. my query is [CODE]Select ap.name, ap.add, p.status, p.responseDate, p.reason from table1 ap, … |
 | hi... i have setup the mysql replication but i dont know for some reason its not replicating the data.. i may be missing some configuration.. please help me... to do the same.. Thanks in advance.. Pooran Jaiswal my.cnf entries on slave server [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old … |
 | My hosting server is located in Texas and when I use the localtime() function, I get Texas local time rather than Massachusetts local time (where I currently reside). I want to standardize all my time information so that when I store it into the MySQL database, I store GMT rather … |
| | [COLOR="Green"]Hello ppl! Hoping all of you is great! Ok, this is this first time to deal with VS2005 C++, and I need to help me that How could connect C++ with MySQL ?? please it is really important to me! any example will be helpful. dankie in Advance.[/COLOR] |
| | hi, i want to kill all the sleep process in mysql , since it is unnecesserly taking the server memory and process.. Regards Pooran Jaiswal  |
| | I need a simple script to do the following... a form that a zipcode is entered into and when subbmitted returns the results matching the field zipid. Here is what I have but I can not get it to work... FORM <form method="post" action="http://alwaysaegis.com/cms2/content/results.php" target="_blank"> <div align="center"> <table border="0" cellpadding="0" … |
 | Hello... I'm a nOob. Sorry if this is in the wrong forum or if it's been asked... I did search but couldn't find anything. I have a job between hands I don't know if I can handle to be honest. I have to redesign this website: [url]www.tiendaxtienda.com[/url] (in spanish). As …  |
| | HI.. I want to create an webpage such that when user will enter their username and password,the data will be stored in a database(I am using MySQL).I have the code.But when i am trying to run the servlet,its showing following error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver I have set the classpath of the … |
| | i have the following code for loading the csv file in to database dynamically. that is i want to give the file path dynamically . Dim conn As New MySqlConnection Dim myCommand As New MySqlCommand Dim myAdapter As New MySqlDataAdapter Dim myData As New DataTable conn = New MySqlConnection() conn.ConnectionString … |
| | hi i want to know whether my coding is correct because data is not getting inserted in my sql table,but it is displaying the "data inserted" message<html> <head></head> <body> <?php $uname1= $_POST['uname1']; $cname=$_POST['cname']; $caddr=$_POST['caddr']; $mid=$_POST['mid']; $skills=$_POST['skills']; $degree=$_POST['degree']; $indtype=$_POST['indtype']; $desc=$_POST['desc']; $req=$_POST['req']; $yoe=$_POST['yoe']; $sal2=$_POST['sal2']; $search=$_POST['search']; $hostname = "localhost"; $username = "uname"; $password …  |
| | Hi, The system under my program is using MySql version 4.0.18. I want to have a documentation for using [COLOR="Red"]MySql Transactions API[/COLOR] from my C program. Could you give some link? thank you.  |
| | This is an annoying error...tried re-writing the code a few times...deleting and recreating the table...etc...still the same result: " ... You have an error in your SQL syntax; check the manual that corresponds to your MYSQL version for the right syntax to use near 'desc) VALUES ( '', '1', '1', … |
| | Hi All, Newbie poster here. I have an, I guess, architectural question. I am still very much a beginner in mysql so bear with me. I have an e commerce site in which the prices of my products fluctuate very often. By default, my customers see the regular prices or … |
 | Is it possible to select day from the DATE field in a db so that it includes a zero in front of it if the day is less than 10? If so could you post the code please. Struggling and stressed...with qwerty imprinted on my forehead |
| | Hi all, I need to use MySql in a commercial website. What License should I buy MySql in? What if I reveal the sourcecode? Do guide me. thanks kararu. |
| | Hi, I have the following query i'm trying to execute: [CODE="mysql"] SELECT CONCAT_WS(' ', g.genus_name, s.species_name, i.rank, i.infraspecies_name, conf.auth1, conf.auth2 ) AS scientific_name, cn.common_name, GROUP_CONCAT(cn.common_name ORDER BY cn.common_name SEPARATOR ', ' ) AS common_names, ui.unvouch_image_src, ui.unvouch_image_alt, gh.growth_habit, gd.gen_distrib_name FROM plants AS p LEFT JOIN (genera AS g, species AS s) … |
| | Hi to all, I have a question and I hope to have an answer here. the Question is, is using MySQL DB in commercialweb site free of license or not? I know it's an open source, and to the best of my knowledge the using of open source applications like … |
| | hi, Can anyone please show me how to use siss, and how to load data using SQL Server and SSIS. thank you |
| | I'm trying to write a little wrapper for executing MySQL statements, and I've run into a wall trying to use [inlinecode]mysqli_bind_param[/inlinecode] without knowing the number of variables I'm binding. Here's what I've got: [code=php] /** * Note: * . execSQL is variadic, just like bind_param * . prepareTypeStr is another … |
| | Hi, I have this code. It works fine using PHP 4 and MySQL 5.0. but it doesn't work at all on my webhost (php4 mySQL 4) and I cannot for the life of me figure out why. Here's my code: /<? // Connect database. include("connectdb.php"); //if "Submit" button is clicked …  |
| | hi, I have only done basic sql queries and need help on this major one trying to combine many queries into one. What I need is to make the following queries into one: [code]SELECT Username, LastLogin, DateCreated, Views, MainPic, Logged FROM Users WHERE UserID=? SELECT COUNT(AlbumID) FROM ProfileAlbums WHERE UserID=? … |
| | hi all, right now i'm trying to migrate from db2 running under linux to mysql v5.1. i manage to export out the db2 structure & data into a del (ascii) file. but when i try to load the data from the del file to mysql table, it generate an error. … |
| | :?: Greetings, I am brand new to php and mysql so get out the asprin. smile I am making a php file to pull information from dat files to update my database. When I run http://www.sandpointrealty.com/read2.php I get this error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result … |
The End.