Questions tagged as 'mysql'

Tagged questions
1
answer

Problem with special char insertion via prompt

Dear, I have a table where I make some inserts with data containing special char. I currently use Toad for Mysql, and when I do the insertion by this editor, everything happens correctly, the special chars go up normally, but if I use the source...
asked by 30.10.2014 / 16:52
1
answer

Problems connecting mysql with asp.net c #

A small problem appeared, which in my old application worked normally. My DAL Class is not connecting in Mysql. Being all the connection parameters, I believe it is correct. MyDALthatmakestheconnection.usingSystem;usingSystem.Collections.G...
asked by 24.09.2014 / 06:17
2
answers

Query mysql does not work with variable - PHP

The query mysql works with normal variable, but not with the jquery post variable, for example: DOES NOT WORK $agenda=$_POST['agenda']; $query = mysql_query("SELECT * FROM 'compromiso' WHERE login LIKE 'alanps' AND agenda LIKE '$agenda'...
asked by 14.08.2014 / 03:44
2
answers

Codeigniter - Query in DB

Good evening! I need to return the value of a table in codeigniter but it is acknowledging the error below:    A PHP Error was encountered       Severity: Notice       Message: Undefined variable: name       Filename: paneladmin / categ...
asked by 05.08.2014 / 05:50
1
answer

How to use While in MYSQL

How to use WHILE in MySQL? I tried the following expression: set @C = 5 while @C > 1 select dia from base_prov_chamada end while; And I got the following answer:    You have an error in your SQL syntax; check the manual that   corr...
asked by 05.06.2014 / 18:32
1
answer

Problem with SQL query assembly

I have a table of "disciplines", a table of "students" and a table "students Disciplines", where these students can be enrolled in one or more subjects. These disciplines are shown as checkboxes on the search screen to serve as filters. Now I ne...
asked by 08.06.2014 / 20:53
1
answer

Edit url friendly user profile

Good I have the friendly url routes in the htacess file I am viewing the users by url so by the profile file link But I wanted to now edit the profile of this user that is another file edit_profile.php but I wanted the url to look lik...
asked by 14.02.2015 / 17:57
1
answer

Create a search within a select

I wanted to know some method to incorporate a search for, to facilitate the use of select in a system with many categories, looking for the internet, I found a paid script that has a solution, let's say better. I will leave an image below that s...
asked by 30.05.2014 / 23:39
2
answers

Filter string field snippet in MySQL

I'm having difficulty getting only the zip code of a field in which the address data is not atomic, I'd like to know a way using MySQL to get only the 8 numeric values of the ZIP code from the field of all records in the database which contain 8...
asked by 07.05.2014 / 03:15
1
answer

Sorting data from one column to another

I'm setting up a hierarchy and everything is working correctly, I just have a little problem sorting the data. The table structure follows. (as basic as possible) create table hierarquia ( 'id' int(11) NOT NULL AUTO_INCREMENT, 'hierarqu...
asked by 18.03.2014 / 18:20