Question about The PHP Group PHP

1 Answer

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...

Posted by on

1 Answer

  • 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

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

Posted on Jun 07, 2010

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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=?


Nov 21, 2013 | Computers & Internet

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

1 Answer

When i try to install the sims 3 File: E:/Chaches/Sunset Valley.objectChache Error: Data error (cyclic redundancy check). pops up i cleaned the disc but it didnt help


If 'E:' is your CD/DVD drive, then some of the data could not be _correctly_ read from the disk.

When the data was written, a CRC value was calculated for the data, and that CRC-value was written onto the disk immediately after the data. When the data is read from the disk, the CRC-value also is read from the disk. A "new" CRC-value is calculated from the data that was read, and the "new" CRC-value is checked against the "old" CRC-value. If the two values do not match, then the data retrieved does *NOT* match the data that was written, i.e., you have an "I/O error".

Take the defective CD-ROM back to the retailer, and get it replaced, under warranty.

Nov 21, 2010 | Computers & Internet

2 Answers

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

Mar 26, 2010 | Acer Computers & Internet

1 Answer

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.

Oct 05, 2009 | Texas Instruments TI-89 Calculator

1 Answer

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.

Apr 04, 2009 | The PHP Group PHP

1 Answer

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.

Jan 13, 2009 | The PHP Group PHP

1 Answer

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!

Jun 11, 2008 | Microsoft Excel for PC

1 Answer

Query for retrieve the data


so, are you looking for the query statement to get this info...

And, upon entering the 6th digit, your code will execute the sql query, such as:
SELECT cardnumber from <table_name> where cardnumber>='123456'

NOTE: replace <table_name> with the name of your table.

You might have to modify the statement depending upon how your calling it.

Check out more info at http://www.w3schools.com/sql/sql_where.asp

Hope this helps.

Jan 25, 2008 | Computers & Internet

Not finding what you are looking for?
The PHP Group PHP Logo

Related Topics:

658 people viewed this question

Ask a Question

Usually answered in minutes!

Top The PHP Group Computers & Internet Experts

dhnguyen

Level 2 Expert

281 Answers

Computer Links

Level 3 Expert

2385 Answers

Mike

Level 3 Expert

4336 Answers

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

Answer questions

Manuals & User Guides

Loading...