Learn VBA & Macros in 1 Week!

PHP - Erm...text / Textarea Query...not As Simple As I Thought...

Full Excel VBA Course - Beginner to Expert

Erm...text / Textarea Query...not As Simple As I Thought...	View Content

Hi,

very simple i'm sure... i have a code for a text box to pull info into from a mysql table. easy enough:

Code: [Select]
<?php echo "<input type=\"text\" id=\"b_info\" name=\"b_info\" value=\"$b_info\" style=\"width: 327px\" /text>"; ?>

but suppose i dont just want a "line of text" i want one of those boxes with the scroll bar down the side (lol like the one im writing this in ) how do i change the above code to do it?

i though doing this:
Code: [Select]
<?php echo "<input type=\"textarea\" id=\"b_info\" name=\"b_info\" value=\"$b_info\" style=\"width: 327px\" style=\"height: 185px\" /textarea>"; ?>

would work, but obviously not, all ive done is make the box bigger

easy workaround?

Thanks

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Simple Attatchment Fix?? ...or So I Thought!

Simple Script... Or So I Thought

How To Query Pre Tags Into A Textarea?

Returns/new Lines In Textarea Text?

Save Textarea's Text As A Downloadable .txt File

Alert Textarea Text When Pressing Return Key

Help With Thought Process!

How To Insert Two Input Values And Multi Data Textarea Values In One Query?

Font Tester - I Thought I Had It.

I Thought It Was Solved. Not So! Insert/update

15 Seconds Of Thought And I Don't Know What To Call The Subject. Sorry

Help With A Simple Query.

Simple Query Not Working...

This Simple Query Is Broke Lol

Problem With What Should Be A Simple Query

Simple Mysql Query. Help

Simple Query Not Working...

Simple Insert Query Error

Moved: Sql Query And Simple Add Maths

Learn VBA & Macros for Excel in 1 Week!

Simple Attatchment Fix?? ...or So I Thought!

Similar Tutorials

Was just wondering if anyone could help out with what should be a fairly simple fix for a contact form with image upload.

The image DOES get uploaded to the temporary folder, but doesn't appear when I receive the email into my account.

I think the form is almost good to go, just can't figure out why the image is not attatched to the email when i receive it - guessing the problem is somewhere in the last 10 lines of code.

Really appreciate if someone could figure what's I'm doing wrong. (...perhaps it was thinking I could learn PHP in the first place!).

Thanks.

Code: [Select]
<?php

ini_set("sendmail_from", "darren@mywebsite.co.uk");
ini_set("SMTP", "smtp.myhostingcompany.co.uk");

if($name = filter_var($_POST['name']))
if($address = filter_var($_POST['address']))
if($postcode = filter_var($_POST['postcode']))
if($phone = filter_var($_POST['phone']))
if($email = filter_var($_POST['email']))
if($details = filter_var($_POST['details']))
if($contactby = filter_var($_POST['contactby']))

/* Subject and Email Destinations */
$emailSubject = 'Work Email!';
$webMaster = 'darren@mywebsite.co.uk';

/* Gathering Data Variables */
$nameField = $_POST['name'];
$addressField = $_POST['address'];
$postcodeField = $_POST['postcode'];
$phoneField = $_POST['phone'];
$emailField = $_POST['email'];
$detailsField = $_POST['details'];
$contactbyField = $_POST['contactby'];

    $allowed_filetypes = array('.jpg','.gif','.bmp','.png');
    $max_filesize = 524288; // Maximum filesize in BYTES (currently 0.5MB)
    $upload_path = './uploads/';

    $filename = $_FILES['userfile']['name'];
    $ext = substr($filename, strpos($filename,'.'), strlen($filename)-1);

    if(!in_array($ext,$allowed_filetypes))
    die('The file you attempted to upload is not allowed.');

    if(filesize($_FILES['userfile']['tmp_name']) > $max_filesize)
    die('The file you attempted to upload is too large.');

    if(!is_writable($upload_path))
    die('You cannot upload to the specified directory, please CHMOD it to 777.');

    if(move_uploaded_file($_FILES['userfile']['tmp_name'],$upload_path . $filename))
    echo 'Your file upload was successful, view the file <a href=
    "' . $upload_path . $filename . '" title="Your File">here</a>'; // It worked.
    else
    echo 'There was an error during the file upload.  Please try again.'; // It failed

    $body = <<<EOD
    Name: $name
    Address: $address
    Postcode: $postcode
    Phone: $phone
    Email: $email
    Details: $details
    Contactby: $contactby
    EOD;

