PHP - Using Select To Get Id From Table

Gidday all,

My Utimate goal is to parse the data on the first row in first table and first row in second table.
from he http://www.bom.gov.au/products/IDQ60901/IDQ60901.94580.shtml

Presently I can only parse data in the last row in the last table.

I got to this point about 2 days ago, I am unable to find any info as to what I need to do to achieve what I want.
some of the info I've found I don't understand.

Need newbie help.

What do I need to add/change to parse the data in  at least the first table row?

Code: [Select]

<?php
error_reporting(E_ALL);
include_once('htmldom/simple_html_dom.php');
$url = 'http://www.bom.gov.au/products/IDQ60901/IDQ60901.94580.shtml';


// Create DOM from URL
$html = file_get_html($url);

foreach($html->find('table tr') as $weather) {
    if($weather->find('th')) {continue;} //apparently this needs to be added because there is a bug in simple_html_dom.php
    if(!$weather->find('td ', 0)) {continue;}
    
    $datetime = $weather->find('td', 0)->plaintext;
    $currentTemp = $weather->find('td', 1)->plaintext;

}
 
print_r('updated:' . '&nbsp' .$datetime);
print_r ('<br>');
print_r('CurrentTmp:' . '&nbsp' .$currentTemp);
print_r ('<br>');
?>

guys, please help

i need balance amount of fees all students has to pay. Following is the DB structure. `feepayid` is primary key for paymentstable and paymentregister & `studentid` is primary in studentstable. I have written a query for this, please evaluate the query.

paymentstable
feepayid classid paydate paymode feeamount remarks feediscount 32 8 2012-03-06 19:32:35 1 500 hgfhf 0 31 8 2012-03-04 19:32:35 1 800 hgfhf 0 30 8 2012-02-06 19:32:35 1 1200 hgfhf 0 29 8 2012-02-06 19:32:35 1 1100 hgfhf 0
paymentregister
feepayid payid totalfee studentid 32 3 1500 2 31 2 3500 2 30 1 4500 4 29 3 5500 4
studentstable
studentid studentname 2 john 4 mathew 5 peter 6 mary
Code: [Select]
SELECT d.`studentid`, SUM(a.`totalfee` - (SELECT SUM(`feeamount`) FROM `paymentstable`  WHERE a.`feepayid` = `feepayid`)) AS balancefee
FROM `studentstable` d
LEFT JOIN `paymentregister` a ON a.`studentid` = d.`studentid`
GROUP BY d.`studentid`;

 

Hi there, wanted to see how I would have the columns I specified in 

$fields = array('id','type');

 

then be generated dynamically in the while loop and any other field I state in

$fields = array('id','type');

then its added to the while loop in the below
 

include('db.php');

class SelectData{


public function wpquery_select($conn,$sql,$fields){

$results = $conn->query($sql);

if($results->num_rows > 0){

	while($row = $results->fetch_assoc()){
		
		// How would you process the array $fields which holds all the rows specified and dynamically create echo $row['id'], $row['id'] and so on?
		
	}
	
  }

$conn->close();

 }

	
}



$select = new SelectData();

$sql = "SELECT * FROM orders";


$fields = array('id','type');


$select->wpquery_select($conn,$sql,$fields);

Thank you

I have a table in a database that I need to filter upon using dependent select boxes.  The database was poorly designed and would be difficult to break into separate tables without affecting code written in other places.  I have found some good code and understanding of how to implement the dependent select boxes if you have two tables with one column functioning as a lookup value between the two.

I have provided a short bit of sql of what the table looks like with some column names changed.  I would need to first sort by lastname and have firstname dependent on the selection of lastname.  Any help would be greatly appreciated.

Code: [Select]
create table `user` (
`id` int(3) Not Null Auto_increment,
`firstname` varchar (60),
`lastname` varchar (24),
`age` double ,
`hometown` varchar (75),
`job` varchar (75),
`birthdate` date
);
insert into `user` (`id`, `firstname`, `lastname`, `age`, `hometown`, `job`, `birthdate`) values
('1','Peter','Griffin','41','Quahog','Brewery','1960-01-01'),
('2','Lois','Griffin','40','Newport','Piano Teacher','1961-08-11'),
('3','Joseph','Swanson','39','Quahog','Police Officer','1962-07-23'),
('4','Glenn','Quagmire','41','Quahog','Pilot','1960-02-28'),
('5','Megan','Griffin','16','Quahog','Student','1984-04-24'),
('6','Stewie','Griffin','2','Quahog','Dictator','2008-03-03');

Hi, I'm a little bit new to php and i'm having a small problem. Let me explain with the script :

Code: [Select]
<?php

//connect to mysql

$data = mysql_query("SELECT * FROM forum_topic WHERE topic_id='$topic'") 
or die(mysql_error());

while($info = mysql_fetch_array( $data ))

