PHP - Multiple Query Fields?

I have the following PHP script to update two time/date fields in the database.

When i run this the fields are not updated.

Can anyone see where i m going wrong.

<?php
$con = mysql_connect("localhost","dbname","dbpassword");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

echo 'Connected successfully';

mysql_select_db("my_db", $con);

mysql_query("UPDATE msm_content SET created = '2011-01-02 00:00:00', modified = '2011-01-01 00:00:00'");

echo 'Query Updated successfully';

mysql_close($con);
?>

Your guidance is much appreciated.

Hi i would like to submit the following code to my database as a mutiple selection box.
when i submit i just get the last selected value for example if i hold ctrl and press 1  2  3  4   i am only receiving 4 on my database. any ideas? thanks in advance for any help!

Code: [Select]
Hours Of Availability:<br>
<select name="availability" multiple="multiple" size="9">
<option value="Monday - Period 1">Monday - Period 1</option>
<option value="Monday - Period 2">Monday - Period 2</option>
<option value="Monday - Period 3">Monday - Period 3</option>
<option value="Monday - Period 4">Monday - Period 4</option>
<option value="Monday - Period 5">Monday - Period 5</option>
<option value="Monday - Period 6">Monday - Period 6</option>
<option value="Monday - Period 7">Monday - Period 7</option>
<option value="Monday - Period 8">Monday - Period 8</option>
<option value="Monday - Period 9">Monday - Period 9</option>
</select>
<select name="availability" multiple="multiple" size="9">
<option value="Tuesday - Period 1">Tuesday - Period 1</option>
<option value="Tuesday - Period 2">Tuesday - Period 2</option>
<option value="Tuesday - Period 3">Tuesday - Period 3</option>
<option value="Tuesday - Period 4">Tuesday - Period 4</option>
<option value="Tuesday - Period 5">Tuesday - Period 5</option>
<option value="Tuesday - Period 6">Tuesday - Period 6</option>
<option value="Tuesday - Period 7">Tuesday - Period 7</option>
<option value="Tuesday - Period 8">Tuesday - Period 8</option>
<option value="Tuesday - Period 9">Tuesday - Period 9</option>
</select>
<select name="availability" multiple="multiple" size="9">
<option value="Wednesday - Period 1">Wednesday - Period 1</option>
<option value="Wednesday - Period 2">Wednesday - Period 2</option>
<option value="Wednesday - Period 3">Wednesday - Period 3</option>
<option value="Wednesday - Period 4">Wednesday - Period 4</option>
<option value="Wednesday - Period 5">Wednesday - Period 5</option>
<option value="Wednesday - Period 6">Wednesday - Period 6</option>
<option value="Wednesday - Period 7">Wednesday - Period 7</option>
<option value="Wednesday - Period 8">Wednesday - Period 8</option>
<option value="Wednesday - Period 9">Wednesday - Period 9</option>
</select>
<select name="availability" multiple="multiple" size="9">
<option value="Thursday - Period 1">Thursday - Period 1</option>
<option value="Thursday - Period 2">Thursday - Period 2</option>
<option value="Thursday - Period 3">Thursday - Period 3</option>
<option value="Thursday - Period 4">Thursday - Period 4</option>
<option value="Thursday - Period 5">Thursday - Period 5</option>
<option value="Thursday - Period 6">Thursday - Period 6</option>
<option value="Thursday - Period 7">Thursday - Period 7</option>
<option value="Thursday - Period 8">Thursday - Period 8</option>
<option value="Thursday - Period 9">Thursday - Period 9</option>
</select>
<select name="availability" multiple="multiple" size="9">
<option value="Friday - Period 1">Friday - Period 1</option>
<option value="Friday - Period 2">Friday - Period 2</option>
<option value="Friday - Period 3">Friday - Period 3</option>
<option value="Friday - Period 4">Friday - Period 4</option>
<option value="Friday - Period 5">Friday - Period 5</option>
<option value="Friday - Period 6">Friday - Period 6</option>
<option value="Friday - Period 7">Friday - Period 7</option>
<option value="Friday - Period 8">Friday - Period 8</option>
<option value="Friday - Period 9">Friday - Period 9</option>
</select>
<select name="availability" multiple="multiple" size="9">
<option value="Saturday - Period 1">Saturday - Period 1</option>
<option value="Saturday - Period 2">Saturday - Period 2</option>
<option value="Saturday - Period 3">Saturday - Period 3</option>
<option value="Saturday - Period 4">Saturday - Period 4</option>
<option value="Saturday - Period 5">Saturday - Period 5</option>
<option value="Saturday - Period 6">Saturday - Period 6</option>
<option value="Saturday - Period 7">Saturday - Period 7</option>
<option value="Saturday - Period 8">Saturday - Period 8</option>
<option value="Saturday - Period 9">Saturday - Period 9</option>
</select>
<br>Press + Hold Ctrl For Multiple</p>

