10,940 Topics
 | |
| | 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 … |
| | Hi this might sound like a simple question to most but it is something that i have been trying for quiet a while. I have a table in mysql, which contains a name of a football match, date, time , and one of the variables is a link address to … |
 | Hi all, I am new here, (as you might have guessed :) After I get the PHP/apache thingy working Or kill myself whichever comes first I will be needed to set up a db back end I would like to pose a question to you learned folks. I notice many …  |
The End.