$headers = "From: $email\r\n";
$headers .= "Contact-type: text/html\r\n";
$attachment = chunk_split(base64_encode(file_get_contents($temp_file)));
$tmp_file = $_FILES['userfile']['tmp_name'];
$success = mail($webMaster, $attatchment, $body, $headers, "-fdarren@mywebsite.co.uk");

    /* Results rendered as HTML */

    $theResults = <<<EOD
    SENT SENT SENT
    EOD;
    echo "$theResults"
    ?>

Simple Script... Or So I Thought

Similar Tutorials

There is a sql query happening if the item is not empty, what I NEED and can not seem to figure out is to re run the rand() function. The server is PHP 4 so it is not possible to use the goto statement... That would be to easy. So any help would be great... Here is the code... the script running after the script finds a empty sql row is ot included... it works... just this one part does not.

Code: [Select]
<?php
$connection = mysql_connect(CREDENTIALS REMOVED) or die(mysql_error());
   mysql_select_db("testingblock", $connection)or die(mysql_error());


   $random_num = rand(1,10);

if($random_num == 1){
   $query = sprintf("SELECT email FROM access_codes WHERE id='1'",
mysql_real_escape_string($email));

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

if(!empty($row['email'])){
header('Location: http://www.thestreetbeatint.com/Testing/blah.php');

}
else {
echo $recipient;
}
}
else if ($random_num == 2){
   $query = sprintf("SELECT email FROM access_codes WHERE id='2'",
mysql_real_escape_string($email));

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

if(!empty($row['email'])){
header('Location: http://www.thestreetbeatint.com/Testing/blah.php');
}
else {
echo $recipient;
}
}
   else if ($random_num == 3){
   $query = sprintf("SELECT email FROM access_codes WHERE id='3'",
mysql_real_escape_string($email));

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

if(!empty($row['email'])){
header('Location: http://www.thestreetbeatint.com/Testing/blah.php');
}
else {
echo $recipient;
}
   }
   else if ($random_num == 4){
   $query = sprintf("SELECT email FROM access_codes WHERE id='4'",
mysql_real_escape_string($email));

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

echo '<br />';

if(!empty($row['email'])){
header('Location: http://www.thestreetbeatint.com/Testing/blah.php');
}
else {
echo $recipient;
}
   }
   else if ($random_num == 5){
   $query = sprintf("SELECT email FROM access_codes WHERE id='5'",
mysql_real_escape_string($email));

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

if(!empty($row['email'])){
header('Location: http://www.thestreetbeatint.com/Testing/blah.php');
}
else {
echo $recipient;
}
   }
   else if ($random_num == 6){
   $query = sprintf("SELECT email FROM access_codes WHERE id='6'",
mysql_real_escape_string($email));

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

if(!empty($row['email'])){

header('Location: http://www.thestreetbeatint.com/Testing/blah.php');
}
else {
echo $recipient;
}
   }
   else if($random_num == 7){
   $query = sprintf("SELECT email FROM access_codes WHERE id='7'",
mysql_real_escape_string($email));

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

if(!empty($row['email'])){
header('Location: http://www.thestreetbeatint.com/Testing/blah.php');
}
else {
echo $recipient;
}
   }
   else if ($random_num == 8){
   $query = sprintf("SELECT email FROM access_codes WHERE id='8'",
mysql_real_escape_string($email));

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

if(!empty($row['email'])){
header('Location: http://www.thestreetbeatint.com/Testing/blah.php');

}
else {
echo $recipient;
}
   }
   else if ($random_num == 9){
   $query = sprintf("SELECT email FROM access_codes WHERE id='9'",
mysql_real_escape_string($email));

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

echo '<br />';

if(!empty($row['email'])){
header('Location: http://www.thestreetbeatint.com/Testing/blah.php');
}
else {
echo $recipient;
}
   }
   else if ($random_num == 10){
   $query = sprintf("SELECT email FROM access_codes WHERE id='10'",
mysql_real_escape_string($email));

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

if(!empty($row['email'])){
header('Location: http://www.thestreetbeatint.com/Testing/blah.php');
}
else {
echo $recipient;
}
   }


?>

[icode]

How To Query Pre Tags Into A Textarea?

Similar Tutorials

I have the pre tags stored in the database like in the following example:

<pre> ... </pre>

I am looking to avoid having the code rendered, when querying it into a textarea. Any suggestions?

Returns/new Lines In Textarea Text?

