07-24-2014
Field name
I expect you already fixed the issue.
I see you are using quotes for field names
like this:
" select '4' from bla bla bla"
Are you tried perform the query without quotes in the field name?
like this:
" select 4 from bla bla bla "
And what's exactly is number '4'? is the field name?
I'll hope be helpful for you.
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a text file script....called Bukom.txt and it contains these:
BUKOM 20060101 2.5 2.6 2.7 2.8 2.9 2.3 2.1
BUKOM 20060102 2.4 2.5 2.6 2.7 2.7 2.6 2.4
BUKOM 20060103 2.1 ... (9 Replies)
Discussion started by: forevercalz
9 Replies
2. Shell Programming and Scripting
Hi,
Need to get help from you guys about this issue.
I need to insert data into MySql database from a text file which is located in other server.
The text file is something look like below:
Date | SubscriberNo | Call Duration
20/7/07 | 123456788 | 20
20/7/07 | 123412344 | 30
The... (4 Replies)
Discussion started by: shirleyeow
4 Replies
3. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (4 Replies)
Discussion started by: pallavishetty
4 Replies
4. Shell Programming and Scripting
Hi,
I have gps receiver, by using gpsd data i can read gps log data to my database(my sql).
Steps:
1. telenet localhost 2947 > gps.txt (press enter)
2. r (press enter) //then i will get the data like below in gps.txt file
Trying 127.0.0.1...
Connected to localhost.... (1 Reply)
Discussion started by: gudivada213
1 Replies
5. Shell Programming and Scripting
Hi guys ,
I m trying to store the output of vmstat 1 10 into a database.
I have done the necessary homework to connect bash to interact with the database.
Program logic.
1)storing the output of vmstat 1 10 to a file named abc.txt
2)I m applying a filter to vmstat to get desired output... (4 Replies)
Discussion started by: pinga123
4 Replies
6. Web Development
If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries
LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n' (0 Replies)
Discussion started by: sitex
0 Replies
7. Shell Programming and Scripting
I have a list of 10 million page urls. I want those pages scraped and saved in the mysql database as raw html.
I own a Linux VPS server with 1GB RAM and WHM/cPanel.
I would like to scrape at least 100,000 urls in 24 hours.
So can anyone give me some sample shell scripting code? (4 Replies)
Discussion started by: Viruthagiri
4 Replies
8. Shell Programming and Scripting
Sorry to disturb you, I would like to seek help on inserting data whenever the switch is on or off to my phpMyAdmin mySQL database from my Shell Script. I'm using Raspberry PI as my hardware and I have follow this LINK: instructables.com/id/Web-Control-of-Raspberry-Pi-GPIO/?ALLSTEPS to create my... (4 Replies)
Discussion started by: aoiregion
4 Replies
LEARN ABOUT PHP
array_shift
ARRAY_SHIFT(3) 1 ARRAY_SHIFT(3)
array_shift - Shift an element off the beginning of array
SYNOPSIS
mixed array_shift (array &$array)
DESCRIPTION
array_shift(3) shifts the first value of the $array off and returns it, shortening the $array by one element and moving everything down.
All numerical array keys will be modified to start counting from zero while literal keys won't be touched.
Note
This function will reset(3) the array pointer of the input array after use.
PARAMETERS
o $array
- The input array.
RETURN VALUES
Returns the shifted value, or NULL if $array is empty or is not an array.
EXAMPLES
Example #1
array_shift(3) example
<?php
$stack = array("orange", "banana", "apple", "raspberry");
$fruit = array_shift($stack);
print_r($stack);
?>
The above example will output:
Array
(
[0] => banana
[1] => apple
[2] => raspberry
)
and orange will be assigned to $fruit.
SEE ALSO
array_unshift(3), array_push(3), array_pop(3).
PHP Documentation Group ARRAY_SHIFT(3)