$dete = mysql_query("SELECT * FROM forum_topic WHERE login='$info['username']'") 
or die(mysql_error());

while($info2 = mysql_fetch_array( $dete ))

     {

echo "......";
     }
?>
 
So I have the first SELECT command that will get the data from table forum_topic and array the data and after that I have a second SELECT that will get the data from table_members but this time time the WHERE clause equals to some data "arrayed" in the first SELECT command...And the end I need to output the data from both tables....

Here's the error I get :


Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/content/m/a/z/mazemontana/html/login/forum_viewtopic.php on line 73


...I know that my syntax is probably not good but can't figure out how to do it.....

Any help will be greatly appreciated!

Thanx

hi im trying to use  query to select from a table where the price is between to values that the user has to input such as min of 3 and max of 8 and return all the fields from the database where it is true im unsure how to do this but this is what i have so far   $res = pg_query ($conn, "SELECT ref,artist,composer,genre,title,album,label,price,description FROM music WHERE price = < && > ");

i need to pull the records from where status not = rejected does anyone know the correct syntax?
Code: [Select]
$data=mysql_query("SELECT * FROM design WHERE id='$id' AND status!='rejected' ") or die (mysql_error());

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=321906.0

I have set up a form page with a select box of colleges to select. I want the "options" in the select box to be values taken from a field called "name" in a table called "colleges" and they should be ordered alphabetically. I also want the default selected option to be "none."

I have attached a picture to describe what i want. Please be detailed with the code. I am fairly new to php and mysql. Thank you.

I have tried several attempts and can get data to select and using echo display it, however, I need to take this data and insert it into the database in a separate table.   I have the following which does hafl the job, can I get some pointers on the rest.  I have looked everywhere and not found a solution, at all.


// Selects the data I need
<?php
mysql_connect("PRIVATE INFO","PRIVATE INFO","PRIVATE INFO") or
    die("Could not connect: " . mysql_error());

mysql_select_db("wpdb");

$result = mysql_query("SELECT ID FROM wp_posts

WHERE post_title LIKE '%future%'
AND post_status = 'publish'
OR post_title LIKE '%option%'
AND post_content LIKE '%fundamental%'
AND post_status = 'publish'

   ORDER BY post_date DESC");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{   echo $row['ID'];
   echo "<br />";};

?>



Thought maybe something like the following would work, but am at a loss:
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id, term_order)
       SELECT ID FROM wp_posts

            WHERE post_title LIKE '%future%'
            AND post_status = 'publish'
            OR post_title LIKE '%option%'
            AND post_content LIKE '%fundamental%'
            AND post_status = 'publish'

            ORDER BY post_date DESC

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

VALUES
($row['ID'], '25', '0')

Hi,

I have a DB with two tables, customers and orders. One customer may have many orders, What I want to do is do a select on the two tables and get the customer info once, and then all the orders associated with the account.

I saw how to do this once before using a join and then having to use a PHP foreach to break it up. I am just not sure of how to put the two together to make it work, or maybe there is an easier way completely.

Any help is appreciated.

Thanks

B

Example:

Bob Smith
Shoes
Coat
Boots
Gloves

Sally Jones
Hat
Purse
Boots
Umbrella

I want to make a table for each paddler_id (Field) which exists into pushup Database

My code for paddler_id = 1 is


require "../sql.php";

$result = mysql_query("EXPLAIN pushup");
$r = mysql_query("SELECT * FROM paddlerinfo t1 LEFT JOIN pushup t2 on t2.paddler_id=t1.id LEFT JOIN practicedate t3 on t3.practice=t2.practice_id ORDER BY t1.firstname ASC ");
$r1 = mysql_query("SELECT * FROM pushup  where paddler_id =1 ORDER BY practice_id ASC ");

echo "<table width='30%' border='1' cellpadding='0' cellspacing='0' style='font-family: monospace'>";
echo "<tr>";
echo "<td>DATE</td>";
while ($row = mysql_fetch_array($result)) {

if (in_array($row["Field"], array("paddler_id", "practice_id", "p_id"))) continue;

echo "<td>",($row["Field"]), "</td>";
}
echo "</tr>";

while (($data = mysql_fetch_array($r1, MYSQL_ASSOC)) !== FALSE) {
   unset($data["p_id"],$data["paddler_id"]);
echo "<tr>";
   foreach ($data as $k => $v) { 
echo "<td>";
      echo"$v";
echo "</td>";
}

echo "</tr>";
}


echo "</table>";

mysql_free_result($result);
mysql_free_result($r);
mysql_free_result($r1);
mysql_close();