Similar Tutorials

I have a form that is processed using PHP (post method) and there is a textarea people will enter text into.
After processing, the text is displayed to the user. However, if the user did a Carriage Return (i.e. hit Enter) when they originally entered the text, that text does NOT show on a new line when displayed later.

For example, if they type this into the text area...

"Hello there (they hit Enter here)
How are you (they hit Enter here)
Good I hope"

It will display like this, all on one line:

"Hello there How are you Good I hope"

In other words, it doesn't seem to remember that Enter was hit.

Is there some way to "preserve" the fact that someone hit the "Enter" key, so that when text is displayed later, it will show the text on a new line if the user in fact hit "Enter" when originally typing it.

I am probably not using the right terms in the right spots (i.e. newline, carriage return, enter, etc) but I think you get the picture

Let me know if anyone knows how to do this.

Thanks!

Save Textarea's Text As A Downloadable .txt File

Similar Tutorials

I have a textarea and a button, I would like by click a button, the text within the textarea will save as a .txt file and downloadable by user, how to do it with php??

Thanks!!

Alert Textarea Text When Pressing Return Key

Similar Tutorials

Each status has a comment textarea. How can I get it to alert what the user has typed in the textarea when the return key is pressed. The textarea in the PHP loop is like this:

<textarea class='commentbox' id='" . $thisid . "'></textarea>

The reason why I am asking this and not how to save it to the database etc is because I think I will be able to do that. Thanks,

Help With Thought Process!

Similar Tutorials

This may spill over into java, just not quite sure yet!

Basically what I am trying to do, is fill a box with text, click a button which runs a function which send the text in the box via a JSON request to an external server.

The JSON works fine, I just want a way of submitting the string which hopefully doesnt involve a form, but its the only way I can think of!

Any other ideas?

How To Insert Two Input Values And Multi Data Textarea Values In One Query?

Similar Tutorials

Dear All Members

here is my table data..

(4 Columns/1row in mysql table)

id order_no order_date miles
310 001 02-15-2020 MI,108.53
Oh,194.57
PA,182.22
WA,238.57

How to split(miles) single column into (state, miles) two columns and output like following 5 columns /4rows in mysql using php code.

(5 Columns in mysql table)
------------------------------------------------------------------------------------

id order_no order_date state miles

310 001 02-15-2020 MI 108.53

310 001 02-15-2020 Oh 194.57

310 001 02-15-2020 PA 182.22

310 001 02-15-2020 WA 238.57

------------------my php code -----------

<?php
//invoice.php
include('../includes/config.php');

if(isset($_POST["add"]))
{
$order_no=$_GET['order_no'];
$order_date=$_GET['order_date'];
$miles=$_POST['miles'];

$miles = explode("\r\n", $_POST["miles"]);
$newdata = "'" . implode("','", $_POST["miles"]) . "'";
$sql ="INSERT INTO tble_states_miles(order_no,order_date, miles) VALUES(:order_no, :order_date, :newdata)";

$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);
$query-> bindParam(':order_date', $order_date, PDO::PARAM_STR);
$query-> bindParam(':miles', $newdata, PDO::PARAM_STR);

$lastInsertId = $dbh->lastInsertId();
if($lastInsertId)
{
echo "<script type='text/javascript'>alert('Added Sucessfull!');</script>";
echo "<script type='text/javascript'> document.location = 'ifta_miles_calculationlist_added.php'; </script>";
}
else
{
$error="Something went wrong. Please try again";
}

if($query->execute()) {

$sql = "update tis_invoice set flag='1' where order_no=:order_no";
$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);

$query->execute();

}
}
?>

----------------- my form code ------------------

<?php
               $order_no=$_GET['order_no'];
       $sql = "SELECT * from tis_invoice where order_no = :order_no";
       $query = $dbh -> prepare($sql);
       $query->execute(
array(
':order_no' => $_GET["order_no"]
)
);
       $result = $query->fetchAll();
       foreach($result as $row)
?>

<form method="post">
<table align="center" style="width: 55%">
                       <tr><td>Invoice Number</td></tr>
                       <tr><td><input type="text" name="order_no" value="<?php echo $row["order_no"]; ?>" readonly=""></td></tr>
                       <tr><td>Invoice Date</td></tr>
                       <tr><td><input type="text" name="order_no" value="<?php echo $row["order_date"]; ?>" readonly=""></td></tr>
                       <tr><td>
