All Questions
51 questions
0
votes
0
answers
277
views
Assign Mysql show command result to a variable
How can i assign only table value to a variable as i want to use it in an if condition later on
show open tables where `table` = 't1' and in_use >0;
Result:
Database table In_use name_lock
Ai ...
2
votes
1
answer
3k
views
Call to undefined relationship [users] on model [App\Team] laravel 6
Hey i am pretty new in coding and laravel.I am trying to build an app here i think i messed it up but cant find a way around it.I am getting Call to undefined relationship [users] on model [App\Team] ...
- 53
3
votes
1
answer
2k
views
select only ONE column from the query: "SHOW TABLE STATUS FROM `DB`"?
is possible select only ONE column from the QUERY: "SHOW TABLE STATUS FROM DB" ??
I want select ONLY 1 or 2 columns from result obtained in the QUERY:
SHOW TABLE STATUS FROM `DB`
I need ALL tables ...
- 231
1
vote
3
answers
5k
views
mysql: show databases doesn't show any databases
I am new to using MySQL on a Mac. I am trying to show all the default databases but nothing is showing up when I use the command "show databases".
I have tried uppercase and lowercase. As well as ...
- 11
1
vote
1
answer
1k
views
Show/Hide records PHP MySQL
Since i can't find anything about this, i thought i should ask for help here.
I'm working on a table (PHP/MySQL) which currently looks like this:
https://i.gyazo.com/4115cf6fb14921ea9109580ec9c6c531....
- 45
0
votes
1
answer
274
views
Show / hide php mysql results with loader
I have MySQL database results.
I want to show 3 rows and then hide rest.
When the user clicks to load more data then to appear all rows.
The problem is when I click show more, then only one more ...
- 19
0
votes
2
answers
305
views
How can i show only certain columns of data table in sql?
I created table in php and want to show only some of column names in this table. I used SHOW Statement, but it shows all columns. This is my code:
$result = mysqli_query($con, "SHOW COLUMNS FROM ...
- 37
1
vote
1
answer
669
views
mysql php jquery hide show select
I know a little bit of PHP programming, but none of JQuery.
I have build a <select> dropdown menu with data from MySql db.
But now I want a button or something next to the <select> option,...
- 28
1
vote
2
answers
2k
views
Can we use functions like concat() group_concat() in show statement?
For instance I run command
mysql> show tables;
Tables in DB
a
b
c
d
I want to use it such as concat('drop table ', tablename, ';');
So that my result set would become
drop table a;
drop ...
- 581
1
vote
1
answer
59
views
Trying to put SHOW DATABASES to a combobox in C# gives me list of System.Data.DataRowView
I was trying to put a list of databases from mySQL server, to a combobox in C#. when i click on a button to fill it, it gives me list of "System.Data.DataRowView"
instead of values.
Can u tell me ...
- 33
1
vote
0
answers
252
views
Showing categories and their respective subcategories in a specific html structure
<ul>
<li>
<a href="">Category 1</a>
<ul>
<li><a href="">Subcategory 1</a></li>
<li><a href=""&...
- 823
0
votes
1
answer
29
views
Change column name for SHOW queries
In MySQL, is there a way to change the column name for SHOW queries?
For example, SHOW GRANTS FOR 'guest'@'%'; returns one column called Grants for guest@%. SHOW CREATE TABLE ... ; returns two ...
- 2,720
2
votes
1
answer
526
views
How can I use MySQL statement 'show index' with PDO?
I am trying to use PDO and prepared statements to get the primary key of a table. From other questions I saw that this is possible when executing something like this:
show index from TABLENAME where ...
- 1,842
0
votes
3
answers
162
views
MySQL Data show by php. If select show selected data, If no select; show whole data. How can I do this?
This is a blood donation web site. If anybody want to see his areas donor; he select blood-grp, district and area. But if he do not select area field, He see nothing. But I want He see whole districts ...
1
vote
0
answers
39
views
How can I retrieve and display images from mysql in a JSP page? [duplicate]
How can I retrieve and display images from mysql in a JSP page? I want to read database and display all image by id . Result is : [B@4b8c5b6c
I think I need to use servlets How do I write this ...
- 491
0
votes
1
answer
76
views
MySql - Get Column Names where Value is 1
My MySql Table looks like this:
| id | picID | name_Gina | name_Tom | name_Liz |
|----|------------|-----------|----------|----------|
| 1 | DSC057.jpg | 1 | 0 | 0 |
| 2 |...
- 145
2
votes
2
answers
59
views
MYSQL show uncounted
I've two tables in MySQL: tracks and ratings. I want the query to count how much ratings there are per track, that's why I use the following:
SELECT t.*, COUNT(*) as ratings
FROM tracks t, ratings r
...
- 1,173
2
votes
3
answers
90
views
How to show previous 3 inputs in mysql
So i make this code:
SELECT * FROM `data` WHERE
`id`=(select max(`id`) from `data`
WHERE `cat`='$data[cat]' and `id` < $data[id])
So... how can edit it.. to show not only one result, but the ...
- 83
0
votes
1
answer
1k
views
MySQL : Slow show databases;
We are currently using a MySQL Server version 5.5.35 x86 - Win64
When we run the command :
SHOW DATABASES;
As root user :
2640 lines in 0,125 sec. (+ 0,015 sec. network)
As user with ...
- 627
0
votes
1
answer
107
views
Show sub-data in each data with php
I'm trying to solv this issue. I have this php code.
<?php
if (count($Modulos)>0){
for ($x=0; $x<count($Modulos); $x++){
// SOME CODE, to define variables
$...
- 1,293
1
vote
2
answers
2k
views
mysql_query("SHOW DATABASES") doesn't show my database
I am testing a local page using xampp. Searching how to fix a "No database selected" mysql error lead me to testing this out:
mysql_connect('localhost') or die ("Connect error");
$res = mysql_query("...
- 741
0
votes
1
answer
86
views
I have two Triggers on Mysql Database, but I can list one only with SHOW TRIGGERS
I created two triggers for MySQL database. But I want to get the trigger names and statements, but when I try I get back one array of one trigger only with code:
$TriggersOfArray = (mysql_fetch_assoc(...
4
votes
2
answers
17k
views
How to build a dynamic MySQL INSERT statement with PHP
Hello
This part of a form is showing columns names from mysql table (names of applications installed on a computer) and creating a form with YES/NO option or input type="text" box for additional ...
- 41
4
votes
1
answer
1k
views
There's any way to change the column name on SHOW TABLES?
I need to make the following Query on VB.NET to a MySQL Server
SHOW TABLES FROM BaseX
Currently returns "Tables_in_BaseX"
But I want that the column name be a specific word.
There's any way to ...
- 1,151
0
votes
3
answers
372
views
Jquery display text from mysql
Maybe someone can give me a little help.
I modified a jquery to appear as i wanted, you can see it here: http://loja.genesiseries.com/depoimentos/index.html
But i need display text from mysql DB, so ...
- 11
1
vote
0
answers
403
views
click image list form mysql show div and hide other all image
I have an issue you would like to ask for help.
I have an issue you would like to ask for help.
I have an image list from mysql (img1, img2, ... imgn) I want to click on each image, it will show a ...
- 2,989
-3
votes
1
answer
279
views
Show one specific column assigned by ID in MySQL and PHP [closed]
I have a database called "tekst".
There are 3 columns:
id (autoincrement),
date (timestamp),
tresc (text)
and the site: index.html.
I want to paste code like that <?php echo "$id1"; ?> ...
- 49
1
vote
3
answers
1k
views
Show specific column by ID in MySQL and PHP
I have problem (i think for you is simple to solve) with PHP and MySQL.
I have database, that call "tekst".
There is 3 column:
id (autoincrement),
date (timestamp),
tresc (text)
and the site: ...
- 49
1
vote
1
answer
2k
views
PHP Array doesn't show all the data from database
I have a very basic and simple script that should display records from my database. The problem: it doesn't show all the records. I've tried it even with the most simple mysql
($sql="SELECT * FROM $...
- 107
1
vote
3
answers
2k
views
show checkbox data mysql
I am having some minor errors and was wondering if anyone could help!
I am creating a attendance system for a college.
This Scenario:
Student logs in successfully and then wants to view his/her ...
0
votes
1
answer
41
views
Show 1 factory (individual) on page when factoryname is clicked
i have a searchfunction for factories. when i search for a factory and click on the name (a hyperlink) i want to show the individual factory on a new page.
You can see it here: http://kees.een-site-...
- 5,784
0
votes
1
answer
961
views
Show individual database record based on the given id
I still can't get it to work it's a bit tricky for me as a codeigniter newbie. please help me.
I am working with codeigniter and now i want to show my factories one by one.
I made a search function ...
- 5,784
0
votes
1
answer
107
views
In PHP and Mysql, how do you execute a Mysql statement and display the results before the loop is finished?
I have the following code below. The goal is to execute a select statement, display the results and then execute the statement again. I can't get it to work properly. When the code is executed ...
0
votes
3
answers
15k
views
Codeigniter Message: Undefined variable: query
SOLVED!
thanks to Fabio i realized that i missed something in my index function of my controller.
i am working on a view that show's me the data from the database.
Now i get the error: Message: ...
- 5,784
0
votes
2
answers
1k
views
Upcoming event script
I am trying to make a script which shows upcoming event (single one).
Here is what I have:
Joomla, an extension where you can add an event and a calendar of that extension that shows those events on ...
- 136
0
votes
3
answers
82
views
Show without last commas on categories
I have this code:
<?
$kate=mysql_query("select category_id from movies_cat where movie_id='$ids'");
while($cat=mysql_fetch_array($kate)){
$kate2=mysql_query("select name_cat from ...
0
votes
1
answer
2k
views
display categories and sub categories readmore page
I'm beginner ( PHP & MySQL ) , I Have Problem With my Code In my website I created unlimited categories and subcategories - Table - >
catid catname parentid
1 | ...
- 23
11
votes
5
answers
31k
views
Show procedure/function code in MySql
Is there any options to view stored procedure/function code in MySql same as like "sp_helptext procedurename" in sql?
- 139
0
votes
1
answer
292
views
Show more info on database item
I need help with a php page that shows information from a mysql database concerning buildings around a town square. I want it set up so that the addresses are the only thing displayed at first. Then ...
- 11
1
vote
3
answers
11k
views
How to "show databases" which belong to a specific user in MySQL?
"show databases" shows all databases where you (logged in user) have some privileges.
Is there a way to show all databases where user "xxx" has some privileges?
Edit:
I have an user "mickey":
mysql&...
- 299
1
vote
1
answer
639
views
Jquery show and hide items issue. Blank spaces
I have a site that displays multiple items extracted through PHP from a MySQL table.
Then I have a filter by color (checkboxes show the different colors and by clicking on them the following jquery ...
- 2,588
1
vote
4
answers
879
views
(PHP) Get repeated data (MySQL) from a value in a dropdown list and show it in a table
I have a file that has a dropdown list with a set of values (matricula) from a database (movimentos) what I want is when I select that value in the dropdown list it searches the database for repeated ...
- 13
0
votes
2
answers
2k
views
HTML, PHP AND MYSQL pictures next to each other
So let's say that I have a number of images on my server, uploaded by users. Each picture also has a row in the database containing information like filename, category, filesize, extension and ...
- 531
-1
votes
1
answer
173
views
how to show all records from a specific mySQL row - except duplicates?
Is there any easy way to show all records from a specific mySQL row - except the duplicated ones?
- 3,514
0
votes
1
answer
1k
views
MySQL: INSERT INTO table SHOW CREATE VIEW
I need to write the column 'Create View' of SHOW CREATE VIEW in to a temporary table.
Note that i cannot use the INFORMATION_SCHEMA because the create view statement there is a little bit different ...
- 518
16
votes
3
answers
63k
views
Show users with any privileges to database. MySQL
i have to select all users with any privileges to database (e.g. database 'mysql'). Any suggestions? Thanks.
- 371
1
vote
3
answers
1k
views
PHP Mysql Table information
This works:
$result = mysql_query("SHOW TABLES FROM `someDatabase` ");
while($row = mysql_fetch_array($result)){
echo $row[0].'<br>';
}
And I get the database tables just fine.
Is it ...
- 13.1k
3
votes
3
answers
7k
views
Informix equivalent to mysql's SHOW CREATE TABLE
Is there any equivalent to MySQL's SHOW CREATE TABLE <tablename> in informix? I would like to run it in the SQL Manager on the Server Studio and would also like to obtain information about a ...
- 363
-1
votes
1
answer
1k
views
How to select an entire database and display all the information
Is it possible to select all the tables from a database (not knowing their names) and displaying them?
My friend has a mysql server but he doesn't have phpMyAdmin installed and he's begging me to ...
- 241
54
votes
5
answers
33k
views
Only show tables with certain patterns in mysql "show tables"
There are too many tables in a db. how can I only show tables with certain patterns? Or is there a way I can do paging like "| more" in shell command?
- 1,204