473,320 Members | 2,088 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to fetch comments field from MySQL Table?

3
Is it possible to fetch "Comments" field of a Mysql database table row with PHP?

I know I can fetch 'Field', 'Type', 'Null' 'Default', 'Extra' with 'DESCRIBE table'

Thanks in advance!
Attached Images
File Type: gif Picture-1.gif (9.5 KB, 221 views)
Dec 2 '10 #1

✓ answered by JKing

Expand|Select|Wrap|Line Numbers
  1. $result = mysql_query("SHOW FULL COLUMNS FROM table FROM database");
  2.  
Where table is your table and database is your database. Database is optional if you have already used mysql_select_db you don't need it.

2 4160
Dormilich
8,658 Expert Mod 8TB
I don’t think so, although an SQL-dump should also contain comments.

comments are just that—comments, even in PHP comments are not parsed.
Dec 2 '10 #2
JKing
1,206 Expert 1GB
Expand|Select|Wrap|Line Numbers
  1. $result = mysql_query("SHOW FULL COLUMNS FROM table FROM database");
  2.  
Where table is your table and database is your database. Database is optional if you have already used mysql_select_db you don't need it.
Dec 2 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Bruce A. Julseth | last post by:
My MySQL.user table (user, host, password) looks like the following: +---------+-----------+---------------------+ | user | host | password |...
0
by: astpaul | last post by:
Hi, I've got DMX2004 with Impakt 2.6.2 and MySQL 4.0.16 with ODBC 3.51.06. I am trying to get tables descriptions in order to alter their columns. As following MySQL manual, I use for instance...
6
by: Matt Liverance | last post by:
I REALLY dont want to switch to oracle :( but I cant get these tables working any faster. I've got 2 dedicated servers, each with a slave, all run 32gig 15k rpm raid 5 on u320 perc raid...
6
by: Tom | last post by:
Hi Version of MySQL as yet undetermined but this will be running on White Box - Basically whats the maximum table size in GB that MySQL allows? We are developing an application that streams...
9
by: expect | last post by:
Hello, Trying to get this MySql create table command to work, no luck. create sequence serial; CREATE TABLE outbound ( source char(100) default '', destination char(100) default '', sport...
2
by: _link98 | last post by:
Environment UDB 8.1 Fixpak 9 on Solaris (64bit instance). After connecting to the database as "my_user". There is an alias from my_user.mytable to XXX.mytable. There is no real table...
0
by: kirby | last post by:
My db2 environement is as follows: Suse Linux on powerpc, with 64-bit DB2, 8.1 fixpack 8a. Db2 is installed on local drives, and all tablespaces/containers are on some some network attached...
2
by: samui | last post by:
I'm trying to get a php page to show data from a MySQL database. But the problem that I have is I don't know where to start. I'm very new at PHP and I'm constantly told by others that it's very...
2
wadro21
by: wadro21 | last post by:
can someone tell me what is wrong with this? Error SQL query: CREATE TABLE uploads( upload_id int( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT , file_name VARCHAR( 30 ) NOT NULL , file_size...
4
by: baked | last post by:
Hi, I am using an html form to put a text into a Mysql database table. Using PHP V5 When I recover and display only one space between each word is seen irrespective of how many I add. The...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.