<textarea name="miles" class="form-control" rows="10" placeholder="" required></textarea>
</td></tr>
                       <tr><td>

<input type="submit" name="add" class="btn btn-primary" value="Add" />
</td></tr></table>
</form>

-- Can any one help how to correct my code..present nothing inserted on table

Thank You

Edited February 8, 2020 by karthicbabu

Font Tester - I Thought I Had It.

Similar Tutorials

Font tester - I thought I had it.

Hi all

I'm trying to produce this font tester where you can set a font with inputted text at a selected size.
In my demo here http://www.ttmt.org.uk/test/ I can type in text and select the size. The image is set with
the correct text and size but everything else is removed from the page.
How can I do this so the image of the text appears below the form in the image tag.

Code: [Select]
<?php
  if(isset($_POST['submit'])){
    // Set the content-type
   header('Content-Type: image/png');

   // Create the image
   $im = imagecreatetruecolor(400, 30);

   // Create some colors
   $white = imagecolorallocate($im, 255, 255, 255);
   $black = imagecolorallocate($im, 0, 0, 0);
   imagefilledrectangle($im, 0, 0, 399, 29, $white);

   // The text to draw
   $text = $_POST['text'];
   $textSize = $_POST['size'];
   $font = 'corbelb.ttf';

   // Add the text
   //imagettftext($im, 20, 0, 10, 20, $black, $font, $text);
   imagettftext($im, $textSize, 0, 10, 20, $black, $font, $text);

   // Using imagepng() results in clearer text compared with imagejpeg()
   $img = imagepng($im);
   imagedestroy($im);
  }

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

<title>untitled</title>
</head>

<body>
<form action="index.php" method="post">
<input type="text" name="text" />
<select name="size">
<option value="10">10</option>
<option value="12">12</option>
<option value="14">14</option>
<option value="18">18</option>
<option value="24">24</option>
<option value="30">30</option>
<option value="36">36</option>
</select>
<input type="submit" name="submit" value="Set →" />
</form>

<img src="<?php echo $img; ?>" />

</body>
</html>

I Thought It Was Solved. Not So! Insert/update

Similar Tutorials

I put a snippet up yesterday, and thought it had been solved. It had a typo error, but there is still something wrong. The whole page follows, because it might be easier to see what I am doing. The form successfully inserts a new record OK, but it will not update a record that already exists as is intended. Instead, it always creates another new record. Where can I be wrong?

<?php
session_start();

// See if logged in member by checking session data
if (isset($_SESSION['recid'])) {
    // Put stored session variables into local php variable
    $userid      = $_SESSION['recid'];
    $username    = $_SESSION['name'];
    $school      = $_SESSION['college'];
    $payer_email = $_SESSION['payer_email'];
    $group1      = $_SESSION['group1'];
    $group2      = $_SESSION['group2'];
    $group3      = $_SESSION['group3'];
    $group4      = $_SESSION['group4'];
    $group5      = $_SESSION['group5'];
    $group6      = $_SESSION['group6'];


} else { ?>

<html>
<tr>
  <td> 
    <p> 
    <p> 
    <p></td>
</tr>
<table style= border align="center" border="1" width="400" height="200">
    <td align="center" valign="center">You need to<a href="login_allocate_quiz.php">log in</a>as an administrator to<br />
      allocate quizzes to student groups.</td>
</table>
</html>
<?php exit();
}

    // Set error message as blank upon arrival to page
    $errorMsg = "";
    // Check to see if the form has been submitted
    if (isset($_POST['equip'])){
    //Connect to the database through include
    include_once "demo_conn.php";
    //set variables
    $equip     = $_POST['equip'];
    $egroup1   = $_POST['egroup1'];
    $egroup2   = $_POST['egroup2'];
    $egroup3   = $_POST['egroup3'];
    $egroup4   = $_POST['egroup4'];
    $egroup5   = $_POST['egroup5'];
    $egroup6   = $_POST['egroup6'];

    //create variables to manipulate filenames in database
    $lowquip = strtolower($equip);
    $wordquip = str_replace (" ", "", $lowquip);
    $bigpic    = $wordquip.'big';
    $smallpic  = $wordquip.'small';
    $bigpic    = $bigpic.'.jpg';
    $smallpic = $smallpic.'.jpg';
    $errorMsg = '<font size="-1"><u>ERROR:</u>   You have not entered the following required information.';
    $nogroup = ((!$egroup1) && (!$egroup2) && (!$egroup3) && (!$egroup4) && (!$egroup5) && (!$egroup6));
    $noequip = (!$equip);
    if ($nogroup)
        {$errorMsg .= "--- Student Group. (No data was forwarded to the database.)</font>";}
    else if($noequip)
        {$errorMsg .= "--- Quiz Name. (No data was forwarded to the database.)</font>";}
    else
        {$query = mysql_query("SELECT equip FROM topics WHERE equip = '$equip' AND managerId = '$userid'");
              if (mysql_num_rows($query) > 0)
                mysql_query("UPDATE topics SET egroup1 = '$egroup1', egroup2 = '$egroup2', egroup3 = '$egroup3', egroup4 = '$egroup4', egroup5 = '$egroup5', egroup6 = '$egroup6' WHERE equip = '$equip' AND managerId = '$userid'");
            else
                mysql_query("INSERT INTO topics (managerId, equip, title, url_big, url_small, egroup1, egroup2, egroup3, egroup4, egroup5, egroup6) VALUES ('$userid','$wordquip', '$equip', '$bigpic', '$smallpic', '$egroup1', '$egroup2', '$egroup3', '$egroup4', '$egroup5', '$egroup6')") or die (mysql_error("error 1321"));
        $URL='make_quiz_list_test4.php';
        header ('Location: '.$URL);
        }
    }