The problem is on line $r1 = mysql_query("SELECT * FROM pushup  where paddler_id =1 ORDER BY practice_id ASC ");
I want to put something which makes it paddler_id = X where x = 2,3,4,5... and x exists in database and do not print twice the x (because that database may have rows where x = same id


How do i do that??

Please I want get data from mysql; 

1. The last 24 hours. 
2 the last 7 days 
3. the last Months  4. Last 12 hours

please try and help me

Hi all, probably a fairly straightforward question, but I can't find the answer I'm looking for:

I have an array 'idents' that contains ID numbers. I now want to write a MySQL query that selects all values of the table-field 'email' where the field 'ID' = any of the IDs stored in 'idents'. Then I want to put those emails in an array 'emails'.

So e.g. my table is as follows:
ID         |   email
----------------------
111111 |   email1
222222 |   email2
333333 |   email3
444444 |   email4
555555 |   email5
666666 |   email6

and the array 'idents' is as follows: '111111','444444','555555'

then I want the query to return 'emails' = array('email1','email4','email5');

Thanks for your help!

I have the following html code and php code. I would like clients to select which fields in the mysql database they would like to have appear in the resultant table by checking the text box next to the field in the html form. For instance they should be able to select first name and city and have only those columns appear in the resultant table.

# <html>
# <head>
# <title>Search Clients Database</title>
# </head>
# 
# <body>
# <h1>Clients Database Search Page</h1>
# <form action="searchclients.php" method="post">
#   <table width="100%" border="1" cellspacing="1" cellpadding="1">
#     <tr>
#       <th width="37" scope="col">&nbsp;</th>
#       <th width="114" scope="col">Fields</th>
#       <th width="169" scope="col">Filter Value</th>
#       <th width="1157" scope="col">&nbsp;</th>
#     </tr>
#     <tr>
#       <td><input type="checkbox" name="idc" id="idc"></td>
#       <td>ID</td>
#       <td><input type="text" name="ID" id="ID"></td>
#       <td>&nbsp;</td>
#     </tr>
#     <tr>
#       <td><label>
#         <input type="checkbox" name="fnc" id="fnc">
#       </label></td>
#       <td>First Name</td>
#       <td><input type="text" name="FirstName" id="FirstName"></td>
#       <td>&nbsp;</td>
#     </tr>
#     <tr>
#       <td><label>
#         <input type="checkbox" name="lnc" id="lnc">
#       </label></td>
#       <td>Last Name</td>
#       <td><input type="text" name="LastName" id="LastName"></td>
#       <td>&nbsp;</td>
#     </tr>
#     <tr>
#       <td><label>
#         <input type="checkbox" name="cc" id="cc">
#       </label></td>
#       <td>City</td>
#       <td><input type="text" name="City" id="City"></td>
#       <td>&nbsp;</td>
#     </tr>
#     <tr>
#       <td><label>
#         <input type="checkbox" name="pc" id="pc">
#       </label></td>
#       <td>Province</td>
#       <td><select name="Province" id="Province">
#         <option selected> </option>
#         <option>KZN</option>
#         <option>North West Province</option>
#         <option>Gauteng</option>
#         <option>Free State</option>
#         <option>Mpumalanga</option>
#         <option>Eastern Cape</option>
#         <option>Limpopo Province</option>
#         <option>Northern Cape</option>
#         <option>Western Cape</option>
#       </select></td>
#       <td>&nbsp;</td>
#     </tr>
#   </table>
#   <p>
#     <input type="submit" name="submit" value="Search" />
#   </p>
# </form>
# 
# </body>
# </html>


# <?php
# mysql_connect ("localhost", "username","password")  or die (mysql_error());
# mysql_select_db ("clients");
# 
# $fn = $_POST['FirstName'];
# $ln = $_POST['LastName'];
# $city = $_POST['City'];
# $prov = $_POST['Province'];
# 
# $idc = $_POST['idc'];
# $fnc = $_POST['fnc'];
# $lnc = $_POST['lnc'];
# $cc = $_POST['cc'];
# $pc = $_POST['pc'];
# 
# ?>
# 
# <html>
# <body>
# 
# <table border=1>
#   <tr>
#    <th>ID</th>
#    <th>First Name</th>
#    <th>Last Name</th>
#    <th>City</th>
#    <th>Province</th>
# </tr>
# 
# <?php
# $sql = mysql_query("select ID, FirstName, LastName, City, Province from clients where FirstName like '%$fn%' and LastName like '%$ln%' and City like '%$city%' and Province like '%$prov%'");
# 
# while ($row = mysql_fetch_array($sql)){
# 
#     $id = $row['ID'];
#     $fname = $row['FirstName'];
#     $lname = $row['LastName'];
#     $city = $row['City'];
#     $prov = $row['Province'];
# 
# ?>
# 
# <tr>
# <th><?php echo $id;?></th>
# <th><?php echo $fname;?></th>
# <th><?php echo $lname;?></th>
# <th><?php echo $city;?></th>
# <th><?php echo $prov;?></th>
# </tr>
# 
# <?php } //this ends the if?>
# 
# </table>
# </html>