The PHP Group PHP Logo

Related Topics:

Posted on Jun 07, 2010
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

In php how to retrieve data while setting an conditon with multip

In php how to retrieve data while setting an codition of selecting multiple values:
For example: select * from table_name where id=value1,value2,value3 <--> this is not working...

1 Answer

Anonymous

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Sniper:

An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

  • Expert 68 Answers
  • Posted on Jun 07, 2010
Anonymous
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Sniper:

An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

Joined: Sep 24, 2007
Answers
68
Questions
0
Helped
34255
Points
279

First of all, it's a Query that used in PHP. it should be like this.

select * from table_name where id in (value1,value2,value3 <---->

This will work

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

Forgot attern on screen lock on lg 76

Solution 1: use your gooogle account
Solution 2: do a resset (all contacts and messeges will be lost)
Solution 3:
Connect your device via USB cable and enter those commands through ADB:
adb shell
rm /data/system/gesture.key
Reboot your android device and now supply following commands
adb shell
cd /data/data/com.android.providers.setting-s/databases
sqlite3 settings.db
update system set value=0 where name='lock_pattern_autolock';
update system set value=0 where name='lockscreen.lockedoutpermanently';
.quit
Restart your device and it It will accept any pattern lock.
tip

How to use multiple login on a single yahoo messanger

  1. Go to start > Run > Type regedit > Press Enter
  2. Click on the plus sign near the folder HKEY_CURRENT_USER
  3. Click on the plus sign near the folder Software
  4. Click on the plus sign near the folder Yahoo
  5. Click on the plus sign near the folder Pager
  6. Right Click on the folder name Test > New > DWORD Value
  7. Right side you will get a file named New Value #1
  8. Right Click on the file New Value #1 and Rename it as Plural and press enter
  9. Double Click on the file Plural
  10. You will get a windown named Edit DWORD Value
  11. Type 1 inside 'Select the Value data' and press enter
  12. Close the registery editor window
  13. Now you can launch multiple windows and use different ID's.
on Feb 01, 2010 • Computers & Internet
tip

Dreamweaver Thought that Teaches You, to search a database with phpmysql...

OK, this should work... First of all, there is one great extension for DW & PHP ADOB object model that is free and great! Download it and install from www.interakt.ro its called PHAKT (NOT impakt, because its not free).

Install it and you will have another type of PHP ADOB document type.
Start project with PHP ADOB (not old PHP MYSQL).

Page 1

Create form that has come Editbox and one button. Name Edit box something like e.g. "Search" without quotes.
That form should have form action="results.php" and type set to POST NOT, Create Page 2 and name it results.php.
Create new recordset in dw like this
SELECT "
FROM table WHERE table.column.you.r.searching LIKE '%colname%' OR table.other.column LIKE '%colname%' ORDER BY table.tableid this means that we want to select ALL (*) records in table WHERE content of column is similar (Dav, will return Dave, David, Davidof...) to search keyword.
Next, in variables click + and add variable name colname default value set to % if you want to show all records if form is submited blank, or -1 if You want to show none if form is submited blank. Finaly for Run-time value type $HTTP_POST_VARS['search'] Runtime value is equal name of Edit box name you set up in first page...
Now, from bindings tab, select values and insert it on page, that You would like to show on page. Ill skip this part assuming You know how to format output and how to limit it but if you dont know ask in reply...
So now You have page with results. Test it and see if its working.
If it is, create page 3 and name it details.php. Now, select value from page that you want to link with details page and click on link. Select details.php page and click on parameters. For param name enter something like id since this should be PK in table and unique value, and for value click on lightning icon, and select primary key in your table. In live page link should be like details.php?id=<some_value>.
As for details page recordset it should look like
SELECT *
FROM table
WHERE table.id = 'colname'
create vars as for page 2, but change Runtime to $HTTP_GET_VARS['id']
and format output on page. That should be it, but since im typing it in "realtime" maby i forgot something...
Home I did helped You.

Good luck!
on Jan 21, 2010 • Computers & Internet
0helpful
1answer

Math mean median mode

The question is incomplete.
The mean, also called the average is defined as
mean= (sum of the data values)/(number of data elements)
Mode = the most frequent data value (the one that is most repeated)
To find the median:
  1. Order the data values in ascending order (sort them from the smallestr to the largest), and
  2. Locate the data value that is in the middle.
  3. If the number of data values id ODD (not a multiple of 2) there is only one middle element. That is the median.
  4. If the number of data elements is EVEN (multiple of 2), there is not one middle element but two.
  5. The median is the average of the two middle element values

    1. Median =( left of middle value +right of middle value)/2
    2. Imagine this median value to be inserted between the two middle elements
Example 1
Data values 12.5, 13, 13., 13, 13.5, 14, 19.5, 19.5, 20
Mean =(12.5+13+13+13+13.5 +14+19.5+19.5+20)/9=?
Mode= most frequent value. Here it is 13 (repeated 3 times)
There are 9 values, an odd number. Middle element is the 5th ( 13.5)
Median=13.5

Example 2
Data values 12.5, 13, 13., 13, 13.5, 14, 19.5, 19.5, 20, 25
Mean =(12.5+13+13+13+13.5 +14+19.5+19.5+20 + 25)/10=?
Mode= most frequent value. Here it is 13 (repeated 3 times)
There are 10 values, an even number. Middle element is not among the values. There are two middle elements (the 5th and the 6th) or
The value of the median is the average of the 5th and 6th elements or
Value of Median =(13.5+14)/2=?


0helpful
1answer

Just turned the TV on and the volume won't work. Have tried to manually turn it on, use the cable box and adjust the audio settings and nothing will make the volume work.

Memory Initialize operation

NOTE: The execution of this function returns the adjustment codes to the preset values, therefore, adjustment

data will be lost.

Procedure

(1) Enter Adjustment Mode.

(2) Select MEMORY INIT adjustment code (No.704) and change the data value from 0 to 1.

(3) Activate MEMORY INIT by pressing OK button for more than 3 seconds.

(4) Select No.374 and change data value from 1 to 0.
(5) Check that the receiving channel goes to AV1. Unit is set to preset values

0helpful
2answers

How to hide a row from html table in php page using javascript and the table data are retrieve from mysql and those display with while loop

When you fetch it row by row..say if its the 5th row you don want to display... just keep a coutner value.. and skip displaying that row

0helpful
1answer

I cant get the stdDev to work, how do you enter teh key strokes

Hello,
Here are some screen captures to illustrate how you set up your statistics. Press [Diamond][HOME][ENTER] . Type in command NewProb and press [ENTER]. It clears old data that may be in lists.
Press [Apps] key then 6 to select Data/Matrix editor. Select New, to create a new data set or current to select the last data set you worked on, or Open if some old data sets exist. Now we select New

4d8515e.jpg

Arrow right to unold the data menu and select Data. Leave folder as main or give a different folder name. Name the data set. Here teststd

5146947.jpg

After [ENTER] data entry sceen is displayed. Enter values

144bdfd.jpg

Press [F5:Calc] to access statistical values. Select 1:OneVar statistics
5ee6ab2.jpg
Identify the columns you want to do statistics on. Here we have only one column, namely c1

c65cb99.jpg

Press [ENTER] to save. First batc of statistical results are displayed.

376386d.jpg

Use [Arrow Down] to uncover the rest of the results.

f43ff08.jpg

These are the basic steps you follow for most statistical calculations.
Hope it gets you started.

0helpful
1answer

Dissappearing spaces when html page handles database data

Mark, it sounds like when you are displaying the data back to check and edit the data, you are not including it inside of quotes.

example:

//query to grab example data
$query="select name,salary from employee";
$result=mysql_query($query)
or die("query failed!");

printf("<input type='text' value='%s'>",mysql_result($result,0,"name"));
printf("<input type='text' value='%s'>",mysql_result($result,0,"salary"));

notice in my example the "value" argument of the "<input>" command the %s for your variable is contained within single quotes.
0helpful
1answer

Clarification

are you saying you're switching from a session variable to a cookie?

delete the cookie altogether by setting the expiration to a time in the past (negative value). don't forget that you'll then have to reload a page in order to reread the cookie data.

so if you have a cookie with a logged_in value = true, and you set it to logged_in value = false, you're still logged_in = true, until you reload that page (or another page) and it rereads the cookie data and now determines that logged_in = false.

make sense? write the logged_in=false to the cookie, then force a url redirection to reload the page is my suggestion.
1helpful
1answer

Multiple Values on Y axis

This is explained in the Excel help.
- select the second data set (in the chart).
- select the Format tab in the ribbon.
- click the Format Selection option.
- select Secondayr axis.
- click Close.

Works like a charm!
Not finding what you are looking for?

667 views

Ask a Question

Usually answered in minutes!

Top The PHP Group Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Brad Brown

Level 3 Expert

19187 Answers

Cindy Wells

Level 3 Expert

6688 Answers

Are you a The PHP Group Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...