PHP - Simple Database To Output?

I have 2 tables and am trying to conduct an SQL query. I simply need to know how to use a JOIN when two fields in each table are needed to match the records up. I would rather not create another field in each table.

I have put my query below which would work other than for what is obviously not possible ("ON xyz=xyz && abc=abc" etc.)

Table 1 "Employees"

employeeDept / deptEmployeeRef / name / wage

A / 2 / Dave Smith / 2000
B / 2 / Robert Brown / 2500


Table 2 "Deductions"

monthNo / employeeDept / deptEmployeeRef / deduction

32 / B / 2 / 300
32 / C / 2 / 300
32 / A / 3 / 300
33 / B / 2 / 500


Each department has employees starting from number 1 so two fields are needed in each table to match the records up.

SELECT t1.name, (t1.wage - t2.deduction) FROM $tableName1 AS t1 LEFT JOIN $tableName2 AS t2 ON t1.employeeDept=t2.employeeDept && t1.deptEmployeeRef=t2.deptEmployeeRef WHERE t2.monthNo = '32'

So this should return:
Dave Smith 2000
Robert Brown 2200

i have enters some data using form which submit data in sql table1 like this,

Fields name in table -->>         id   First name     Lastname    Date   
data saved           -->>              1  user                1               2011-05-10
                                               2  user                2               2011-05-11
                                               3  user                3               2011-05-12

now i dont want to duplicate date in database let say while inserting data using form,