I have html form that looks like:
<form method="post" action="?a=up">
...some mysql query...
while ($i = mysql_fetch_array($result)) {

<input name="name[]" type="text" value="<?=$i['name'];?>" />
<input name="years[]" type="text" value="<?=abs($age);?>"/>
<input name="to[]" type="checkbox" value="<?=$i['id'];?>" />

}
<input name="" type="submit" value="go" />
</form>


The problem I have is that I can not get the values of the form fields such as "name" and "years". I can only get a list of the ids (value of "to" checkbox).

The php code looks like:
$cnt = 0;
for($p = 0; $p <= (sizeof($to)-1); $p++)
{
echo $to[$p].$name[$p].$years[$p]"<br>";
$cnt++;
}

$tm = array($cnt);


What I'm doing wrong?

This topic has been moved to MySQL Help.

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

This topic has been moved to JavaScript Help.

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

I have problem that only last text field  is updated, how should I fix this?

Here's the code
<?php
if(isset($_POST["update"])){
mysql_query("UPDATE categories SET name_category = '".$_POST['category']."'  WHERE ID= ".$_POST['currentCat']." ") or die(mysql_error());
mysql_query("UPDATE podkategorije SET name_subcategory = '".$_POST['subcategory']."'  WHERE id_subCat= ".$_POST['currentSubCat']." ") or die(mysql_error());
 }
?>
<form action="" method="post" >
<?php

//creating texfields from db

$query = "SELECT k.ID, k.name_category, pk.name_subcategory, pk.id_subCat
          FROM `categories` AS k
          JOIN `subcategories` AS pk ON pk.id_mainCat = k.ID";

$result = mysql_query($query) or die(mysql_error());

$currentCat = false;
while($row = mysql_fetch_array($result))
{
    //so it doesn't repeat itself
    if($currentCat != $row['ID'])
    {
        //display of main Categories

?>

<ul>

<li>

<br/><input name="categories" type="text" value="<?php  echo $row['name_category']; ?>" />

</li>

</ul>

<?

$currentCat = $row['ID'];

    }
    //display subcategories

?>

<input name="subcategories" type="text" value="<?php  echo $row['name_category']; ?>" /><br/>

<input type="hidden" name="currentCat" value="<?php echo $row['ID']; ?>" />

<input type="hidden" name="currentSubCat" value="<?php echo $row['id_subCat']; ?>" />

<?
}
?>
<br />
<input type="button" value="Back" onClick="history.go(-1);return true;">
<input type="submit" value="Update" name="update"/>
</form>

I have a Form that has 10 questions.

When the User completes the Form, each Response needs to be a separate record.

(My database has a many-to-many relationship with a "member" and "question" table joined by a "answer" table in the middle.  And each Form field will go into its own unique record to make the many-to-many work.)

At the top of my Form I have...

if ($_SERVER['REQUEST_METHOD']=='POST'){
// Form was Submitted (Post).

// Initialize Errors Array.
$errors = array();

// Trim all form data.
$trimmed = array_map('trim', $_POST);


// ************************
// Validate Form Data. *
// ************************

// Validate Answer1.
if (strlen($trimmed['answer01']) >= 2 && strlen($trimmed['answer01']) <= 1024){
// Valid Answer1.
$answerArray[0] = $trimmed['answer01'];
}else{
// Invalid Answer1.
$errors['question01'] = 'Answer must be 2-1024 characters.';
}//End of VALIDATE ANSWER1


// Validate Answer2.
// :
// :
// Validate Answer10.



And down farther in my code, I have each Field in my Form set up like this...
Code: [Select]
<!-- Question 1 -->
<label for="question01">1.) Why did you decide to start your own business?</label>
<textarea id="question1" name="answer01" cols="60" rows="8"><?php if (isset($answerArray[0])){echo htmlentities($answerArray[0], ENT_QUOTES);} ?></textarea>
<?php
if (!empty($errors['question01'])){
echo '<span class="error">' . $errors['question01'] . '</span>';
}
?>


