I would try the following, putting escaped "double quotes" around the SHOW variable. I cannot guarantee it will work, as the testing is a bit awkward, but I think a good chance it will work:
If possible to remove those blanks from files names, I would encourage that. Those blanks in file names cause so many irritations.
I'm attempting to print to a networked konica printer. No linux drivers that I know of exist, but we've always used HP 5si drivers and have had good results.
We just loaded a box up with CentOS 5, and now when we print any sort of file from the command line (lp -dkonica <filename>), the text is... (0 Replies)
Hi guys, not that used to using sed beyond the simple substitution. I am trying to check for a program (program1) and if it exists replace the standard output "program1" with a "program1(part1 part2) output if said program exists.
SW="program1 program2"
PROGRAM_TEST='echo "$SW" | grep... (3 Replies)
Hello,
I am attempting to create a command that I can eventually put into a loop so I can edit 1file on many servers. I would like to edit the file in place with sed -i. If not I will take any suggestions on how to use a temp file. I need to remove a email address from the configuration file... (4 Replies)
Hi,
I am modifying a file with sed command. i want to make SCORE= blank in the file whereever SCORE=somevalue.
What will *$ do in the below command?
cat $file | sed 's/SCORE=.*$/SCORE=\r/g' > newfile
The last line is also missing in the new file. How to make SCORE='100' to SCORE=... (5 Replies)
Hello everyone,
This is my first posting. I have read the rules of this forum. I have searched many various threads and haven't found one that applies to my situation or suggestions to fix the issue. I do appreciate the help.
I am trying to execute a basic UNIX script in a Solaris... (4 Replies)
hello,
is it a behavior of or
that "-i" removes unix link .
example :
i create a file "src_file" and link it to "link_file" and then i start "perl -i"
the link is removed. does another option exists to change content of a file without temporary files ?
UNIX-Version: HP-UX and... (2 Replies)
Why does the below command doesnt work fine on SunOS 5.10
$ cat t
| AK| | | | | DS | | | | tAR | | | | | FIL |
$ sed -e 's/^ *//g' -e 's/ *$//g' -e 's/ *| */|/g' t
|AK|||||DS|||| tAR|||||FIL|
##notice before tAR
works fine on Linux OR AIX though
... (8 Replies)
I use SMP Tue Aug 18 15:51:48 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
We have a user-defined command called "submit" which will open a vi terminal in which we need to enter the description at 24th line and save it.
In order to simplify this, i decided to create another command in which the... (3 Replies)
sed is not applying /d "delete line" option when I also include match word options \< and \>
examples...
echo cat | sed '/\<cat\>/d'
will return cat for some reason
echo cat | sed "/\<cat\>/d"
will also still return cat.
Of course I can just run this... echo cat | sed '/cat/d' and... (1 Reply)
Hi
We have a requirement to send email using shell script.email should have html body and pdf attachment. We used uuencode for attaching files and sendmail option to acheive and it is working fine. However custoemr wants to make body of email slightly dynamic. E.g dear customer in html file... (3 Replies)
Discussion started by: Harish7586
3 Replies
LEARN ABOUT PHP
mysql_list_fields
MYSQL_LIST_FIELDS(3) 1 MYSQL_LIST_FIELDS(3)mysql_list_fields - List MySQL table fieldsSYNOPSIS
Warning
This function was deprecated in PHP 5.4.0, and will be removed in the future, along with the entirety of the original MySQL exten-
sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more
information. Alternatives to this function include:
oSQL Query:
SHOW COLUMNS FROM sometable
resource mysql_list_fields (string $database_name, string $table_name, [resource $link_identifier = NULL])
DESCRIPTION
Retrieves information about the given table name.
This function is deprecated. It is preferable to use mysql_query(3) to issue an SQL SHOW COLUMNS FROM table [LIKE 'name'] statement
instead.
o $database_name
- The name of the database that's being queried.
o $table_name
- The name of the table that's being queried.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
A result pointer resource on success, or FALSE on failure.
The returned result can be used with mysql_field_flags(3), mysql_field_len(3), mysql_field_name(3) and mysql_field_type(3).
Example #1
Alternate to deprecated mysql_list_fields(3)
<?php
$result = mysql_query("SHOW COLUMNS FROM sometable");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
print_r($row);
}
}
?>
The above example will output something similar to:
Array
(
[Field] => id
[Type] => int(7)
[Null] =>
[Key] => PRI
[Default] =>
[Extra] => auto_increment
)
Array
(
[Field] => email
[Type] => varchar(100)
[Null] =>
[Key] =>
[Default] =>
[Extra] =>
)
Note
For backward compatibility, the following deprecated alias may be used: mysql_listfields(3)mysql_field_flags(3), mysql_info(3).
PHP Documentation Group MYSQL_LIST_FIELDS(3)