?>
<!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" dir="ltr" lang="en-US" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
<meta http-equiv="X-UA-Compatible" content="IE=4">

<meta http-equiv="X-UA-Compatible" content="IE=7.5">

<meta http-equiv="X-UA-Compatible" content="IE=100">

<meta http-equiv="X-UA-Compatible" content="IE=a">

<title>Manager selected quiz list</title>
<link rel="stylesheet" href="style.css" type="text/css" media="screen" />


<script type="text/javascript" src="script.js"></script>
</head>
<body>
<div id="art-page-background-simple-gradient">
  <div id="art-page-background-gradient"></div>
</div>
<div id="art-main">
  <div class="art-sheet">
    <div class="art-sheet-tl"></div>
    <div class="art-sheet-tr"></div>
    <div class="art-sheet-bl"></div>
    <div class="art-sheet-br"></div>
    <div class="art-sheet-tc"></div>
    <div class="art-sheet-bc"></div>
    <div class="art-sheet-cl"></div>
    <div class="art-sheet-cr"></div>
    <div class="art-sheet-cc"></div>
    <div class="art-sheet-body">
      <div class="art-header">
        <div class="art-header-png"></div>
        <div class="art-header-jpeg"></div>
        <div class="art-logo">
          <h1 id="name-text" class="art-logo-name"><a href="#">Safety Testing Online</a></h1>
          <div id="slogan-text" class="art-logo-text">Safety - The Most Valuable Insurance</div>
        </div>
      </div>
      <div class="art-nav">
        <div class="l"></div>
        <div class="r"></div>
        <div class="art-nav-center">
          <ul class="art-menu">
            <li> <a href="../../index.php" class="active"><span class="l"></span><span class="r"></span><span class="t">Home</span></a> </li>
            <li> <a href="../demo_main.php"><span class="l"></span><span class="r"></span><span class="t">Demonstrations Page</span></a>
              <ul>
              </ul>
            </li>
            <li> <a href="logout.php"><span class="l"></span><span class="r"></span><span class="t">Admin Logout</span></a> </li>
          </ul>
        </div>
      </div>
      <div class="art-content-layout">
        <div class="art-content-layout-row">
          <div class="art-layout-cell art-content">
            <div class="art-post">
              <div class="art-post-tl"></div>
              <div class="art-post-tr"></div>
              <div class="art-post-bl"></div>
              <div class="art-post-br"></div>
              <div class="art-post-tc"></div>
              <div class="art-post-bc"></div>
              <div class="art-post-cl"></div>
              <div class="art-post-cr"></div>
              <div class="art-post-cc"></div>
              <div class="art-post-body"></div>
              <div class="art-post-bl"></div>
              <div class="art-post-br"></div>
              <div class="art-post-tc"></div>
              <div class="art-post-bc"></div>
              <div class="art-post-cl"></div>
              <div class="art-post-cr"></div>
              <div class="art-post-cc"></div>
              <div class="art-post-body">
                <div class="art-post-inner art-article">
                  <table style="table-layout:fixed; width:850px;">
                    <tr>
                      <td style="text-align:left; width:30px;"> </td>
                      <td style="text-align:left; width:350px;"><font size="+1">Allocation of Woodwork Quizzes to Groups.</font></td>
                      <td style="text-align:left; text-align:center; vertical-align:bottom; width:450px;"><font color="#0000FF">Administrator: <?php echo $username; ?> - <?php echo $school; ?>.</font></td>
                      <td style="text-align:left; width:20px;"></td>
                    </tr>
                  </table>
                  <table style="table-layout:fixed; width:850px;">
                    <tr>
                      <td style="text-align:left; width:30px;"></td>
                      <td style="text-align:left; vertical-align:bottom; width:800px;"><font color="#FF0000"><?php echo "$errorMsg"; ?></font></td>
                      <td style="text-align:left; width:20px;"></td>
                    </tr>
                  </table>
                  <table style="table-layout:fixed; border:thin; text-align:left; width:850px;">
                    <tr>
                      <td style="text-align:right; width:35px;"></td>
                      <td style="text-align:left; width:190px;"></td>
                      <td style="text-align:right; width:20px;"></td>
                      <td style="text-align:left; width:210px;"><font color="#FF0000"></font></td>
                      <td style="text-align:right; width:20px;"></td>
                      <td style="text-align:left; width:110px;"></td>
                      <td style="text-align:right; width:20px;"></td>
                      <td style="text-align:right; width:180px;"></td>
                      <td style="text-align:right; width:35px;"></td>
                    </tr>
                    <hr/>
                    <tr>
                      <td rowspan="12"></td>
                      <td rowspan="12">
                      <br/>
                      <form method="post" enctype="multipart/form-data" action="make_quiz_list_test4.php">
                        
                        <select size="25" name="equip" />

                        <option selected value="">No Quiz Selected</option>
                        <option value="Biscuit Jointer">Biscuit Jointer</option>
                        <option value="Dowelling Machine">Dowelling Machine</option>
                        <option value="Drill Cordless">Drill - Cordless</option>
                        <option value="Drill with Cord">Drill - Power Corded</option>
                        <option value="Pedestal Drill">Drill - Pedestal</option>
                        <option value="Edge Tool Sharpener">Edge Tool Sharpener</option>
                        <option value="General Workshop Safety">General Workshop Safety</option>
                        <option value="Pedestal Grinder">Grinder - Pedestal</option>
                        <option value="Hand Tools">Hand Tools</option>
                        <option value="Jointer">Jointer (fixed)</option>
                        <option value="Jointer Surfacer Combo">Jointer/Surfacer (combo)</option>
                        <option value="Shaper">Shaper (fixed)</option>
                        <option value="Lathe for Wood">Lathe - Wood</option>
                        <option value="Linisher">Linisher</option>
                        <option value="Mortiser with Hollow Chisel">Mortiser - Hollow Chisel</option>
                        <option value="Nailgun for Brads">Nailer - Air (brads)</option>
                        <option value="Planer Portable">Planer - (portable)</option>
                        <option value="Router Portable">Router - Plunge</option>
                        <option value="Router with Sliding Table">Router Table - Slide</option>
                        <option value="Sander Belt">Sander - Belt (fixed)</option>
                        <option value="Sander Disc Belt Combo">Sander - Belt/Disc Combo)</option>
                        <option value="Sander Portable Belt">Sander - Belt (portable)</option>
                        <option value="Sander Disc">Sander - Disc (fixed)</option>
                        <option value="Sander Orbital">Sander - Orbital</option>
                        <option value="Sander Random Orbit">Sander - Random Orbital</option>
                        <option value="Sander Bobbin">Sander - Vertical Spindle</option>
                        <option value="Saw Bandsaw">Saw - Bandsaw</option>
                        <option value="Saw Bench">Saw - Circular (bench)</option>
                        <option value="Saw Portable Circular">Saw - Circular (portable)</option>
                        <option value="Saw Drop or Chop">Saw - Drop (alt Chop)</option>
                        <option value="Saw Drop and Slide">Saw - Drop & Slide</option>
                        <option value="Jigsaw Portable">Saw - Jigsaw (portable)</option>
                        <option value="Saw Panel">Saw - Panel (fixed)</option>
                        <option value="Saw Radial Arm">Saw - Radial Arm</option>
                        <option value="Saw Sabre">Saw - Sabre(portable)</option>
                        <option value="Saw Scroll">Saw - Scroll</option>
                        <option value="Screw Driver Portable">Screwdriver - Portable</option>
                        <option value="Thicknesser">Thickness Planer</option>
                        </td>
                        <td> </td>
                        <td> </td>
                        <td> </td>
                        <td rowspan="7"><br />
                          <br />
                          <br />
                          <input type="checkbox" name="egroup1" value="1" />
                          <?php echo $group1; ?>
                          <p>
                            <input type="checkbox" name="egroup2" value="1" />
                            <?php echo $group2; ?>
                          <p>
                            <input type="checkbox" name="egroup3" value="1" />
                            <?php echo $group3; ?>
                          <p>
                            <input type="checkbox" name="egroup4" value="1" />
                            <?php echo $group4; ?>
                          <p>
                            <input type="checkbox" name="egroup5" value="1" />
                            <?php echo $group5; ?>
                          <p>
                            <input type="checkbox" name="egroup6" value="1" />
                            <?php echo $group6; ?>
                          <p>
                            <input type="submit" value="submit" name="Send Data">
                      </form>
                      </td>
                      <td></td>
                      <td></td>
                      <td></td>
                    </tr>
                    <tr>
                      <td></td>
                      <td style="border:solid; color:#006600; 1px; padding:10px; text-align:left;"><font size="-1">Select a Quiz Topic from the drop down list on the left. Then go to the check boxes on the right to select all of the groups that are expected to undertake this test.
                        <p>You can select only one quiz each time, but you can select from one to six groups to undertake that quiz.
                        <p>Repeat this process until you have allocated all of the tests that you require each group to complete.
                        <p>If you make a mistake you can delete a quiz allocation <a href="../../under_con.php">here</a> at any time.
                        </font></td>
                      <td></td>
                      <td></td>
                      <td style="color:#006600;"><font size="-1">Go back to the <br />
                        <a href="member_account.php">main edit page</a>.<br/>
                         <br />
                         <br/>
                         <br/>
                         <br/>
                         <br/>
                         <br/>
                         <br/>
                         <br/>
                         <br/>
                         <br/>
                         <br/>
                         <br/>
                         <br/>
                         <br/>
                         <br/>
                        </font></td>
                    </tr>
                    <tr>
                      <td></td>
                      <td> <br/>
                         <br/>
                         <br/>
                         <br/></td>
                      <td></td>
                      <td></td>
                      <td></td>
                    </tr>
                  </table>
                  
                </div>
                <div class="cleared"></div>
              </div>
              <div class="cleared"></div>
            </div>
          </div>
        </div>
      </div>
    </div>
    <div class="cleared"></div>
    <div class="art-footer">
      <div class="art-footer-inner">
        <div class="art-footer-text">
          <p><a href="#">Contact Us</a> | <a href="#">Terms of Use</a> | <a href="#">Trademarks</a> | <a href="#">Privacy Statement</a><br />
            <?php