So if my Form works like I am thinking, all 10 Form Fields would end up here...
Code: [Select]
$answerArray[0]
$answerArray[1]
$answerArray[2]
$answerArray[3]
$answerArray[4]
$answerArray[5]
$answerArray[6]
$answerArray[7]
$answerArray[8]
$answerArray[9]


First of all, does that sound correct?


If that part is correct, then how do I take the $answerArray[] and INSERT each value into a different record in my "answer" table??

Hope that makes sense?!

Thanks,


Debbie

hi, i'm new to php. i've got a problem.
I've 3 tables and table has following content

table 1
id  name  email   address   phone   execution_date   executor_name   web_address


table 2
id  name  email   address   phone   execution_date   executor_name   project_title


table 3
id  name  email   address   phone   execution_date   executor_name   reviewer

I want to export these table to and spreadsheet (.xls) with some criteria

a form will assign which data will published at the spreadsheet with these criteria
#all data can be exported from three tables
#some column can be selected from three tables
#some or all data can be selected from individual table

i've implement a script for this but it didn't meet my requirements. Can anyone help?

here is my script

<?php

$DB_Server = "localhost"; //your MySQL Server 
$DB_Username = "root";  //your MySQL User Name 
$DB_Password = "pass"; //your MySQL Password 
$DB_DBName = "mydb"; //your MySQL Database Name 
$search_from_date = $_POST['start_date'];
$search_to_date = $_POST['end_date'];
$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password)
or die("Couldn't connect to MySQL:<br>" . mysql_error() . "<br>" . mysql_errno());
$Db = @mysql_select_db($DB_DBName, $Connect)
or die("Couldn't select database:<br>" . mysql_error(). "<br>" . mysql_errno());
$now_date = date('m-d-Y H:i');

if(($_POST['typer_of_report'] == 'rrc_report')  || ($_POST['typer_of_report'] ==  'all_report'))
{
$DB_TBLName = 'rrc_record';
}

if(($_POST['typer_of_report'] == 'erc_report')  || ($_POST['typer_of_report'] ==  'all_report'))
{
$DB_TBLName2 = 'erc_record';
}

if(($_POST['typer_of_report'] == 'aeec_report')  || ($_POST['typer_of_report'] ==  'all_report'))
{
$DB_TBLName3 = 'aeec_record';
}



$file_type = "vnd.ms-excel";
$file_ending = "xls";
//}
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=protocol_report.$file_ending");
header("Pragma: no-cache");
header("Expires: 0");

if($DB_TBLName)
{
$sql = "Select * from ".$DB_TBLName." where execution_date >= '".$search_from_date."' and 
execution_date <= '".$search_to_date."' order by execution_date desc";
$Use_Title = 1;


$title = "Report for $DB_TBLName on $now_date";
$result = @mysql_query($sql,$Connect)
or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());

if ($Use_Title == 1)
{
echo("$title\n");
}
$sep = "\t"; //tabbed character
for ($i = 0; $i < mysql_num_fields($result); $i++)
{
echo mysql_field_name($result,$i) . "\t";
}
print("\n");
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=0; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
}
//}

echo "\n...\n";
}

if($DB_TBLName2)
{
$sql = "Select * from ".$DB_TBLName2." where execution_date >= '".$search_from_date."' and 
execution_date <= '".$search_to_date."' order by execution_date desc";
$result = @mysql_query($sql,$Connect)
or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());
$Use_Title = 1;
$title = "Report for $DB_TBLName2 on $now_date";
if ($Use_Title == 1)
{
echo("$title\n");
}
$sep = "\t"; //tabbed character
for ($i = 0; $i < mysql_num_fields($result); $i++)
{
echo mysql_field_name($result,$i) . "\t";
}
print("\n");
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=0; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
}


echo "\n...\n";
}

if($DB_TBLName3)
{
$sql = "Select * from ".$DB_TBLName3." where execution_date >= '".$search_from_date."' and 
execution_date <= '".$search_to_date."' order by execution_date desc";
$result = @mysql_query($sql,$Connect)
or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());
$Use_Title = 1;
$title = "Report for $DB_TBLName3 on $now_date";
if ($Use_Title == 1)
{
echo("$title\n");
}
$sep = "\t"; //tabbed character
for ($i = 0; $i < mysql_num_fields($result); $i++)
{
echo mysql_field_name($result,$i) . "\t";
}
print("\n");
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=0; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
}
}

