PHP - When Nothing Is Inputted To A Field An Error Occurs

Hello Everyone,

I have a PHP code that reads data from db table. Then it converts it into JSON and show it. However if data table field has - or so then it gives json error.

For e.g.

if($num > 0){
			while($res = mysqli_fetch_array($query)){
				
				$NDate = $res['NDate'];				
				$Summary = substr($res['Summary'],0,256);				
				
				/* CREATE ARRAY FOR SHORT TERM NEWSLETTER */
				$newsletters[]=array('newsletter'=>array("RecID"=>$SNo,"Summary"=>$Summary));
				
			}
			/* JSON OUTPUT*/
			$json = array("AuthOK" => 'True',"newsletters"=>$newsletters);
	
header('Content-type: application/json');
echo json_encode($json);

How to solve the issue ?

Regards,
GR

Hi there

I'm trying to insert audi files' records into mysql database this is how the records insertion looks like:

Code: [Select]
$fileName = $_FILES['uploaded']['name'];//name
$tmpName  = $_FILES['uploaded']['tmp_name'];//temp location
$fileSize = $_FILES['uploaded']['size'];//size of the file
$fileType = $_FILES['uploaded']['type'];//type of file
$error    = $_FILES['uploaded']['error'];//verifys errprs
$ext = substr($fileName, strrpos($fileName, '.') +1); //this will get the extention out of the file name e.g. .mp3



//check that a file is passed by and no errors
if(isset($fileName) && $error == 0 && $fileSize != 0){

//condition to accept only certain file types/extentions
if($ext == "mp3" || $ext == "wma" || $ext == "wav"){

//get file content
$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
   
}


        //query to retrieve user's id
        $userid = mysql_query("select userID from user where username = '$username'");
//to get id by username
$row = mysql_fetch_assoc($userid);
$userid = $row['userID'];

$query = "INSERT INTO tracks (trackName, userID, tag, price, file, fileName, fileSize, fileType)
    VALUES ('$tname','$userid','$tag','$price','$content','$fileName','$fileSize' , '$fileType)";
   
mysql_query($query) or die (mysql_error());

when i send it i get this error:  Unknown column 'application' in 'field list' i did set data type for the fileType field to varchar.  when i remove the fileType all together the record is inserted successfully  into database though. ?!! can anyone help please

This is my first real jump into PHP, I created a small script a few years ago but have not touched it since (or any other programming for that matter), so I'm not sure how to start this.

I need a script that I can run once a day through cron and take the date from one table/filed and insert it into a different table/field, converting the human readable date to a Unix date.

Table Name: Ads
Field: endtime_value (human readable date)

to

Table Name: Node
Field: auto_expire (Converted to Unix time)

Both use a field named "nid" as the key field, so the fields should match each nid field from one table to the next.  Following a tutorial I have been able to insert into a field certain data, but I don't know how to do it so the nid's match and how to convert the human readable date to Unix time.  Thanks in advance!.

Hi:
I'm going crazy trying to do the following:
I'm making a job registration process where the user registers on one php page to the website, must acknowlege and email receipt using an activate php page, then is directed to upload their C.V. (resume) based on the email address they enter in the active page output. I then run an upload page to store the resume in teh MySQL db based on the users email address in the same record.

If I isolate the process of the user registering to the db, it works perfectly.
If I isolate the file upload process into the db, it works perfect.
I simply cannot upload teh file to the existing record based on teh email form field matching the user_email field in the db.
With the processes together, teh user is activated, but teh file is not uploaded.

Maybe I've simply been at this too long today, but am compeled to get through it by end day.
If anyone can help sugest a better way or help me fix this, I will soo greatly appreciate it.

My code is as follows for the 2 pages.

---------activate.php-------
<?php
session_start();
include ('reg_dbc.php');
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
$rsCode = mysql_query("SELECT activation_code from subscribers where user_email='$_GET[usr]'") or die(mysql_error());
list($acode) = mysql_fetch_array($rsCode);
if ($_GET['code'] == $acode)
{
mysql_query("update subscribers set user_activated=1 where user_email='$_GET[usr]'") or die(mysql_error());
echo "<h3><center>Thank You! This is step 2 of 3. </h3>Your email is confirmed. Please upload your C.V. now to complete step 3.</center>";
} else
{ echo "ERROR: Incorrect activation code... not valid"; }

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Job application activation</title>
</head>
<body>
<center>
<br/><br/><br/>
<p align="center">
        <form name="form1" method="post" action="upload.php" style="padding:5px;">
        <p>Re-enter you Email : <input name="email" type="text" id="email"/></p></form>
          <form enctype="multipart/form-data" action="upload.php" method="POST">
          <input type="hidden" name="MAX_FILE_SIZE" value="4000000">
          Upload your C.V.: <input name="userfile" type="file" id="userfile">
          <input name="upload" type="submit" id="upload" value="Upload your C.V."/></form>
</p>
</center>
</body>

</html>
--------upload.php----------
<?php
session_start();
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$email = $_POST['email']['user_email'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}

include 'reg_dbc.php';

$query = "UPDATE subscribers WHERE $email = user_email (name, size, type, content ) ". "VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');
mysql_close($dbname);
}
?>
<center>
<br/>
<br/>
<br/>
<br/>
Thank you for uploading your <?php echo "$fileName"; ?> file, completing your registration, and providing us your C.V. for this position.
<br/>
<br/>
<br/>
We will contact you if your canditature qualifies.
</center>

(Another quite newbie...)
I have already an online booking form. The Form works fine now and I would like to add on one more issue, but the code ignores what I want to check. I have 4 fields: arrival, departure, no. of persons and comments to check.

Scenario 1:

All field mentioned above are emtpty: Workes fine and message appears: "You have not provided any booking details".

Scenario 2:

If arrival (date_start) and departure (date_end) is entered, there should be at least an entry either in the field "comment", or in the field "pax". If not, there should be a message: "You have not provided sufficient booking details".

INSTEAD: The booking request is sent, which should not be the case.

The code is currently:

      # all fields empty : arrival, departure, pax and comments - error

if(empty($data_start) && empty($data_end) && empty($pax)&& empty($comment)){
    exit("You have not specified any booking details to submit to us.
    <br>Please use your browser to go back to the form.
    <br>If you experience problems with this Form, please e-mail us");
    exit;
}
      #If arrival  and departure date is entered, there should be at least an entry

either in the field "comment", or in the field "pax".
      
if(!isset($data_start) && !isset($data_end) && empty($pax) && empty($comment)){
    exit("You have not provided sufficient booking details.
    <br>Please use your browser to go back to the form.
    <br>If you experience problems with this Form, please e-mail us");
    exit;
}

The form can be tested at http://www.phuket-beachvillas.com/contact-own/contact-it.php

Can someone please check and tell me what's wrong with the code ? Thanks to anyone for any hint.

Code: [Select]
$new_array2=array_diff($my_array,$itemIds);

$updatedb = mysql_query("UPDATE content_type_ads SET field_expire_value = '666' WHERE $new_array2 = field_item_id_value");
"$new_array2" has only 12 digit numbers for each item in the array, and I want to match them to the "field_item_id_value" field in the table, updating the "field_expire_value" field for the record where they match.  I know I am close because the UPDATE code works before I add the WHERE statement (it of course adds '666' to EVERY field, but for a noobie it's a start!).

Hi,
I'm developing an app using flash AS2 as the front end via PHP and a mySQL database at the backend on my server.

what i'm looking to do is update/insert into a table called 'cards' and at the same time update/insert into another table called 'jingle'. There is a field called 'cardID' in jingle that should be the same as the ID number created in 'cards' thus creating a link between entries in the different tables that can be called up as i choose.

hope i've been clear i just wouldn't know where to start any help would be appreciated.

MySQL client version: 5.0.91
PHPmyAdmin Version information: 3.2.4


thanks in advance

How should it look if I want to make a query where a field value should be lower than another field?

Code: [Select]
....WHERE total_points<max_points");

I am a new developer, trying to figure out what causing a memory error. The code goes through registered appointments and depends on the service ID, I have to free a 45 minutes for another service to be booked. Now, once I book an appointment for any of the services that can have 45 minutes free spot, the website takes forever to load the hours but doesn't show them, instead I get this error

A PHP Error was encountered Severity: Error Message: Maximum execution time of 120 seconds exceeded

 

 

foreach ($appointments as $appointment) { foreach ($periods as $index => &$period) { $appointment_start = new DateTime($appointment['start_datetime']); $appointment_end = new DateTime($appointment['end_datetime']); if ($appointment_start >= $appointment_end) { continue; } $period_start = new DateTime($date . ' ' . $period['start']); $period_end = new DateTime($date . ' ' . $period['end']); $serviceId=$appointment['id_services']; $color1=1; $color2=2; $color3=3; $color4=4; $color5=5; $color6=6; $color7=7; $color8=8; $color9=9; $color10=10; $color11=11; $color12=12; $color13=13; $color14=14; $color15=15; $color16=16; $color17=17; $color18=18; $color19=19; $period_s=''; $period_e=''; if ($appointment_start <= $period_start && $appointment_end <= $period_end && $appointment_end <= $period_start) { // The appointment does not belong in this time period, so we will not change anything. continue; } else { if ($appointment_start <= $period_start && $appointment_end <= $period_end && $appointment_end >= $period_start) { // The appointment starts before the period and finishes somewhere inside. We will need to break // this period and leave the available part. //open slot for services 45,45,45 if($serviceId == $color1 || $serviceId == $color3 || $serviceId == $color7 || $serviceId == $color9|| $serviceId == $color10 || $serviceId == $color11 || $serviceId == $color12){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } //Open slot for service 45,45,60 else if($serviceId == $color2 || $serviceId == $color8){ $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } // // //Open slot for service 30,45,45 else if($serviceId == $color4 || $serviceId == $color6 ||$serviceId == $color16 || $serviceId == $color18){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } // // //Open slot for service 30,45,60 else if($serviceId == $color5 || $serviceId == $color17){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } // // //Open slot for service 60,45,45 else if($serviceId == $color13 || $serviceId == $color15){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } // // //Open slot for service 60,45,60 else if($serviceId == $color14 ){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } // //for the rest of services else { $period['start'] = $appointment_end->format('H:i');} } else { if ($appointment_start >= $period_start && $appointment_end < $period_end) { // The appointment is inside the time period, so we will split the period into two new // others. unset($periods[$index]); if($serviceId == $color1 || $serviceId == $color3 || $serviceId == $color7 || $serviceId == $color9|| $serviceId == $color10 || $serviceId == $color11 || $serviceId == $color12){ $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } // //Open slot for service 45,45,60 else if($serviceId == $color2 || $serviceId == $color8){ $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } // // //Open slot for service 30,45,45 else if($serviceId == $color4 || $serviceId == $color6 ||$serviceId == $color16 || $serviceId == $color18){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } // // //Open slot for service 30,45,60 else if($serviceId == $color5 || $serviceId == $color17){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } // // //Open slot for service 60,45,45 else if($serviceId == $color13 || $serviceId == $color15){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } // // //Open slot for service 60,45,60 else if($serviceId == $color14 ){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } //for other services once The code is completely correct else{ $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } } else if ($appointment_start == $period_start && $appointment_end == $period_end) { if($serviceId == $color1 || $serviceId == $color3 || $serviceId == $color7 || $serviceId == $color9|| $serviceId == $color10 || $serviceId == $color11 || $serviceId == $color12){ unset($periods[$index]); $period_s= $appointment_start; $period_s->modify('+45 minutes'); $period_e= $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } //Open slot for service 45,45,60 else if($serviceId == $color2 || $serviceId == $color8){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // // //Open slot for service 30,45,45 else if($serviceId == $color4 || $serviceId == $color6 ||$serviceId == $color16 || $serviceId == $color18){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // // //Open slot for service 30,45,60 else if($serviceId == $color5 || $serviceId == $color17){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // // //Open slot for service 60,45,45 else if($serviceId == $color13 || $serviceId == $color15){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // // //Open slot for service 60,45,60 else if($serviceId == $color14 ){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ];} // //for the rest of services else { unset($periods[$index]);} // The whole period is blocked so remove it from the available periods array. } else { if ($appointment_start >= $period_start && $appointment_end >= $period_start && $appointment_start <= $period_end) { // The appointment starts in the period and finishes out of it. We will need to remove //the time that is taken from the appointment. if($serviceId == $color1 || $serviceId == $color3 || $serviceId == $color7 || $serviceId == $color9|| $serviceId == $color10 || $serviceId == $color11 || $serviceId == $color12){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $period['end'] = $appointment_start->format('H:i'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } //Open slot for service 45,45,60 else if($serviceId == $color2 || $serviceId == $color8){ $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $period['end'] = $appointment_start->format('H:i'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // // //Open slot for service 30,45,45 else if($serviceId == $color4 || $serviceId == $color6 ||$serviceId == $color16 || $serviceId == $color18){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['end'] = $appointment_start->format('H:i'); } // // //Open slot for service 30,45,60 else if($serviceId == $color5 || $serviceId == $color17){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['end'] = $appointment_start->format('H:i'); } // // //Open slot for service 60,45,45 else if($serviceId == $color13 || $serviceId == $color15){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['end'] = $appointment_start->format('H:i'); } // // //Open slot for service 60,45,60 else if($serviceId == $color14 ){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['end'] = $appointment_start->format('H:i'); } // for the rest of services else{ $period['end'] = $appointment_start->format('H:i'); } } else { if ($appointment_start >= $period_start && $appointment_end >= $period_end && $appointment_start >= $period_end) { // The appointment does not belong in the period so do not change anything. continue; } else { if ($appointment_start <= $period_start && $appointment_end >= $period_end && $appointment_start <= $period_end) { //Open slot for service 45,45,45 if($serviceId == $color1 || $serviceId == $color3 || $serviceId == $color7 || $serviceId == $color9|| $serviceId == $color10 || $serviceId == $color11 || $serviceId == $color12){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } //Open slot for service 45,45,60 else if($serviceId == $color2 || $serviceId == $color8){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // //Open slot for service 30,45,45 else if($serviceId == $color4 || $serviceId == $color6 ||$serviceId == $color16 || $serviceId == $color18){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ];} //Open slot for service 30,45,60 else if($serviceId == $color5 || $serviceId == $color17){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ];} // // //Open slot for service 60,45,45 else if($serviceId == $color13 || $serviceId == $color15){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ];} // // //Open slot for service 60,45,60 else if($serviceId == $color14 ){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ];} else{ unset($periods[$index]); } } } } } } } } } return array_values($periods); }

Hello all,   Appreciate if you folks could pls. help me understand (and more importantly resolve) this very weird error:     Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC, purchase_later_flag ASC, shopper1_buy_flag AS' at line 3' in /var/www/index.php:67 Stack trace: #0 /var/www/index.php(67): PDO->query('SELECT shoplist...') #1 {main} thrown in /var/www/index.php on line 67   Everything seems to work fine when/if I use the following SQL query (which can also be seen commented out in my code towards the end of this post) :  

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
           FROM shoplist, store_master, item_master
           WHERE     shoplist.store_id = store_master.store_id
                   AND shoplist.item_id = item_master.item_id";

  However, the moment I change my query to the following, which essentially just includes/adds the ORDER BY clause, I receive the error quoted above:

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name 
		FROM shoplist, store_master, item_master 
		ORDER BY purchased_flag ASC, 
				purchase_later_flag ASC, 
				shopper1_buy_flag ASC, 
				shopper2_buy_flag ASC, 
				store_name ASC) 
		WHERE 	shoplist.store_id = store_master.store_id 
				AND shoplist.item_id = item_master.item_id";

In googling for this error I came across posts that suggested using "ORDER BY FIND_IN_SET()" and "ORDER BY FIELD()"...both of which I tried with no success.   Here's the portion of my code which seems to have a problem, and line # 67 is the 3rd from bottom (third last) statement in the code below:  

                    <?php
                        /*
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        */
                    
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                ORDER BY FIND_IN_SET(purchased_flag ASC,
                                                 purchase_later_flag ASC,
                                                 shopper1_buy_flag ASC,
                                                 shopper2_buy_flag ASC,
                                                 store_name ASC)
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        $result = $pdo->query($sql);                        
                        
                        // foreach ($pdo->query($sql) as $row) {
                        foreach ($result as $row) {
                            echo '<tr>';
                                print '<td><span class="filler-checkbox"><input type="checkbox" name="IDnumber[]" value="' . $row["idnumber"] . '" /></span></td>';

    Thanks  

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\mywork\unique.php on line 15


<html>
<head>
<title>

</title>
</head>
<body bgproperties="fixed">
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$con = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'mywork';
mysql_select_db($dbname, $con);
$sql=mysql_query(insert into users (regno,name,gender,date,month,year,emailid,cell,paddress,caddress,incometype,incomeamt,dad,fyes,dadocup,mom,myes,momocup,password) VALUES ('$_POST[regno]','$_POST[name]','$_POST[gender]','$_POST[date]','$_POST[month]','$_POST[year]','$_POST[emailid]','$_POST[cell]','$_POST[paddress]','$_POST[caddress]','$_POST[incometype]','$_POST[incomeamt]','$_POST[dad]','$_POST[fyes]','$_POST[dadocup]','$_POST[mom]','$_POST[myes]','$_POST[momocup]','$_POST[password]')");
$sql1=mysql_fetch_array($sql);
$result = @mysql_query($SQl1);
$result="SELECT * FROM users WHERE regno='$regno'";
while($row = mysql_fetch_array($result))
{
    //echo $row['regno']."regno<br>";
//echo $row['name']."name<br>";
//echo $row['gender']."gender<br>";
//echo $row['date']."date<br>";
//echo $row['month']."month<br>";
//echo $row['year']."year<br>";
//echo $row['emailid']."emailid<br>";
//echo $row['cell']."cell<br>";
//echo $row['paddress']."paddress<br>";
//echo $row['caddress']."caddress<br>";
//echo $row['incometype']."incometype<br>";
//echo $row['incomeamt']."incomeamt<br>";
//echo $row['dad']."dad<br>";
//echo $row['fyes']."fyes<br>";
//echo $row['dadocup']."dadocup<br>";
//echo $row['mom']."mom<br>";
//echo $row['myes']."myes<br>";
//echo $row['momocup']."momocup<br>";
//echo $row['password']."password<br>";

}
echo "Thanks for Register!";
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";
mysql_close($con);
?>
<form name="security" action="index.php" method="post">

<input type="submit" value="click here to login">
</form>
</body>
</html>

Hey guys,

I am a webmaster for my church and I am fairly new to PHP. What am trying to is when a visitor goes to our radio ministry page and clicks a button which the message number is displayed in the read only textbox, it will go to my request CD page and auto populate the message number in that text field form the readonly text field from the previous page. I will show my code for both pages for you to review.



This is the Radio page (where I want to take the message number value from)
Code: [Select]
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="Living Word Community Church radio ministry" />
    <meta name="keywords" content="reformed radio fort worth, reformed radio dallas, biblical radio fort worth, biblical radio dfw"  />
    <title>In Light of Scripture-Radio Ministry</title>
    <link href="_css/Main.css" rel="stylesheet" type="text/css" />
    <script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>

    <link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
    </head>

    <body>

    <div class="container">
    <div class="header"><a href="index.php"><img src="_images/LWCCWeb.jpg" alt="Insert Logo Here" name="Insert_logo" width="960" height="200" id="Insert_logo" style="background: #D8BF78; display:block;" /></a>
       <?php include("_includes/header.php"); ?>
    <div class="sidebar1">
        <p></p>
         <table width="150" border="0" cellpadding="10" align="left">
      <tr>
        <td><a href="directions.php"><img src="_images/ChurchBox.png" width="150" height="125" alt="Directions" /></a></td>
      </tr>
      <tr>
        <td><img src="_images/Service Times.png" width="150" height="778" alt="Service Times" /></td>
      </tr>
    </table>

        <!-- end .sidebar1 --></div>
     
    <div class="content">
       <div id="radio"></div>
        <table width="600" border="0" cellpadding="10">
      <tr>
        <td><img src="_images/ILOS.png" width="600" height="111" alt="In Light of Scripture" /></td>
        </tr>
         <tr>
             <td style=" padding-top:25px"><p><font size="5"><b>In Light of Scripture</b> has been locally broadcast for more
             than 25 years.<br />
              This Sunday morning radio program features the expositional teaching of Pastor Stan McGehee Jr.
             </font><p/></td>
          </tr>
       
        </table>
       
        <div id="mediagraph"><a href="http://kdkr.org" target="_blank"><img src="_images/kdkr.jpg" width="300" height="200" alt="Braodcast on KDKR 91.3 Sunday   
           Mornings at 7:30" /></a></div>
           
            <br  /><br  />
            <font size="2"><p align="center"><b>The sermon featured this week on "In Light of Scipture" is</b></p></font>
            <font size="2"><p align="center" style="color:#711726"><b><i>Peace Despite Tribulation</i></b></p></font>
            <div id="messagenumber" align="center">
            <form action="" method="get" name="messagenumber">
            <input name="" type="text" value="JR-843" size="6" readonly="readonly" />
            <input name="GetMessage" type="button" value="Get Message" />
            </form>
            </div>
        <!-- end .content --></div></div>
      <div class="sidebar2">
        <table width="150" border="0" cellpadding="16" align="left">
          <tr>
            <td><a href="reformation.php"><img src="_images/MenuBox1.png" width="150" height="125" alt="What Do We Mean by Reformed?" /></a></td>
          </tr>
          <tr>
            <td><a href="ServiceTimesAndCal.php"><img src="_images/MenuBox2.png" width="150" height="125" alt="Worship Service Schedule and Calendar" /></a></td>
          </tr>
          <tr>
            <td><a href="radio.php"><img src="_images/MenuBox3.png" width="150" height="125" alt="In Light of Scripture Radio Ministry" /></a></td>
          </tr>
          <tr>
            <td><a href="cable.php"><img src="_images/MenuBox4.png" width="150" height="125" alt="Living Word Today Cable Program" /></a></td>
          </tr>
          <tr>
            <td><a href="Sermons.php"><img src="_images/MenuBox5.png" width="150" height="125" alt="Listen to Sermons Online" /></a></td>
          </tr>
           <tr>
              <td><a href="http://www.lwcchurch.org/blog/" target="_blank"><img src="_images/MenuBox6.png" width=
               "150" height="125" alt="Read our reformed blog" /></a></td>
          </tr>
        </table>
       
        <!-- end .sidebar2 --></div>
        <?php include("_includes/footer.php"); ?>
      <!-- end .container --></div>
      <script type="text/javascript">
    var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    var MenuBar2 = new Spry.Widget.MenuBar("MenuBar2", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    </script>
    </body>
    </html>

This is for the CD request form. I want it to populate the Message# text field

    Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="Order Living Word Community Church sermons and teachings on CD" />
    <meta name="keywords" content="Stan McGehee cd, Reformed teachings on cd, Biblical teachings on cd, LWCC cds"  />
    <title>Order CD's Online</title>
    <link href="_css/Main.css" rel="stylesheet" type="text/css" />
    <link href="js/jquery.datepick.css" rel="stylesheet" type="text/css" />
    <script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
    <script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
    <link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" src="jquery/jquery-1.5.js"></script>
    <script type="text/javascript" src="js/jquery.datepick.js"></script>
    <script src="SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
    <script src="SpryAssets/SpryValidationRadio.js" type="text/javascript"></script>
    <link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript">
       $(function() {
       $('#popupDatepicker').datepick();
       $('#inlineDatepicker').datepick({onSelect: showDate});
    });

    function showDate(date) {
       
    }

       </script>



    <link href="SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
    <link href="SpryAssets/SpryValidationRadio.css" rel="stylesheet" type="text/css" />
    </head>

    <body>

    <div class="container">
    <div class="header"><a href="index.php"><img src="_images/LWCCWeb2.png" alt="Insert Logo Here" name="Insert_logo" width="960" height="200" id="Insert_logo" style="background: #D8BF78; display:block;" /></a>
       <?php include("_includes/header.php"); ?>
       
    <div class="sidebar1">
        <p></p>
         <table width="150" border="0" cellpadding="10" align="left">
      <tr>
        <td><a href="directions.php"><img src="_images/ChurchBox.png" width="150" height="125" alt="Directions" /></a></td>
      </tr>
      <tr>
        <td><img src="_images/Service Times.png" width="150" height="890" alt="Service Times" /></td>
      </tr>
    </table>

        <!-- end .sidebar1 --></div>
     
    <div class="content">
       &nbsp;
       <h2 style="padding-left:50px"> Order messages on CD from LWCC</h2>
       <div id"form">
       
        <form action="FormToEmail2.php" method="post">

       


        <table width="550" border="0" cellpadding="10">
         <tr>
           <td><table width="550" border="0" cellpadding="10">
      <tr>
        <td width="190">First Name:</td>
        <td width="314"><span id="spryfirstname">
        <input name="firstname" type="text" id="firstname" maxlength="20" />
        <span class="textfieldMaxCharsMsg">Too many letters</span><span class="textfieldRequiredMsg">Enter first name </span></span></td>
      </tr>
      <tr>
        <td>Last Name:</td>
        <td><span id="sprylastname">
        <input name="lastname" type="text" id="lastname" maxlength="20" />
        <span class="textfieldRequiredMsg">Enter last name</span><span class="textfieldMaxCharsMsg">Too many letters</span></span></td>
      </tr>
      <tr>
       <td>Email<font size="2"> (So we can confirm if needed)</font>:</td>
        <td><span id="spryemail">
        <input name="email" type="text" id="email" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too long</span></span></td>
      </tr>
      <tr>
       <td>Street:</td>
        <td><span id="sprystreet"><span id="sprystreet">
        <input name="street" type="text" id="street" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter Street Address</span><span class="textfieldMaxCharsMsg">Exceeded maximum number of characters.</span></span></td>
      </tr>
      <tr>
       <td>City:</td>
        <td><span id="sprycity"><span id="sprytextfield5">
        <input name="City" type="text" id="city" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter your city</span><span class="textfieldMaxCharsMsg">Exceeded maximum number of characters.</span></span><span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too lon</span></span></td>
      </tr>
       <tr>
       <td>Apartment number:</td>
        <td><span id="aptnum">
        <input name="Apt number" type="text" id="aptnum" maxlength="6" width="80px" />
        <span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too long</span></span></td>
      </tr>
      <tr>
       <td>State:</td>
        <td><span id="spryselect1">
          <select name="statelist">
            <option value="null"></option>
            <option value="Alabama">AL</option>
            <option value="Alaska">AK</option>
            <option value="Arkansas">AR</option>
            <option value="Arizona">AZ</option>
            <option value="California">CA</option>
            <option value="Colorado">CO</option>
            <option value="Connecticut">CT</option>
            <option value="Deleware">DE</option>
            <option value="District of Columbia">DC</option>
            <option value="Florida">FL</option>
            <option value="Georgia">GA</option>
            <option value="Hawaii">HI</option>
            <option value="Idaho">ID</option>
            <option value="Iowa">IA</option>
            <option value="Illinois">IL</option>
            <option value="Indiana">IN</option>
            <option value="Kansas">KS</option>
            <option value="Kentucky">KY</option>
            <option value="Louisiana">LA</option>
            <option value="Massachusetts">MA</option>
            <option value="Maryland">MD</option>
            <option value="Maine">ME</option>
            <option value="Michigan">MI</option>
            <option value="Minnesota">MN</option>
            <option value="Missouri">MO</option>
            <option value="Mississippi">MS</option>
            <option value="Montana">MT</option>
            <option value="Nebraska">NE</option>
            <option value="New Hampshire">NH</option>
            <option value="New Jersey">NJ</option>
            <option value="New Mexico">NM</option>
            <option value="Nevada">NV</option>
            <option value="New York">NY</option>
            <option value="North Carolina">NC</option>
            <option value="North Dakota">ND</option>
            <option value="Ohio">OH</option>
            <option value="Oklahoma">OK</option>
            <option value="Oregon">OR</option>
            <option value="Pennslyvania">PA</option>
            <option value="Rhode Island">RI</option>
            <option value="South Carolina">SC</option>
            <option value="Tennessee">TN</option>
            <option value="Texas">TX</option>
            <option value="Utah">UT</option>
            <option value="Vermont">VT</option>
            <option value="Virginia">VA</option>
            <option value="Washington">WA</option>
            <option value="Wisconsin">WI</option>
            <option value="West Virginia">WV</option>
            <option value="Wyoming">WY</option>
          </select>
          <span class="selectRequiredMsg">Please select state</span></span></td>
      </tr>
      <tr>
       <td>Zip Code:</td>
        <td><span id="spryzip"><span id="sprytextfield6">
        <input name="Zip Code" type="text" id="zip" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter Zip Code</span><span class="textfieldInvalidFormatMsg">Zip Code is 5 numbers.</span></span><span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too lo</span></span></td>
      </tr>
      <tr>
        <td>Which Pastor or Teacher?</td>
        <td>
          <div id="spryradio1">
            <table width="250">
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Pastor Stan McGehee" id="radiogroup_4" />
                  Pastor Stan McGehee Sr</label></td>
              </tr>
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Pastor Stan McGehee Jr" id="radiogroup_5" />
                  Pastor Stan McGehee Jr</label></td>
              </tr>
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Pastor Jack McFarland" id="radiogroup_6" />
                  Pastor Jack McFarland</label></td>
              </tr>
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Steve Bader" id="radiogroup_7" />
                  Steve Bader</label></td>
              </tr>
            </table>
            <span class="radioRequiredMsg">Please select speaker</span></div></td>
      </tr>
      <tr>
      <td>Where did you hear message?</td>
      <td>
         <div id="spryradio2">
           <table width="200">
             <tr>
               <td><label>
                 <input type="radio" name="How did you hear?" value="At LWCC" id="RadioGroup1_0" />
                 At our church</label></td>
             </tr>
             <tr>
               <td><label>
                 <input type="radio" name="How did you hear?" value="On the Radio" id="RadioGroup1_1" />
                 On the Radio</label></td>
             </tr>
             <tr>
               <td><label>
                 <input type="radio" name="How did you hear?" value="On Cable" id="RadioGroup1_2" />
                 On Cable</label></td>
             </tr>
           </table>
           <span class="radioRequiredMsg">Please make a selection</span></div></td>
      </tr>
      <tr>
       <td>What service?</td>
        <td><div id="spryradio3">
          <table width="248">
            <tr>
              <td width="240"><label>
                <input type="radio" name="When did you hear message?" value="Sunday AM" id="When did you hear message?_0" />
                Sunday AM</label></td>
            </tr>
            <tr>
              <td><label>
                <input type="radio" name="When did you hear message?" value="Sunday PM" id="When did you hear message?_1" />
                Sunday PM</label></td>
            </tr>
            <tr>
              <td><label>
                <input type="radio" name="When did you hear message?" value="Wednesday PM" id="When did you hear message?_2" />
                Wednesday PM</label></td>
            </tr>
            <tr>
              <td><label>
                <input type="radio" name="When did you hear message?" value="Adult Sunday School" id="When did you hear message?_3" />
                Adult Sunday School</label></td>
            </tr>
          </table>
          <span class="radioRequiredMsg">Please make a selection.</span></div></td>
        </tr>
      <tr>
        <td>Message Number <font size="2">(If known)</font>: </td>
        <td><input name="Message#" type="text" id="messagenumber" maxlength="50" /></td>
      </tr>
            </table>

    </td>
           </tr>
         <tr>
           <td><table width="550" border="0" cellpadding="10">
               <h3 style="padding-left:135px">Please pick date of message</h3>
                <div id="selectdate" align="center"><input id="inlineDatepicker" name="When Did You Hear?" type="text" /></div>
             
               

                <script type="text/javascript">

             var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
    document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
    </script>
    <script type="text/javascript">
    var pageTracker = _gat._getTracker("UA-4715900-1");
    pageTracker._initData();
    pageTracker._trackPageview();

    </script></table></td>

     
      <tr>
        <td style="padding-left:250px"><input name="submit" value="Submit" type="submit" />&nbsp;&nbsp;<input name="clearBtn" type="reset" /></td>
       
      </tr>
    </table>
    </td>
           </tr>
         </table>
       

        </form></div>
      <!-- end .content --></div></div>
      <div class="sidebar2">
        <table width="150" border="0" cellpadding="25" align="left">
          <tr>
            <td><a href="reformation.php"><img src="_images/MenuBox1.png" width="150" height="125" alt="What Do We Mean by Reformed?" /></a></td>
          </tr>
          <tr>
            <td><a href="ServiceTimesAndCal.php"><img src="_images/MenuBox2.png" width="150" height="125" alt="Worship Service Schedule and Calendar" /></a></td>
          </tr>
          <tr>
            <td><a href="radio.php"><img src="_images/MenuBox3.png" width="150" height="125" alt="In Light of Scripture Radio Ministry" /></a></td>
          </tr>
          <tr>
            <td><a href="cable.php"><img src="_images/MenuBox4.png" width="150" height="125" alt="Living Word Today Cable Program" /></a></td>
          </tr>
          <tr>
            <td><a href="Sermons.php"><img src="_images/MenuBox5.png" width="150" height="125" alt="Listen to Sermons Online" /></a></td>
          </tr>
           <tr>
              <td><a href="http://lwcchurch.blogspot.com" target="_blank"><img src="_images/MenuBox6.png" width="150" height="125" alt="Read our reformed blog" /></a></td>
          </tr>
        </table>
       
        <!-- end .sidebar2 --></div>
       <?php include("_includes/footer.php"); ?>
      <!-- end .container --></div>
    <script type="text/javascript">
    var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    var MenuBar2 = new Spry.Widget.MenuBar("MenuBar2", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    var sprytextfield1 = new Spry.Widget.ValidationTextField("spryfirstname", "none", {validateOn:["blur"], maxChars:20});
    var sprytextfield2 = new Spry.Widget.ValidationTextField("sprylastname", "none", {maxChars:20, validateOn:["blur"]});
    var sprytextfield3 = new Spry.Widget.ValidationTextField("spryemail", "email", {maxChars:50, validateOn:["blur"]});
    var sprytextfield4 = new Spry.Widget.ValidationTextField("sprystreet", "none", {validateOn:["blur"], maxChars:50});
    var sprytextfield5 = new Spry.Widget.ValidationTextField("sprytextfield5", "none", {maxChars:50, validateOn:["blur"]});
    var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1", {validateOn:["blur"]});
    var sprytextfield6 = new Spry.Widget.ValidationTextField("sprytextfield6", "zip_code", {validateOn:["blur"]});
    var spryradio1 = new Spry.Widget.ValidationRadio("spryradio1");
    var spryradio2 = new Spry.Widget.ValidationRadio("spryradio2");
    var sprytextfield7 = new Spry.Widget.ValidationTextField("sprymessagenumber", "none", {isRequired:false});
    var spryradio3 = new Spry.Widget.ValidationRadio("spryradio3");
    </script>
    </body>
    </html>

Code: [Select]
<?php
mysql_connect ("-","-","-") or die ('Error');
mysql_select_db ("-");

$out = mysql_query("SELECT * FROM guestbook ORDER BY id DESC");

while($row = mysql_fetch_assoc($out); --and this one if that braces is deleted
{ ----this is where im getting the error
$name = $row['name'];
$email = $row['email'];
$txt = $row['comment'];

        $msg = "Are you sure you want to delete";

/* @var $_REQUEST <type> */
if (isset($_REQUEST ["action"]) && $_REQUEST["action"] == "del") 
    {
                    $id = intval($_REQUEST['id']);
                    mysql_query("DELETE FROM guestbook WHERE id=$id;");
                   echo "<action=index.php>";
                }

echo "<font face='verdana' size='1'>";
echo "<table border='0'>
<tr><td>Name: ".$name."</td></tr>"."
<tr><td>Email: ".$email."</td></tr>
<tr><td colspan='2'>Comment:</td></tr>
<tr><td colspan='2' width='500'><b>".$txt."</b></td></tr>
                     <tr><td><a onclick=\"return confirm('.$msg.');\" href='index.php?action=del&amp;id=".$row['id']."'><span class='red'>["."Delete"."]</span></a>
                        </td></tr>
  </table><br />";


echo "<hr size='1' width='500' align='left'></font>";
}
?>

Kindly help me please. When i delete ({) the error will become the ( i dont know what to do already. Thanks.

Is it possible to have a text field on my site, and the text that is entered into it, be given to another site that I auto redirect the user to?

If it is possible, could somebody give me the exact code (I'm not a programmer) I would need to use?

Thanks for any help on this.