$time = time () ;
//This line gets the current time off the server
$year= date("Y",$time);
//This line formats it to display just the year
echo "Copyright © 2010 - " . $year;
//this line prints out the copyright date range, you need to edit 2010 to be your opening year
?>
            All Rights Reserved.</p>
        </div>
      </div>
      <div class="art-footer-background"></div>
    </div>
    <div class="cleared"></div>
  </div>
</div>
<div class="cleared"></div>
<p class="art-page-footer">Designed by Frank.</p>
</div>
</body>
</html>

15 Seconds Of Thought And I Don't Know What To Call The Subject. Sorry

Similar Tutorials

Does anyone know why this isn't working?

$body = "
Dear ".if ($row['customertitle'] != '') {echo $row['customertitle'].' '.$row['customerlastname'];} else (echo $row['customerfirstname'];}."
<BR>
This is a test. ".$_SERVER['SERVER_ADDR']."
<BR>
".echo $accessinformation."
";

Help With A Simple Query.

Similar Tutorials

SELECT * FROM Sold WHERE substr(sold_date, 0, 4) = 2010

What I am trying to do is select all rows from the database from 2010, from the "sold_date" field.
How is this accomplished with date values? (ex: "2010-08-11", "2009-01-15")

Simple Query

Similar Tutorials

