How do I write multiple variable syntax?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How do I write multiple variable syntax?
# 1  
Old 11-11-2008
PHP How do I write multiple variable syntax?

I am trying to write a script that will do a sql statement. But in the sql I will have a list (1,2,3,4).

How would I go about asking for the input from the user running the script, and then transferring that back into the list as say ($var1,$var2,$var3)?

It would be somewhat like this:

Enter numbers:
1,2,3,4,5,6,7,8 (I need these numbers to be the variables)

Select *
from person
where nbr in ($var1,$var2,$var3,$var4);

Any and all help is greatly appreciated! Have a good day!Smilie
# 2  
Old 11-11-2008
IF you always want a linear query use the between operator
where a between b and c
Code:
select stuf from mytable where cnt between 2 and 7;

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Is it possible to write write multiple cronjobs in shellscript??

Hi All, I need the answer of below question? 1) How to write multiple cronjobs in shellscript? Is there any way or we cant write in shellscript... Regards, Priyanka (2 Replies)
Discussion started by: pspriyanka
2 Replies

2. Shell Programming and Scripting

Variable syntax error in $?

hi all , i just tried to take the status of previous command inside the script using echo $?. It throws me a variable syntax error , but when i use echo $? as an individual command it works perfectly . can anyone Please tell me why am getting a variable syntax error when i use echo $?... (7 Replies)
Discussion started by: Rahul619
7 Replies

3. Shell Programming and Scripting

Awk if-else syntax with multiple columns

I can't seem to get this to work. I can reformat the date field if it's the first field (and only field) in the file: However, I get a syntax error when the date field is the second field (or has any other columns following): I can use a ";" but then it puts each column on separate... (8 Replies)
Discussion started by: giannicello
8 Replies

4. Shell Programming and Scripting

Psed syntax -- specifically the write option

EDIT: Nevermind. I found a forth kludge to get around the psed requirement! Short version: I'm trying to use the "w" flag with psed to write all substituted lines into another file. No matter how many times I read the man pages or search with Google, I can't seem to find the proper syntax... (0 Replies)
Discussion started by: CluelessPerson
0 Replies

5. IP Networking

write() / read() syntax

hi am newbie to unix and socket programing I am trying to figuring out syntax for read and write to send data from server to client and client can read it I have to send two integers write(newsockfd,buffer,"%d %d",x,y,0) writing from client where x and y are two integers.. ... (7 Replies)
Discussion started by: karthik1238
7 Replies

6. UNIX for Dummies Questions & Answers

Variable syntax and lines of code

I am trying to use use the AWK and EGREP commands together in an AWK script. My overall objective is to count lines of code but exclude comments and blank lines and such. I am able to use AWK with the FIND command like so: | awk '{print \"wc -l \"$1}' > lineCount.sh Now when I modify the... (7 Replies)
Discussion started by: mastachef
7 Replies

7. Solaris

C-shell: variable syntax question

There is a possibility to set a variable, having an another variable in it's name: prompt% setenv PRT one prompt% setenv VAR_${PRT} value prompt% So, this way the VAR_one = "value" and could be viewed: prompt% echo VAR_one value prompt% Q: How to view a variable having another... (0 Replies)
Discussion started by: alex_5161
0 Replies

8. UNIX for Dummies Questions & Answers

Setting a variable (need syntax help)

I need some syntax help (working in a bash shell) I have a variable which is a filename with an extension, and I need to create another variable with the same name but a different extension To explain, the input file should be called something like "filename.L1" and the output file should be... (1 Reply)
Discussion started by: Slanter
1 Replies

9. UNIX for Dummies Questions & Answers

multiple cuts syntax problem

Hi All, I need some help with multiple cut and paste, at the moment I have a shell script that uses the following cuts ( this is just some) cut -c1-92 WAITING > col1 .....etc etc etc cut -c93-98 WAITING > col17 # blank_spaces cut -c99-104 WAITING > col18 # Date cut -c105... (12 Replies)
Discussion started by: Gerry405
12 Replies

10. Shell Programming and Scripting

Syntax to export any variable

How to export variables on a UNIX prompt. Please provide me syntax. Thanks in advance. Malay (5 Replies)
Discussion started by: malaymaru
5 Replies
Login or Register to Ask a Question