Firstname :  ____________
Lasename :  ____________
Date         :  ____________ (i dont want this date to b save if the date alredy exist in database,
                                          it should prompt user "Date already exist and to edit click here
                                         (this will be the link to that date which is already exist so that we can edit) " )

                                SAVE


i user  files ,       form.php ,   insert.php(so insert values in database) ,
so tell me what function should i use to solve my problem....
 

This topic has been moved to MySQL Help.

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

Hey,

I'm trying to work out how I can have a simple script that will work like this:

Page 1 - Heading, Paragraph, Image read from database.
Page 2 - Has text boxes allowing you to change heading, paragraph and image (url) with each edit using a different text box. (Admin panel)

The database connection would be in a separate file.

So far I've got the database connection sorted.

Code: [Select]
<?php
//Database Information
$dbtype = "mysql"; 
$db_host = "localhost";
$db_user = "";
$db_pass = "";
$db_name = "";
$db_port = "";
$db_table_prefix = "userCake_";
?>
At the top of each of the other pages this is what I've got.
Code: [Select]
<?php 
require_once("models/config.php");
?>
Let's say I give each bit stored in the database a page ID and an object ID.

If the page selected is index.php how can we give it a page ID of 1 and give then include all the separate 'objects' throughout the page?

Hopefully this makes sense?

Cheers,
Jack

First time poster, and very amateur php coder.  I am trying to delete items that in a list using ajax.  I can't figure out what I am doing wrong.  Any help would be greatly appreciated!

 

Here is a snippet of my javascript...

    $('.delete-item').click(function() {
        var itemID = $(this).data('itemID');
        var clear = 1;
        $.ajax({
            url: 'includes/delete-item.php',
            method: 'POST',
            data: {
                itemid:itemID,
                clear:1
            },
            success: function(data) {
                $('.content').load('includes/lists.php')
            }
        })
    })

 

and here is the relevant php...

$item = $_POST['itemid'];
$clear = $_POST['clear'];
$clearSQL = "DELETE FROM `List_Items` WHERE `item_ID` = $item";
$cleared = mysqli_query($connect, $clearSQL);

I am trying to do something that a hell of a lot of people must need to do every day, yet despite this I can not find a single example online, or in books, which makes absolutely no sense!

Anyway, hopefully it will be blindingly obvious to someone what I'm doing wrong, I really hope so as I can't figure it out...

I have a mysl table as follows:

tblvenue

venue_id PRIMARY KEY (int)
venue_name (varchar 50)
station_id (int)

I have a php/html page as follows:

<html>
<head>
<title>Update & Delete Venues</title>
</head>
<body marginheight="0" topmargin="0" marginwidth="0"
leftmargin="0" style="margin:0;padding:0" bgcolor="#B0E0E6">
<h1></h1>

<form action="venue4.php" method="post">
<table border="1" style="border:solid black" cellpadding="0"
cellspacing="0" width="100%">
<tr>
<td align="center" width="33%">Action</td>
<td align="center" width="33%">Venue Name</td>
<td align="center" width="33%">Station Name</td>
</tr>
<?php

$station_name=$_POST['station_name'];

@ $db = new mysqli('XXX', 'XXX', 'XXX', 'XXX');
$query = "call sp_venue()";
$result = $db->query($query);
$num_results = $result->num_rows;

function db_result_to_array($result){
//---------------------------------------------------------------------
$res_array = array();

for ($count=0; $row = $result->fetch_assoc(); $count++) {
$res_array[$count]=$row;
}

return $res_array;
}
//---------------------------------------------------------------------



function get_dataset($server, $user, $password, $database, $query7) {
//---------------------------------------------------------------------
$db1 = new mysqli($server, $user, $password, $database);
$query1 = $query7;
$result1 = $db1->query($query1);
$num_results = $result1->num_rows;
$result8 = db_result_to_array($result1);
return $result8;}
//---------------------------------------------------------------------


   echo "<tr>";
   echo "<td>";
   echo "<table width='100%'><td width='33%' align='center'><input type='submit' id='btnupdate' name='btnupdate' value='Update & Delete' ></td>";
   echo "<td width='33%' align='center'><input type='submit' name='btncancel'id='btncancel' value='Cancel Updates' ></td>";
   echo "<td width='33%' align='center'><input type='submit' value='Add New Venue' name='btnadd'></td></table>";
   echo "</td>";
   echo "<td><input type='text' name='tbvenue_name'/></td>";
   echo "<td>";
?>
<select name="stat_id">
<?php
$stat_array=get_dataset('XXX', 'XXX', 'XXX', 'XXX',"call sp_station");
foreach ($stat_array as $thisstat){
echo "<option value=\"".$thisstat['station_id']."\"";
echo ">".$thisstat['station_name']."</option>";
}
?>
</select>
<?php
   echo "</td>";
   echo "</tr>";
   echo "<tr>";
while($row = $result->fetch_assoc())
   {
   echo "<td width='33%'>Delete:<input type='Checkbox' id='cbdelete[]'  name='cbdelete[]' value='".$row['venue_id'];
   echo "'>Update:<input type='Checkbox' id='value'  name='cbupdate[]' value='".$row['venue_id']."'><input type='hidden' name='venue_id[]' value='".$row['venue_id']."'></td>";
   echo "<td width='33%'><input type='Textbox' width='100%' name='venue_names' value='" .$row['venue_name']. "'></td>";
   echo "<td width='33%'>"  ;
   echo "<select name='station_id[]' width='100%'>";
$stat_array=get_dataset('localhost', 'root', 'snooker1', 'pool',"call sp_station");

foreach ($stat_array as $thiscat)
{
    echo '<option value="' . $thiscat['station_id'] . '"';
    if ($row['station_id'] == $thiscat['station_id']) {echo ' selected';}
    echo '>' . $thiscat['station_name'] . '</option>';
}



   echo "</td>";
   echo "</tr>";
   }
 echo "</table>";

?>


</form>
</body>
</html>

This displays correctly and when checking the appropriate checkbox and clicking the script venue4.php is run:

<?php

//Connects to the database
$db = new mysqli('XXX', 'XXX', 'XXX', 'XXX');

//Checks to see if the update button has been clicked
if (isset($_POST['btnupdate']))
{

//Assigns checkbox array to variable
$aDel = $_POST['cbdelete'];

$aVal = $_POST['cbupdate'];


//Loops through rows to delete selected records
foreach($_POST['cbdelete'] as $delete11)

{

//Deletes record
$query = "delete from tblvenue where venue_id =".$delete11;
$result = $db->query($query);
$num_results = $result->num_rows;
 
}



//Loops through rows to delete selected records
foreach($_POST['cbupdate'] as $update11)

{
//Gets variable


//$Venue = $_POST['venue_names'];

//Updates record
$query = "update tblvenue set venue_name=".$venue." where venue_id =".$update11;
$result = $db->query($query);
$num_results = $result->num_rows;
 
}

//Checks to see if Add button was clicked
} elseif (isset($_POST['btnadd'])) {

//Looks for Venue Name & Station Name
$tbvenue_name=$_POST['tbvenue_name'];
$tbstat_id=$_POST['stat_id'];

//Formats variables
if(!get_magic_quotes_gpc()) {
$tbvenue_name = addslashes($tbvenue_name);
$tbstat_id = addslashes($tbstat_id);
}

//Inserts new record
$query = "call sp_insert_venue('".$tbvenue_name."',".$tbstat_id.")";
$result = $db->query($query);

} elseif (isset($_POST['btnedit'])) {

switch($page) {
default:
include("venue2.php");
 break;
 }

} else {
//If cancel button is clicked, goes straight to switch code below

}

//Closes database connection
$db->close();

//Goes back to Venue page
switch($page) {
default:
include("venue.php");
 break;
 }

echo var_dump($aval);
print_r($aVal);

//$test = $_POST['cbupdate'];


?>

Deleting records works fine.
Inserting records works fine.
If I hard code the data (ie. set venue_name = 'blah blah blah')  for updates, I can get the relevant row id from cbupdate and update the row in question. However I can not get the data from venue2.php (typed into a textbox on the row in question) and submit this to the database to be updated.

This scenario must come up for zillions of developers, but so far no-one has been able to help.

Please can anyone assist...

shouldnt this add a ip address into my data base on row "login_ip"?
does putting that = sign between the two saying for it to add it?
I appreciate if anyone can help me with this

Code: [Select]
if(empty($row['login_ip'])){
       $row['login_ip'] = $_SERVER['REMOTE_ADDR'];}

I cant figure out why im having this problem.
i stuck this at the top of my page on its own and it wont update the row to read

Code: [Select]
<?php
mysql_query("UPDATE pm SET read= 'read' WHERE pm_id = '".mysql_real_escape_string($_GET['pm_id'])."'");
?>
I echo $_GET['pm_id']; and that turn out correct and the number matches the pm_id on the row.
everything is lowercase
I typed read manually into the column and echo that and it showed read
also I have this same exact line of code on another script that works fine.

does someone see something im over looking? this is driving me crazy


http://localhost/stargate/users/view.php?pm_id=1376672&inbox=2

Code: [Select]
<?php require("menu.php"); ?>

<html>
<body>
 

<?php
mysql_query("UPDATE pm SET read= 'read' WHERE pm_id = '".mysql_real_escape_string($_GET['pm_id'])."'");

?>



</body>
</html>

Hi All,

I am using the PHP Simple HTML DOM parser to connect to a financials website, parse out a companies financial information (Income statement in this case) and then insert the scrapped data into a mysql database that I can then later use to run automated calculations.

Here is the code I have so far:

Code: [Select]
<?php
include_once 'simple_html_dom.php';

//Connect to financial Website and Create DOM from URL
$income_statement = file_get_html('http://www.WEBSITE.com/finance?etc..etc...etc...etc...');

//PULL FINANCIAL DATA
foreach($income_statement->find('td[class]' ) as $lines=>$data) {

echo $data->plaintext . "<br/>";

}

// clean up memory
    $html->clear();
    unset($html);
?>

So far I am able to get output that looks like this:

Code: [Select]
Revenue
336.57
331.52
324.32
319.29
320.40
Other Revenue, Total
-
-
-
-
-
Total Revenue
336.57
331.52
324.32
319.29
320.40
etc.............................
But being a newb I do not understand how I can break each $ value and each - into their own variables and then insert them to their corresponding mysql table fields. During the database insert I would like to ignore field headings from insertion (i.e Revenue, Total Revenue, etc....

Any help would be absolutely amazing, as I have been reading, scripting and searching for information like crazy, but just can't seem to figure it out.

ugh... I'm a total PHP nub and I'm having trouble with:

Code: [Select]
$search_by = $_POST['search_by'];
$search = $_post['search'];

$dbc = mysqli_connect('xx', 'artofwarsomerset', 'xx', 'artofwarsomerset') or die ('Error connecting to MySQL server');

$query = "SELECT * FROM players WHERE '$search_by' = '$search' ";
$result = mysqli_query($dbc,$query)
  or die("Error: ".mysqli_error($dbc));

echo "<table><tr><td>Player</td><td>city</td><td>alliance</td><td>x</td><td>y</td><td>other</td><td>porters</td><td>conscripts</td><td>Spies</td><td>HBD</td><td>Minos</td><td>LBM</td><td>SSD</td><td>BD</td><td>AT</td><td>Giants</td><td>Mirrors</td><td>Fangs</td><td>ogres</td><td>banshee</td></tr>" ;

while ($row = mysqli_fetch_array ($result)) {
echo '<tr><td> $row['player'] </td>';
echo '<td> . $row['city']</td>';
echo '<td> . $row['alliance']</td>';
echo '<td> . $row['x']</td>';
echo '<td> . $row['y']</td>';
echo '<td> . $row['other']</td>';
echo '<td> . $row['porter']</td>';
echo '<td> . $row['cons']</td>';
echo '<td> . $row['spy']</td>';
echo '<td> . $row['hbd']</td>';
echo '<td> . $row['mino']</td>';
echo '<td> . $row['lbm']</td>';
echo '<td> . $row['ssd']</td>';
echo '<td> . $row['bd']</td>';
echo '<td> . $row['at']</td>';
echo '<td> . $row['giant']</td>';
echo '<td> . $row['fm']</td>';
echo '<td> . $row['ft']</td>';
echo '<td> . $row['ogre']</td>';
echo '<td> . $row['banshee']</td></tr></table>';  }
 ?>
Error shows up on line 35 but I'm not sure what I've done... Also, the xx's on my dbc statement were on purpose. Current error is: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/content/64/4940664/html/artofwar/browse.php on line 35, I can't figure out where the hell it wants a ;...

I am just new to relational algebra probably a pre-step before learning SQL queries. Can you help me make the expressions of relational algebra expression for each of the following queries. This is the table contained inside a bus driver database.

driver ( driver_id, driver_name, age, rating );
bus ( bus_id, bus_name, color);
reserves ( driver_id, bus_id, date);

a. Find the names of drivers who have reserved at least three busses. 
b. Find the names of drivers who have reserved all busses. 
c. Find the names of drivers who have reserved all busses called Shuttle. 
d. Find the IDs of drivers whose rating is better than some driver called Paul.   I would be grateful if somebody can help me here. 

Well I have a script that executes a scan on a system set to run infinitely, and I need it to echo out a message each time it loops through, but I don't want it to echo out the message with the next loop message below it, and the next one below that etc... I've tried using the flush(); function and been messing around with that with no luck. For security reasons I don't want to release any of the processing code, but here is the basic construction of the script:

<?PHP
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
$RepeatIt = -1;
for($g=1; $g!=$RepeatIt+1; $g++)
{
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***

$ScanMessage = ":.:.: SCANNING THE HITLIST FOR MOBSTER: ".$MobName." (SCAN #$g) :.:.:"."<br/><br/>";
echo $ScanMessage;

***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
}
?>

At the moment it's returning:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #1) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #2) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #3) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #4) :.:.:

So what I want it to do is just delete the scanning message and replace it with the next scan message so while running this script you would see just the number increment on the same line.

Any suggestions?

Thanks.

Hi i have this simple update form and scrip but somehow it doesnt seem to be update the field on the database can someone help out please.
The html form is the second form bellow where the action send to status_update.php
HTML FORM
Code: [Select]
<?php                include("../header.html");            ?>
<?php                include("header_news.html");            
extract($_REQUEST,EXTR_SKIP);
?><?php            
/*                print("sfilm_refnum = $sfilm_refnum<BR>");                
print("sfilm_addr01 = $sfilm_addr01<BR>");                
print("sfilm_postcode = $sfilm_postcode<BR>");                
print("Film Client = $fclient<BR>");            */             
?>           
<form id="search" action="list.php" method="post" name="search">               
<table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#eeeeee">                   
<tr>                       
<td align="right" width="140"></td>                       
<td width="320"><span class="hofblack10">                           
</span>                           
</td>                       
<td align="center" width="100"><input type="hidden" name="lstart" value="<?php print("$lstart"); ?>" /><input type="hidden" name="lend" value="<?php print("$lend"); ?>" /><input type="hidden" name="lamount" value="<?php print("$lamount"); ?>" /></td>                        <td align="center" width="100"></td>                       
<td align="right"></td>                   
</tr>               
</table>           
</form>           
<table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#4050c4">               
<tr>                 
<td width="60" class="hofwhite10">action</td>                   
<td width="140"><span class="hofwhite14">DATE</span></td>                   
<td width="80"><span class="hofwhite14">ID</span></td>                   
<td><span class="hofwhite14">News Titile</span></td>                   
<td width="100"><span class="hofwhite14">Status</span></td>               
</tr>               
<tr height="0">                 
<td bgcolor="white" width="60"></td>                   
<td bgcolor="white" width="140" height="0"></td>                   
<td bgcolor="white" width="80" height="0"></td>                   
<td bgcolor="white" height="0"></td>                   
<td bgcolor="white" width="100" height="0"></td>               
</tr>           
</table><table width="780" border="0" cellspacing="0" cellpadding="4"><tr>                   
<td width="60"></td>                 
<td width="80"></td>                   
<td><a class="blueullrg" href="add.php">Add News</a></td>                   
<td align="right" width="120"></td>               
</tr>               
<tr height="0">                   
<td width="60" height="0"></td>                 
<td width="80" height="0"></td>                   
<td height="0"></td>                   
<td align="right" width="120" height="0"></td>               
</tr>           
</table>  <?php          
//get the DB connection variables    
include("../../../includes/config.php");        
//connect to DB        
$connection = @mysql_connect($db_address,$db_username,$db_password) or die("Couldn't CONNECT.");        
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select DATABASE.");                
$query2="SELECT * FROM news WHERE !(news_status='deleted')";        
$result2 = mysql_query($query2) or die("Couldn't execute QUERY - Select NEWS Qty");        
$fqty = mysql_num_rows($result2);            
//SELECT or FIND the same USERNAME        
$query3="SELECT * FROM news WHERE !(news_status='deleted') ORDER BY news_id DESC";        
$result3 = mysql_query($query3) or die("Couldn't execute QUERY - Select NEWS");        
while ($row = mysql_fetch_array($result3))            
{                
$news_id                 = $row['news_id'];                
$news_title                = $row['news_title'];                
$news_story                = $row['news_story'];                
$news_image                = $row['news_image'];                
$news_image_caption        = $row['news_image_caption'];                
$news_image_link        = $row['news_image_link'];                
$news_date_day            = $row['news_date_day'];                
$news_date_month        = $row['news_date_month'];                
$news_date_year            = $row['news_date_year'];                
$news_status            = $row['news_status'];                
$news_website            = $row['news_website'];                
$news_date_created        = $row['news_date_created'];        
        $news_date_modified        = $row['news_date_modified'];    ?>           
        <table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#eeeeee">               
        <tr>                 
        <td width="60"><span class="hofblack10">                   
         <?php                    
         if($news_status=="deleted"){                        
         print("<a class='hifblack10'>deleted</span>");                    
         }ELSE{                        
         print("<a class='blueul' href='edit.php?id=$news_id'>edit</a>");                    
         }                    
         ?>                 
          </span></td>                   
          <td width="140"><span class="titlegrey12">                     
          <?php                      
          if(!$news_date_day) 
          { echo "00"; }
          else{ echo $news_date_day; }                      
          echo "/";                     
           if(!$news_date_month) { echo "00"; }else{ echo $news_date_month; }                      
           echo "/";                      
           if(!$news_date_year) { echo "0000"; }else{ echo $news_date_year; }                    
           ?>                   
           </span></td>                   
           <td width="80"><span class="titlegrey12"><?php                    print("$news_id");                    ?></span>
           </td>                   
           <td><?php                    
           if($news_status=="deleted")
           {                        
           print("<class='hofblack10'>$news_title</span>");                    
           }ELSE{                        
           print("<a class='blueul' href='edit.php?id=$news_id'>$news_title</a>");                    
           }                    
           ?></td>                   
           <td width="100">                       
           <form id="list_update" action="status_update.php" method="post" name="list_update">                           
        <select name="newnstatus" size="1">                               
           <option  <?php if($row['news_status'] == "") 
           {
            print("selected");
           } ?>
           selected="selected" value="">Status...</option>                               
           <option  <?php if($row['news_status'] == "on")
           {
            print("selected");
           } ?> value="on">On</option>
               <option  <?php if($row['news_status'] == "off")
           {
            print("selected");
           } ?> value="off">Off</option>
            <option  <?php if($row['news_status'] == "deleted")
           {
            print("selected");
           } ?> value="deleted">Delete</option>
        </select>
         <input type="hidden" name="nstatus" value="<?php echo $row[news_status]; ?>" />                           
           <input type="hidden" name="id" value="<?php echo $row[news_id]; ?>" />                       
           <input type="submit" name="update" value="update" />                       
           </form>                     
            </td>               
            </tr>               
            <tr height="0">                 
            <td bgcolor="white" width="60"></td>                   
            <td bgcolor="white" width="140" height="0"></td>                   
            <td bgcolor="white" width="80" height="0"></td>                   
            <td bgcolor="white" height="0"></td>                   
            <td bgcolor="white" width="100" height="0"></td>               
            </tr>           
            </table>
            <?php            }        mysql_close($connection);//}?>           
            <table width="780" border="0" cellspacing="0" cellpadding="4">         
            <tr>                   
            <td width="60"></td>                 
            <td width="80"></td>                   
            <td><a class="blueullrg" href="add.php">Add News</a></td>                   
            <td align="right" width="120"></td>               
            </tr>           
            </table><?php                // include("list_navigation.html");            ?>
            <?php                include("../footer.html");            ?>
            </div></body></html>
The action script php
Code: [Select]
<?php
/*    echo "fstatus: ".$fstatus."<BR>";    
echo "id: ".$id."<BR>";    
echo "fclient: ".$fclient."<BR>";    
echo "newfstatus: ".$newfstatus."<BR>";*/    
//set the date of agreement        
$timestamp = date('l jS \of F Y h:i:s A');    
//get the DB connection variables        
include("../../../includes/config.php");
//connect to DB        
$connection = @mysql_connect($db_address,$db_username,$db_password) or die("Couldn't CONNECT.");        
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select FILMS DATABASE.");    
// All appears well, so enter into database                
$query= "UPDATE news SET news_status = '$newnstatus' WHERE news_id='$id'";

$result = mysql_query($query) or die("could not execute query - Update FILMS Record to DB");    
//setup an email to the Admin @ hof, w/o attachment            
$emailto="xx@xxx.co.uk";        
$emailfrom="no-reply@xxxx.co.uk";        
$emailsubject="xx Record Updated";        
$emailmessage="Hello Registrar\n\n";        
$emailmessage.="News ID: ".$id."\n";        
$emailmessage.="Updated on: ".$timestamp."\n\n";        
$emailmessage.="Status was: ".$nstatus."\n";        
$emailmessage.="Status now: ".$newfnstatus."\n";        
$emailmessage.="Thank you,\n\n";        
$emailmessage.="Web Site ROBOT\n";        
$emailmessage.="(Administrator)\n";        
$emailmessage.="xxx.co.uk | xxx.biz\n";        
$emailmessage.="----------------------------------------------\n";        
$emailmessage.="e. http://www.xxx.co.uk/contact.php\n";        
$emailmessage.="w. http://www.xxx.co.uk\n";        
$emailheader="From: xxx.co.uk<$emailfrom>";
$emailheader  .= 'Cc: xxx@xxx.co.uk'."\r\n";
$emailheader  .= 'Bcc: xxx@xxxxx.co.uk'."\r\n";        
$ok=mail($emailto,$emailsubject,$emailmessage,$emailheader);        
mysql_close($connection);            
if ($ok)
 {        
 header("Location: list.php"); 
 /* Redirect browser */        
 exit;    
 } else {        
 $errmsg="There was a problem, please try later or telephone us direct.";        
 $errsta="1";        
 include("edit_error.html");        
 //echo "<p>Mail could not be sent. Sorry!</p>";        
 exit;    
 }        
 ?> Thanks in advance

I was wondering how to write something like this:

if (table1.column1 + table2.column2 > table3.column3  then .....

I am confused where to put ( ) and '

Hi everyone,

I'm trying to select either a class or an id using PHP Simple HTML DOM Parser with absolutely no luck.  My example is very simple and seems to comply to the examples given in the manual(http://simplehtmldom.sourceforge.net/manual.htm) but it just wont work, it's driving me up the wall.

Here is my example: http://schulnetz.nibis.de/db/schulen/schule.php?schulnr=94468&lschb=

I think the HTML is invalid: i cannot parse it.

Well i need more examples - probly i have overseen something!

If anybody has a working example of Simple-html-dom-parser...i would be happy.
The examples on the developersite are not very helpful.

your dilbertone