i have a cell in my database like

Code: [Select]

Stats

100-10-3

and i want to update that with my code

Code: [Select]

$details = 100 . '-' . 10 . '-' . 3;
$sql = "UPDATE usertable SET uSkillsMax=$details";

but my database updates instead of 100-10-3 it says 87? which is doing the math?

any way to fix this?

Simple Query Not Working...

Similar Tutorials

The following mysql query is not returning rows like I expect it to. '$update_field' is a variable, matching an actual field name in table 'users'. 'user_task[1]' is an integer value. What am I missing here?
Code: [Select]
$query_update_user = "UPDATE users SET ".$update_field." = 'Y' WHERE user_no = '".$user_task[1]."'";

This Simple Query Is Broke Lol

Similar Tutorials

Code: [Select]
$ids = implode (",", $ibforums->input['checkbox']);
$time = time();
$ids2 = implode (",", $ibforums->input['pendingusers']);

$DB->query("UPDATE friends_pending SET pending='0',date=$time WHERE id IN ($ids) AND toid IN ($ids2)");
weird thing is, it's not bring up any error's or nothing

$ids2 spits out
2,30

and $ids spits out

9,7

for this particular project

doesn't give me mysql error or nothing, script runs fine. I have mysql error enabling under $dbquery class so nn to worry, how to get this to work?

