[mysql] Forum Topics

i get this error:[quote]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index, user_id, username, message) VALUES(' ', '4', 'zack', 'jh')' at line 1[/quote] [code]<?php session_start(); $_SESSION['user_id'] = 4; $user_id = $_SESSION['user_id']; $_SESSION['username'] = …

I wonder if someone can point me in the right direction for securing my site more effectively. Having experienced problems with Google warning pages being placed on my site relating to potential malware, I've been looking into "beefing up" security, but am find the tutorials relating to safeguarding against sql …

Hi all, I'm am still learning mysql so please excuse anything I may not understand. I need to update 12k records in a mysql table (about 5 fields per record) twice a day, and it needs to be done automatically (probably with curl). My data source is a comma delimited …

I have a query that gets 5 random values out of a table according to a query. i.e. [code=sql]SELECT * FROM links WHERE url contra = FALSE ORDER BY rand() LIMIT 0,5[/code] This is fairly simplified but you get the idea. One of the fields in the table is ip, …

Hello all, I'd like to know if there is a way to insert into a MYSQL table data in an ordered way? Right now as a workaround I've literally made a table of questions with questionID as primary key, nextQuestion and prevQuestion pointing to other questionIDs. Basically I've made a …

hi, i had a mysql table and my friend make the database in excel file. Now I need to import my excel file into mysql table. Anyone help me how to do this ... Thanks in Advance

Hello everyone, At first, I would like to wish an happy new year for everyone. Now, my problem! I'm starting a new web app (which is the first one I will completely write) and after modeling the database, I encoutered a problem for adding datas in my category's table: [code]-- …

Hi All, I have one query related to mysql licensing. I am developing a desktop application for commercial purpose and using mysql community server (5.0) as backend database server. We dont install mysql server and driver from our application installer. If user wants to install our application on his machine …

Hi all, I seem to be having a problem. I get the above error when trying my login script. [CODE]<?php $dbhost = "localhost"; $dbname = "userlogin"; $dbuser = "adminuser"; $dbpass = "xxxxxxx"; $dbtable = "users"; mysql_connect ( $dbhost, $dbuser, $dbpass, $dbtable)or die("Could not connect: ".mysql_error()); mysql_select_db($dbname) or die(mysql_error()); session_start(); $username …

How would I import a database which is more than 50MB. PhpMyAdmin only allows below 50MB. Ive tried compressing the data but it doesnt work because it takes the decompressed size. So how would I do this?

While i was importing .sql file in my database i got this error #1064. [code] #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `att_poll_log` ( `id` …

[url]www.bluewolf.com/MySQLCluster101[/url] Free, Live Webcast - January 22 2PM EST

Hi Group, I have a small Query regarding calling a procedure from a trigger please go through the following and please let me knwo if any thing wrong happened. [code=sql]DELIMITER $$ DROP PROCEDURE IF EXISTS `test`.`sample` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `sample`() BEGIN insert into test.out(num,message) select num,name from test.in,hotel where …

I am building a site search that involves a union of two tables in two databases and needs to have relevancy factored in. I do not want to use a full-text or boolean search. I can search one database and one table using relevance fine. I can union the two …

I took a backup of a database a while ago and I'm having trouble with running it on a new (Windows 2003) server through phpmyadmin 3. Whenever I execute it the resulting tables, fields and data are all converted to lowercase! If I use phpmyadmin to create them it works …

What I'm trying to do is produce a query that will use custom fields. I have the following tables: [b]entries[/b] [code] id title slug user_id section_id [/code] [b]entries_values[/b] [code] id entry_id sections_fields_id value [/code] [b]sections_fields[/b] [code] id name value section_id [/code] So what I want to do is run a …

hi i need to undresdatn the relation which mention in that table which i attached plzzz.... any one. thanks inadvance...

Hey how will I write a text file to setup a database with the information below Database set-up: Members Table: id - int primary key auto_increment. username - varchar 15. password - varchar 32. will be a md5 and sha1 hash of the password then the username. e-mail - varchar …

here is my situation: i have a prepay online store and i advertised a contest to win a free code when buying at least 5 codes during 24.11-24.12 2008 period. now this is my table: [CODE]orders_id customers_id customers_name customers_company customers_street_address customers_suburb customers_city customers_postcode customers_state customers_country customers_telephone customers_email_address customers_address_format_id delivery_name delivery_company …

I am facing some kind of problem. The error I am getting it's look like "Errorno = 2003 Error Message = Can't connect to MySQL server on 'server IP address' (99)". This error is coming most of the time. 1) the server is also running when I got this error. …

I'm using a vBulletin based board. I've started with utf8 charset, and my db is messed up now, all the content is in gibberish, I'm using Hebrew in my forum and after a while I tried upgrading to the latest version, so I did, and the board is now presenting …

hi, i just have a general question that if I registered for a domain with space to put up my files. can i use that space to store my database? such as connecting php myadmin to the domain. can anyone explain a bit on how to do this?

Hello. I'm burning my head on a problem with a query. Querying a payments table, I need to find the actual membership category (let's say: IDCATEGORIA). If I run this: [code=sql] SELECT idpersona, idcategoria, datapagamento, datascadenza FROM personacategoria WHERE NOW( ) BETWEEN datapagamento AND datascadenza ORDER BY idpersona, datascadenza [/code] …

I have a table called "users", in the table it contain a column/ field name "reg_date" how would i run an query to say: For all the users, if their feild "reg_date" is blank put "20th December 2008"

I accidently inserted a lot of my data wrong in mysql. Its something like this 32-Bit versions • Windows Vista • Windows XP • Windows Me • Windows 2000 • Windows 98 • Windows NT 4.0 • Windows 95 • Windows NT 3.5 64-Bit Versions • Windows Vista x64 • …

Hi Im not sure if i need a join here, i cant seem to grasp the concept of joins really batteling with this I allocate points to id numbers in the points table and i have a list of all id numbers in the consultants table the id numbers only …

hi i have an error when i try tio insert special characters ' insert into lydia(id,resume)values('$ids','$i') idis int,resume is a varchar ERROR3:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Degree please do …

I'm using the Brinkster control panel Database Manager to investigate a database on a site I just took over. I don't know anything about the database. I tried a SHOW TABLES and got an error. I also tried SHOW ALL. Do you think I need a ; after the command …

Hello ALL, I have a table contains words extracted from a few documents. [Code] DocID Word Tag 1 Book noun 1 Pen noun 1 Pencil noun 2 There prep 2 Hand noun 2 Have verb 3 Oil noun 3 Thorough adv 3 Drive verb 4 Red adj 4 Blue adj …

Is it possible to update the AUTO_INCREMENT value who's attributes are primary key, not null, auto increment and also an INT type The thing is I need to synchronize the 'image_id' to access images sequentially and if one row is deleted the sequence is destroyed Help me! [code] <?php include('db_conexn.php'); …