?>

have anyone any idea?

HTML code:
Code: [Select]
<form method="post" action="viewpage.php?page_id=5">

Email: <input name="email" type="text"><br>
Full Name: <input name="name" type="text"><br>
Age: <input name="age" type="text"><br>
Summoner Name: <input name="summon" type="text"><br>
Do you have vent? <input name="vent" type="text"><br>
Do you have a mic? <input name="mic" type="text"><br>
How often can you be on? <input name="online" type="text"><br>
What level are you? <input name="level" type="text"><br>
Who do you like to play as? <input name="champs" type="text">
</form><br>

Can you help donate to the clan for vent and the site?<br>
<textarea name="name" rows="7" cols="25"></textarea><br> Before you say anything about the PHP not scripted to do all fields, I already know this I'm trying to figure out how to send multiple ones in one message:

PHP Code:
Code: [Select]
<?php
 if (isset($_POST['submit'])) {

  $to = "hidden for privacy";
  $subject = "LoL Recruitment";
  $email = $_REQUEST['email'] ;
  $message = ($_REQUEST['name'], $_REQUEST['age']) ;
  $headers = "From: $email";
  $sent = mail($to, $subject, $message, $headers) ;
  if($sent) {
print "Your mail was sent successfully";
 }  else  {
print "We encountered an error sending your mail";
 }
}
 ?>
I'm willing to bet my
Code: [Select]
$message = ($_REQUEST['name'], $_REQUEST['age']) ;if FAR wrong

Hi Guys,

I am attempting to create a program for a local auction house.

I arrived at a stand still on a certain issue which is creating a sticky form. On the "enter auction details page" the user will be entering data as the auction is in session.

1. item Description
2. Item Price
3. Bidders Id
4. Qty

Of course it would be repetitive to require the user to keep entering the same data for every bidder, so I want to stick the obvious fields which are "item description" & "Item Price" as these don't change until a new item comes up for sale.

As of know I am processing the input on a separate page which records all input to the database with a redirect back to the  "enter auction details page". I have tried many times to get the item description and item price fields to stick. These would need to change as the user moves onto the next item in which the description and price would change as well.

Here is my current code for this part:
Code: [Select]
<?php
session_start(); 
$field_itemDescription = ""; //iyem description, default as blank
if (isset($_SESSION['itemDescription'])) $itemDescription = $_SESSION['itemDescription'];
?>
<form action="record_trans.php" method="post">
<font face= "calibri" size= "4">
<table>

<tr>  <td><b>Item Description:</b></td>
<td><input type= "text" name= "itemDescription" size= "30" value="<?php echo $itemDescription;?>"></td>
</tr>
<tr>   <td><b>Item Price:</b></td>

<td><input type= "text" name= "itemPrice" size= "5" value="<?php echo $itemPrice;?>"> </td>
</tr>
</tr>   <td><b>Winning Bidders:</b></td>
<td><input type="text" name= "bidderId" size= "5" />
</td>
</tr>
<tr>   <td><b>How many deals?:</b></td>
<td><input type="text" name= "itemQty" size= "3" value= "1" /></td>
</tr>
</table>

<center><input type="submit" name="submit" value= "Save & Cont."
" /></center>
</form></font>

I am echoing out 2 radio input fields in a foreach statement. I would like to have the first option checked in all the radio input fields that gets echoed out.   But for some reason it marks the radio input field "checked" all the way in the bottom. (The last one)   How can I make it so that every input field that gets echoed out will be marked checked?   Below is my code. Thank you for your help

foreach ($menu_cat_options as  $menu_cat_option){

<input type="radio"  checked="checked" name="display_type" value="radio" >Radio
 <br>
<input type="radio"  name="display_type" value="checkbox">Check Box
}

these DB  are on the same server
sp
inter
query
how do i combine the mysql_db()?
Code: [Select]
SELECT * FROM `sp.bookings` LEFT JOIN sp.bookings_items ON sp.bookings.id_item = sp.bookings_items.id LEFT JOIN inter.apartments ON inter.apartments.ID = sp.bookings_items.id_ref_external WHERE  sp.bookings.the_date BETWEEN '$from_date' and '$to_date' and id_state=1   LIMIT 0 , 30

