10,932 Topics
![]() | |
Hey Guys, I have the following code, which averages the scores in a select statement and works no problem. [code] SELECT AVG(score) as 'avg' FROM (SELECT d_key_id, frequency, weighting,(frequency*weighting) as 'score' FROM users_to_keywords WHERE s_user_id=$user_id AND d_key_id = $score_key ORDER BY score DESC)a [/code] However, as there are some duplicated … | |
hi, I am trying to replace certain strings in my mysql database. I have addresses such as this: 60 W 23rd St, New York 10010 Btwn 5th & 6th Ave I would like to get rid off all the words starting from New York including the comma before the word … | |
Hi guys, I'm new to ASP.NET and MySQL. I've worked with Microsoft Access for a while (6 months or so) so I have an understanding on how databases work. However, now I am trying to create a website with ASP.NET 3.5 and MySQL. So far I've been able to get … | |
Does mysql_real_escape_string() escape HTML character entities? I want people on my comment board to be able to post quotes in their comments, but they get escaped as raw ascii, so I run them through htmlentities() first, but it doesn't help. I only get it to work when I remove mysql_real_escape_string(), … | |
Hey. I'm trying to make an activation script for a website, but for some reason my sql query is giving me errors. [CODE] $sql = 'UPDATE user SET active = 1 WHERE (password = "$_GET['hash']") AND (timestamp = ".base64_decode($_GET['stamp'].")'; $result = mysql_query ($sql) or die (mysql_error()); if( mysql_num_rows($result)==1 ) { … | |
Hello everyone. I know this is a C++ forum not MySQL forum but I need help with the C++ library for MySQL I am hoping that there will be people here who are knowledgeable about MySQL++. My problem is that I can't get the g++ compile to link to the … | |
Hi all, Im very New to My SQL and have done alot of googling and simple studies. I have two Questions: 1. Where can I start with Complete no knowledge of MySQL and databases in general (though i know a little) 2. I have tried to play with MySQL for … | |
[CODE] CREATE TABLE `categ` ( `id` int(10) unsigned NOT NULL auto_increment, `categ` varchar(32) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; INSERT INTO `categ` (`id`, `categ`) VALUES (1, 'General'), (2, 'Politica'), (3, 'Sport'), (4, 'International'), (5, 'Cultura'), (6, 'Hitech'), (7, 'Showbizz');[/CODE] [CODE] CREATE TABLE `ziare` … | |
I will explain... I downloaded `"mysql-5.0.45-win-src.tar.gz"` from Mysql download area.I tried to built Mysql.sln inside that,but i am getting errors(about 58) like Error 149 fatal error LNK1181: cannot open input file '..\zlib\release\zlib.lib' mysql_upgrade Error 319 error PRJ0019: A tool returned an error code from "Performing Custom Build Step" mysqld Error … | |
Hello all! I have a few questions about putting images into the database. I have chosen to put the images on my server and then the location will be put in the database, instead of doing the blog thing. However, I am having a hard time trying to figure out … | |
In MySQL 5.1, I am using a table that has 3 integer fields a,b and c. I need a create a trigger that will UPDATE field c with the results of field a-b. ANy help would be appreciated. | |
Hello all, I have a fairly good grasp on how to design a database (took a couple courses on it) but I'm not sure how to set up a database for use with a website. My plan is to develop the website with ASP.NET and MySQL. The website will have … | |
hey guys, i am using XAMPP and i want to take the back up of my database. Please give some suggestions | |
Has anyone been able to compile the lib files using Microsoft Visual C++ 2008 Express compiler? I downloaded and installed MySQL 5.0 Server yesterday, then downloaded MySQL++ source. Attempted to compile and got a bunch of link errors. I used dumpbin.exe to get a list of all the symbols in … | |
hey guys, i have made a database which has two fields namely username and password. Now when the user enters the password, i want that the password should be stored in encrypted form in the database so that the admin cannot see the password. Please give some suggestions. | |
Can someone please give me a brief overview of MySQL. It's advantages,disadvantages,security and other features. Thanks. | |
Hello all! I have been told for many reasons that when a user wants to end their account on a website, that you shouldn't delete the user out of the database for awhile. So if I need their information to be off the Internet, but still remain in the database, … | |
Hi i was making this code so I could connect to my server and run a database: [code=php]<?php mysql_connect("localhost","root", "samiscool"); mysql_select_db("test_db"); $sql = mysql_query("SELECT * FROM test_table"); while ($rows = mysql_fetch_assoc($sq1)) ( var_dump ($rows) ) ?>[/code] and this eror message came up "supplied argument is not a valid MySQL result … | |
i changed my password in mysql using the mysql server instance config wizard from the start menu. once i changed it, the access is denied to view all the database in phpMyAdmin.. #1045 - Access denied for user 'root'@'localhost' (using password: NO) - this error appeared in the screen. i … | |
hai i am sridar in my project there is a database it is created by msaccess and at present i am using mysql database by vb.net coding by clicking the button i want to download a datas from msaccess database to my sql please any one help me my mail … | |
Hello, I was wondering if anyone can help me sort this problem! I basically have a member profile feature on my site that has an update page! Members can update information such as their date of birth, location etc! I currently have a text box in which members have to … | |
hi please help me, i want to know how to enable smtp in php mysql, i have the code right so no worries there. please help | |
hello guys, just want to ask some newbie questions. i have a table named "students" in my database, the field names are "Lastname", "Firstname" and "Highschool". i want to sort my query by highschool field. i want to show that query results in table form. how can i sort by … | |
i'm using Macromedia Dreamweaver MX, and i fail to connect with mySQL database . any tips ?? pls help .. :confused: | |
I am trying to display image files stored in my mysql. It displays alright as a direct php echo, but when i put it in an <img.../> src attribute... I get a cross. The following is the code snippet; [CODE] ... $query = mysql_query("SELECT pid, imgdata FROM pix WHERE pid='2'"); … | |
How do I upload an Excel or CSV file into a MySQL database. I 'Googled' it and tried a couple things but nothing worked. Appreciate any help | |
Hello friends, i copied a table from other database and using in other database, when iam using the same table in other database the primary key in the table is just auto increamenting from the past table only. i want it to start from 0 Rakesh ![]() | |
A print-ready MySQL quick reference is available <URL SNIPPED>. Registration (free) is required for access to a more legible version. An extended version of this card that covers the MySQL SQL dialect in detail is in the works. Enjoy! | |
I will explain... I downloaded `mysql-5.0.45-win-src.tar.gz` from Mysql download area.I tried to built Mysql.sln inside that,but i am getting errors(about 58) like Error 149 fatal error LNK1181: cannot open input file '..\zlib\release\zlib.lib' mysql_upgrade Error 319 error PRJ0019: A tool returned an error code from "Performing Custom Build Step" mysqld Error … | |
Hi. I have been trying really hard to make a CRUD app with a wx.grid.PyGridTableBase-based wx.grid.Grid that takes its data from a resultproxy of the SQL Expression Language of SQLAlchemy from a MySQL database table, but the problem I have is that I have to convert the resultProxy to a … |
The End.