Can i even use 2 IN's in 1 query or???

Problem With What Should Be A Simple Query

Similar Tutorials

Hi --

This query seems to be problematic because the UPDATE is not being performed. Could you please take a gander and let me know what is the problem?

BTW, the table "teamy" does contain 630 records. Thanks in advance!

$sql = "SELECT COUNT( * ) AS records FROM teamy" ;
$result = mysql_query( $sql ) ;
if ( ! $result )
{ die ( __line__ . "_teamy_" . mysql_error() ) ; }

$a_count = mysql_fetch_assoc($result);
if ( $a_count['records'] = 0 )
{
   echo "No records found in teamy." ;
}
else
{
   /*** Update r_rost_rma ***/
   $sql = "UPDATE r_rost_rma
             JOIN teamy
               ON r_rost_rma.student_id = teamy.student_id
              SET r_rost_rma.teachername = teamy.team
            WHERE RTRIM( UPPER( r_rost_rma.localcourse ) ) = 'HOMEROOM'" ;

   $result = mysql_query ( $sql ) ;
   if ( ! $result )
   { die ( __line__ . "_update_r_rost_rma_" . mysql_error() ) ; }
}

Simple Mysql Query. Help

Similar Tutorials

I have a database called "postvoting", It's basically to store when somebody votes on a particular posts. I store the post_id that the user votes on, the users id that voted on it, and the date.
What I want to do is find the most popular posts in a given time.

So if 4 people voted on the post with the id of 1, and 2 people voted on the post with the id of 2, I want to count the number of rows with post_id='1'

A non working example what I want would look something like:
$count_votes = mysql_query("SELECT * FROM postvoting WHILE post_id=post_id");
print mysql_num_rows($count_votes);
result: 4

or
$count_votes = mysql_query("SELECT * FROM postvoting GROUP BY post_id");
print mysql_num_rows($count_votes);
result: 4

(counting the number of results in a group)

Hope this isn't too confusing. (I've confused myself with this).

Simple Query Not Working...

Similar Tutorials

I've got to be missing something pretty basic here.. considering the query is pretty basic.

I'm trying to figure out how to pull a query as an array so I can compare it against another array (array_diff)

I'm doing a mysql_fetch_array, and I'm getting an error ( mysql_fetch_array(): supplied argument is not a valid MySQL result resource):
Quote

$checker = "SELECT ID FROM edible_uses";

$result2 = mysql_fetch_array($checker) or die(mysql_error());
//echoing to see if I'm getting what I need.
echo $row['ID'];

I've done a mysql_query and I get results. The table name and all that is correct. I'm stumped. This seems like a pretty simple query? I tried mysql_fetch_assoc as well. Same result? I tried it with an extra set of parenthesis around it. nope.

Simple Insert Query Error

Similar Tutorials

Im sure this is simple, but I cannot see what my problem is!

I am hitting an error on my insert query

Code: [Select]
Error: 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 '1' at line 1
I know the output of $user_id is 1, so my error is on $mysavepath

Code: [Select]
$mysavepath = $folder.'/'.$worldname.'_'.date("dMjY");
echo $mysavepath;
$savepath = mysql_query("INSERT INTO saves (user_id,savepath) VALUES ('$user_id','$mysavepath')");
echo '<br>'.$savepath;
if(!mysql_query($savepath))
{
die('<br>Error: ' . mysql_error());
}

however it all echos out ok?

Code: [Select]
188ea678f0dcdc8252aeb15e3c910408/world_15Jan152012
1
Error: 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 '1' at line 1

Can anyone see the problem?

Cheers
Dave

Moved: Sql Query And Simple Add Maths

Similar Tutorials

This topic has been moved to MySQL Help.

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