10,944 Topics

Member Avatar for
Member Avatar for das.rajib47

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. …

0
82
Member Avatar for thunderbbolt

I am trying to read my database from mysql. I have two fields author and books. I need the author field to be in the drop down list and then when I choose an author I need it to display below on the same page all of the books by …

Member Avatar for ambiliya
0
121
Member Avatar for rajasekhar1242

hi, i wrote the following program on python IDE. but i got "no module MySQLdb" as import error. can u give me any sugg import MySQLdb # Create a connection object and create a cursor Con = MySQLdb.Connect(host="127.0.0.1", port=3306, user="rajasekhar", passwd="venkata" db="tst") Cursor = Con.cursor() # Make SQL string and …

Member Avatar for nikhilvishnupv
0
452
Member Avatar for welbyobeng

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"

Member Avatar for =IceBurn=
0
92
Member Avatar for Yellow Slider

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 …

Member Avatar for mwasif
0
186
Member Avatar for Deathrains

Hello guys ! i find this place really helpfull for developers (ow really ? lmao) ok here i made an mysql query that looks like this ; [code=php]$result = mysql_query("SELECT id,title,description,data,author,mini_img,view FROM data WHERE data>'$data_begin' AND data<'$data_end'",$db); [/code] i checked for missplaing and nothing ... i have doubs about data(its …

Member Avatar for dasatti
0
103
Member Avatar for desiguru

How do i escape a string that includes a lot of ' and " Here is my sql inser query's some part [code] VALUES ('','$_POST[FileID]','$_POST[FileAddress]','$_POST[Name]','$_POST[Requirements]','$_POST[DateAdded]','$_POST[Size]','$_POST[Changes]')"; [/code]

Member Avatar for buddylee17
0
88
Member Avatar for k2k

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?

Member Avatar for peter_budo
0
134
Member Avatar for joliejoker

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] …

Member Avatar for hielo
0
81
Member Avatar for welbyobeng

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"

Member Avatar for manish.s
0
135
Member Avatar for Modo

hi guys how r u doing .. i am using a website to help me install the three components through the tutorial on the website everything seems to be working except the MySql part .. the tutorial says i should go to DOS and there i should run mysqld-nt --console …

Member Avatar for Modo
0
255
Member Avatar for desiguru

I have a table that is something like this: (table name: sites) ID----FileName-----FileAddress----About 1----website1-------google.com----Seach engine How can I make a code in such a way that it can be like: Display all of the FileName in an alphabetical order on file.php that links to their further information page. i.e FileName=[COLOR="red"]website1 …

Member Avatar for =IceBurn=
0
324
Member Avatar for desiguru

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 • …

Member Avatar for desiguru
0
82
Member Avatar for PomonaGrange

hey folks, I have a question. I have several mysql tables and I'd like to fetch data from a few of them to create a <select> <option> list. How could this be done. I can get the info from one table, but don't know how to get the data from …

Member Avatar for PomonaGrange
0
294
Member Avatar for fabzster

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 …

Member Avatar for varmadba
0
109
Member Avatar for queenc

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 …

Member Avatar for queenc
0
99
Member Avatar for muthupalanisamy
Member Avatar for squarkman

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 …

Member Avatar for sikka_varun
0
204
Member Avatar for DragonMistress

Ok, I'm having a hell of a time with this script(s)...probably just too tired to think straight but need to get it done ASAP...so perhaps someone can give me some assistance, or atleast point me in the right direction. 1. First page will be a multi-select checkbox with about 200 …

Member Avatar for sikka_varun
0
79
Member Avatar for cy163

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 …

Member Avatar for blocblue
0
105
Member Avatar for haii

I want to import some records in a mySQL database into an Access database.The mySQL database is ina linux server. Can I do this using VB or other languages ? How ?

0
55
Member Avatar for nagatron

Hello to all, I have a SQL Manager 2007. I don't know how connect MySQL from VB6. Can you help me PLS.... Can you give me a complete process of connecting a sql database? here is the download link of the sql manager i use. [url]http://www.download.com/EMS-SQL-Manager-2007-Lite-for-MySQL/3000-10254_4-10439256.html[/url] pls help me. . …

Member Avatar for debasisdas
0
61
Member Avatar for danishbacker

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'); …

Member Avatar for danishbacker
0
251
Member Avatar for bahr_alhalak
Member Avatar for bahr_alhalak
0
71
Member Avatar for aloks

Hi i have a website hsoted on a shared server with a service provider and i am getting the below error at times while i am adding text in the database thru the CMS module provided to me by the developer. The developer says its a server issue and and …

Member Avatar for blocblue
0
82
Member Avatar for cutieann12

hello everyone, i need to make a program that will show/load the images stored in mysql database, i've already created the database and my problem is i can't load it in my vb code.... here's my code below Dim conn As MySqlConnection 'connect to database conn = New MySqlConnection() conn.ConnectionString …

Member Avatar for tuse
0
104
Member Avatar for maxbox

i cant understand why this error commimng up [CODE]<?php $mysql_host="xxxx.xxxxxx.xxxx"; $mysql_user="anuncios"; $mysql_password="xxxxxxx"; $mysql_db = "suecia"; $conn = mysql_connect("$mysql_host","$mysql_user","$mysql_password") or die("Could not connect : " . mysql_error()); mysql_select_db("$mysql_db",$conn) or die("Select database failed"); $code = mysql_query("Select * from jos_call where code = '".@$_REQUEST['nombre']."'",@$conn); if (mysql_num_rows($conn)==0){ //error here// echo @$_REQUEST['nombre'].' - Codigo correcto'; …

Member Avatar for sikka_varun
0
87
Member Avatar for sleign

I have written a guestbook in php using a MySQL database to store the entries. I am now writing the backend for it so that the rows in the table can be modified via a form. The way the form works is this: A table is displayed on a page …

Member Avatar for sikka_varun
0
2K
Member Avatar for samtwilliams

HI All, I am currently following a tutorial on mysql and php and I am getting this error on displaying results ready for an update in a form. Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/site/update.php on line 11 [CODE]<? $id=$_GET['id']; $username="web183-sql"; $password="sqlpassword"; $database="web183-sql"; mysql_connect(localhost,$username,$password); …

Member Avatar for sikka_varun
0
184
Member Avatar for trtcom1

Hi, I need somebody to have a look at my code below and help to see what I have done wrong. I have 3 tables:[B]Student[/B] [I][COLOR="Red"](studentNum,firstName,lastName)[/COLOR][/I], [B]course[/B] ([COLOR="Red"][I]courseID,courseTotalCapacity[/I][/COLOR]), [B]course_allocation[/B] ([I][COLOR="Red"]studentNum,courseID[/COLOR][/I]). The AIM is to allocate students to 2 classes (courses 101 and 102) as long as there is available space …

Member Avatar for trtcom1
0
166

The End.