Questions tagged as 'phpmyadmin'

Tagged questions
2
answers

Problems with group concat SQL

From my previous question and with the solution that gave me the sentence worked correctly. This was the correct sentence SELECT valor, group_concat(DISTINCT IF(dia=1, valor_b, NULL)) dia_1, group_concat(DISTINCT IF(dia=2, valor_b, N...
asked by 09.05.2017 / 09:55
1
answer

Get database text by ignoring tags

Good morning, I have some saved articles in a database, where all the tags appear so that when you download it with PHP you can load all the elements, ... The fact is that a preview of the article I just want it to be plain text. I have...
asked by 06.02.2017 / 23:06
2
answers

Print Joins data

Perform the following sql, which has an inner and a left to look up the overhead and individual user data. They are in different tables when doing the sql queries but I do not group the result to show it in the same td, resulting in this...
asked by 30.11.2018 / 06:49
1
answer

MySQL Inner Join with null Id columns

I have a table where there are several related ids and using inner join I get the data the problem is that some records do not keep an id and I put value Null and when ago the select with inner join does not show me the data with null value T...
asked by 09.10.2018 / 19:49
1
answer

Do not insert data in my database from PHP

Do not insert the data I leave you photo of the structure of my table and the code for which you can help me thanks. The code is as follows. <?php $con = mysqli_connect("localhost","root","","ufree") or die("conexion exito...
asked by 16.10.2018 / 07:42
2
answers

Error PhpMyAdmin the database fails

I am in a strange problem My database in myphpadmin shows me the following error: Try to import the backing of my previous table where (correctly I showed repeated table) but likewise mind caused errors It's very strange since I...
asked by 20.08.2018 / 20:45
3
answers

Obtain a set of data for each user

Hello friends I need help on how to get the 3 biggest results of the column 'result' of each user with their corresponding data that is shown in the table, please friends I tried to perform the following shown below and if it brings me all data...
asked by 05.08.2018 / 18:42
1
answer

Notice: Undefined variable: row in C: \ xampp / ... / ... index.php on line

I am trying to make an autocomplete form using an input (text) ... I used this way but I do not know if it will be fine ... I leave the code: (I have a patient table (id, code_pac, name, surname_paterno ) CONNECT.PHP <?php $hostname_strc...
asked by 26.05.2018 / 08:13
2
answers

Use of ON_DELETE in Constraints [closed]

I am a new computer graduate and I am motivated by all this programming; I am making an administrative system of human resources for my institution (Police) I am using the yiiframework 1.1 I think this framework is quite practical; Now create 5...
asked by 21.05.2018 / 15:34
1
answer

000webhost with mysql error: Parse error: syntax error, unexpected 'if' (T_IF) in /storage/ssd2/509/5475509/public_html/webhost.php on line 5? [closed]

   Parse error: syntax error, unexpected 'if' (T_IF) in /storage/ssd2/509/5475509/public_html/webhost.php on line 5 <?php //conectar con el servidor $conectar=mysql_connect('databases.000webhost.com','id5475509_julian_forus','') if (...
asked by 10.05.2018 / 17:34