7,368 Topics
| |
Hi I am using the following query: [CODE]"SELECT * FROM members WHERE name LIKE '$searchKey%';"[/CODE] Where $searchKey is a variable that contains the string to be searched. The problem is that the code only searches until it has found a space and even if characters after space match the value, … | |
I am going to try to explain this the best I can I didn't develop the original version of this, or the part that rights it to the database. in our company, there is a program that takes PDF files and stores them in our mysql database as blobs. The … | |
Hi, I am looking to get some help as to how I can create a script that does an Instant live search which displays results as I type: For Instance: 1) I arrive at a page and it has all lists of members from a database already displayed. 2) Then … | |
the code: [CODE][/CODE]CREATE TABLE `mysql`.`emp` ( `EmpNo` INT NOT NULL, `EmpName` VARCHAR NOT NULL, `Job` VARCHAR NOT NULL, `Mgr` INT , `Hiredate` DATE NOT NULL, `Sal` INT NOT NULL, `Comm` INT , `DeptNo` INT NOT NULL ) ENGINE = MyISAM; [CODE][/CODE] the error: Error executing SQL commands to create table. … | |
Hello! I have a problem which I don't know if it is related to MySQL or Python. I am writing a database using wx.Python and MySQLdb. My problem is that when I want to send some string which contains accents to the MySQL database (for instance, 'Empordà ') it is inserted … | |
| After close to 40 years of programming one might think that databases would be a well known subject, but it's not for me. In fact I have never had a need for a database until now. I have installed Joomla because I want to develop my websites faster and more … |
Hi Experts, I have a website which is hosted in Bluehost. I would like to access my Mysql database from remote without using browser. Is there any tool to access my Mysql database something like Filezilla? Thanks in advance, Manim | |
Hi everyone, I'm a bit of a noob on the forum so please correct me if this is posted in the wrong area/or post is incorrect. I'm currently working on a new website ([URL="http://www.worldwidemixtapes.com"]http://www.worldwidemixtapes.com[/URL]) and currently stuck on the "sort by" section at the top of the page. What I'm … | |
Hi this is driving me a little crazy, have been looking everywhere for a solution for the last few days. I'm new to php and i'm trying to create a simple food shopping cart, i have a repeat region for food extras attached to the food item. [CODE=php]<table width="100%" border="0" … | |
Hi, I am using vb.net 2008 with MySQL for my project. I have a datagridview on my form which displays records from Mysql table on form load. i want to delete the selected row in datagrid from table on 'row header mouse click' event. The 2 different codes that i … | |
Hi, I have the following problem: I want to update the column "UPDATE_VALUE" of table A with values from the column "SOURCE_VALUE" from another table B. Both tables have a timestamp column, and the value that should be updated in table A should be the one of the row of … | |
I was told on another forum that my table was not set up properly. Specifically, two of my columns, "keywords" and "catagory" should be in child tables. I just dont see that, or I dont understand why I would need to do this for these columns. here is my info … | |
Can anyone provide me with a small code to [B]retrieve[/B] value either from [B]oracle 10G XE[/B] database or [B]MySql[/B] database using Java applets....... I searchd the whole internet but none worked fine for me.. Regardds Niks | |
i have a process that runs, but stops after about 3 minutes. It only processes some of the information (65 entries out of 500). i modified the php.ini, thinking this was the case. The process takes data from a mysql database and writes them to a file. register_globals = off … | |
I have a 2 tables that I want to select in a weird way but I'm not sure how to join them, should I use inner join or join left or group by etc... [CODE]//my desired out come employee_id | training_name ---------------------------- 1 | training a | training b | … | |
Is there any way to convert microsoft access database to mysql data. Please help me | |
Hi all I'm rather perplexed as to how I'm supposed to select rows from a database without having to use 9999 in my limit and I can't seem to find anything on how you specify fetching anything from a certain row onwards. Using this at the moment [CODE=mysql]LIMIT 10, 9999[/CODE] … | |
i have this code but it cant work in my hosting usualy the error is : The following errors were reported: 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 ''comments' ( 'id' int … | |
Hi There, For some reason the following is not working - Inside the text field it displays nothing: [CODE]<?php include 'dbc.php'; page_protect(); $rs_settings = mysql_query("select * from users where id='$_SESSION[id]'"); $row_settings = mysql_fetch_array($rs_settings); ?> <html> <head> </head> <body> <form action="index.php" method="post" name="regForm" id="regForm" > <input name="first_name" type="text" class="updateusersmall" id="first_name" value="<? … | |
Hello I m not so expert in web design. I need ur help. I have two table. One has a [B]primary key[/B] and other [B]foreign key[/B]. I want that foreign key must be from primary key. other than primary key it will not except any value. I made relationship from … | |
I am reading XML and PHP. I have to import a xml file in mysql database using PHP script. I tried using 'simplexml_load_string()' and 'simplexml_load_file()' functions. It worked. But how the xml parser is used to import XML files into Mysql Database. Please tell me about this, I tried the … | |
when I try to access my phpMyAdmin. It occurs this error message. [QUOTE]MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and … | |
hey everyone i have sugested to create a new club in my school called programmers , so they told me that i have to bring a list of the club aims and they xheck if the aims are good or bad then they accept the club or no , so … | |
Hi There, I do have an sql query to update and insert row into database which I use it within a form. Problem is ; This sql query works good in one form but in other one it does not at all(same query different form), looks like it is blocked … | |
Hi There I do have a form and a little sql query to update the row before do something else. Problem is in the code below works when I enter the date like that= 01-02-2001 but I need to do it dynamic I know getdate() but it does not work.. … | |
Hi: I have a process allowing the admin to view users information and download files that the user uploaded to MySQL. When the admin clicks on the file link in the admin page, I expect the file will display using the default program (i.e. pdf or txt), or download (i.e. … | |
i'm having trouble getting this to work. i want mysql to delete a row where the word 'example' is within a paragraph of a column. e.g. in the column reply.. it has a paragraph with the word 'example' in it. [code]$deletebadreply1= mysql_query("DELETE FROM `Reply` WHERE `reply` LIKE '%example%'") or die … | |
I am trying to make an Inventory GUI application using MySQL and NetBeans. So far, i was able to do add,delete,search, and save using Java Desktop Application. I now have to add a SEARCH button, a notification for the quantity if it is less than 10 and a USERNAME and … |
The End.