Hello,

I'm fairly new to php and I'm working on a website for a chess club. I'd like the user to select all of his or her personal results from a general results table.  The results table looks as follows:

id         name_white         name_black         result           season_id

1          john                    pete                    1-0              2010-2011
2          charles                steve                   0-1              2010-2011
3          richard                john                    1-0               2010-2011
etc
11        isaac                   john                    1-0               2011-2012
12        william                kate                     0-1              2011-2012
13        john                    bobby                  1-0              2011-2012
etc

Let us say that the user wants to see all the results of player john in the 2010-2011 season.  The following query (probably quite naively) gives me the error "supplied argument is not a valid MySQL result resource":

Code: [Select]
$result_personal = mysql_query("SELECT * FROM results WHERE name_white = '$seleted_name' AND name_black = '$selected_name' AND season id ='$selected_season'");
Could anyone help me steer in the right direction?  Should I use a JOIN query instead?  Or a IN query?

All the best and thanks in advance for your time,

Wouter.

$query = mysql_query("SELECT COUNT(tickets.id),tickets.id,tickets.status,tickets.date,tickets.question,tickets.title,users.position FROM tickets,users WHERE tickets.id='$existing' users.username='$username'");


How do I get it so it selects data from the table tickets where id='$existing', but I also want to get a user's (who is viewing the ID) position (rank). $username is a session. So, any thoughts on how I would do so?

My updated code:


<?php
session_start();
include("../includes/mysql.php");
include("../includes/config.php");

?>

<!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="text/html; charset=iso-8859-1" />
<link href="../style.css" rel="stylesheet" type="text/css" />
<title><?php echo $title; ?></title>
</head>

<body>
<div id="container">
<div id="content">
<div id="left">
<div class="menu">
<?php include("../includes/navigation.php"); ?>
<div class="menufooter"></div>
</div>
<?php include("../includes/menu.php"); ?>
</div>
<div id="middle">
<?php
$existing = $_POST['existing'];
$ip = $_SERVER['REMOTE_ADDR'];
$username = $_SESSION['user'];

$query = mysql_query("SELECT COUNT(tickets.id),tickets.id,tickets.status,tickets.date,tickets.question,tickets.title,users.position FROM tickets,users WHERE tickets.id='$existing' OR users.username='$username'");
$get = mysql_fetch_assoc($query);

if(!$existing)
{
echo 
'
<div class="post">
<div class="postheader"><h1>Error</h1></div>
<div class="postcontent">
<p>You have not enetered in a ticket ID. Please go back and do so.</p>
</div>
<div class="postfooter"></div>
</div>
';
}
elseif($get['COUNT(id)'] < 1)
{
echo 
'
<div class="post">
<div class="postheader"><h1>Error</h1></div>
<div class="postcontent">
<p>The ticket ID you are trying to use doesnt exist. Please go back or submit another ticket.</p>
</div>
<div class="postfooter"></div>
</div>
';
}
elseif($get['tickets.ip']==$ip || $get['user.position'] >= 1)
{
$status["tickets.status"]["0"] = "Waiting for support...";
$status["tickets.status"]["1"] = "Waiting for user...";
$status["tickets.status"]["2"] = "Ticket Closed...";
$status["tickets.status"]["3"] = "Ticket Opened...";

echo 
'
<div class="post">
<div class="postheader"><h1>View Ticket Status - ID '. $get["id"] .'</h1></div>
<div class="postcontent">
<p>Title: '. $get["tickets.title"] .' - Posted on: '. $get["tickets.date"] .'</p>
<p>Ticket Status: '. $status[$get["tickets.status"]] .'</p>
<p>Question: '. nl2br($get["tickets.question"]) .'</p>
</div>
<div class="postfooter"></div>
</div>
';

}
else
{
echo 
'
<div class="post">
<div class="postheader"><h1>Error</h1></div>
<div class="postcontent">
<p>This is not your ticket. You only have permission to view your tickets. Please go back.</p>
</div>
<div class="postfooter"></div>
</div>
';
}
?>
</div>
</div>
</div>
</body>
</html>

Hello   We have a database table that confirms the installations started and completed for our game... and I am looking to confirm how many installs start but never complete...   So, this is my current query...

SELECT description, ip from error_log where description like '%install%' order by ip;