PHP - Jarken Values Problem

I am having trouble with passing values with a POST to another php file.  I am getting the error :  undefined index : productID and undefined index: filename.  I have also tried :  <form   method = \"POST?pdib=$processID&filename=$filename\" action = \"upload2.php\"  >  When I look at the array of superglobals, they are both defined.  Thank you! 

 Here is the code :

drawfirsttwoforms:

$sql = "SELECT ProductFilename, ProductName, ProductID, ProductDescription,ProductCost,ProductQuantity, ProductCatTitle FROM products 
INNER JOIN customers ON customers.CustomerID = products.CustomerID 
WHERE ((products.ProductKeyWord1 = ?) 
OR (products.ProductKeyWord2 = ?) OR (products.ProductKeyWord3 = ? ))  AND (products.ProductCatTitle = ?) ";

$stmt = $dbo->prepare($sql);
$stmt->bindParam(1, $keyword1);
$stmt->bindParam(2, $keyword1);
$stmt->bindParam(3, $keyword1);
$stmt->bindParam(4, $titleOfSelectedDropDown);

$stmt->execute();

while ($row = $stmt->fetch()) {

//these variables do have values here
$productID = $row['ProductID'];
$filename = $row['ProductFilename'];

$string1 .=  "  
<div  class = \"A\" id = \"$mainDiv\">
<p id = \"link1\">product id   :$productID</p>
<p>category id  :$category</p>
<div class = \"A\" id = \"endz\"></div>
<div class = \"A\" id = \"startz\"></div>
<div class=\"container\">
<div id = \"testing\" >testing <div>
<div id = \"$displayID\" >  </div>
<div class=\"row\" >
<div class=\"col\">
	
	<form   method = \"POST\" action = \"upload2.php\"  >
      
      
    
	<input type=hidden id='$productID' name= '$productID' value=\"A\">
	<input type=hidden id=\"$filename\" name=$filename value=\"B\">
	
      
      
      <button value = \"Submit\" type = \"submit\"  >submit it</button>
	</form>
	<iframe id=\"upload_target\" name=\"upload_target\"  style=\"width:0;height:0;border:0px solid #fff;\"></iframe> 
	<img width=\"120\" height =\"120\"  id = \"$imageID\"  src=\"../php proj/uploads/$filename?<?php echo filemtime($filename)?>\">
	<button    onclick = \"imageRefresh( '{$filename}', '{$imageID}', '{$_SESSION["msg"]}' )\" >Display</button>
	</div>


AFTER:
  

if (!isset($myObj) && isset($string1))
{
$myObj = new stdClass();
$myObj->htmlstuff = $string1;


//Encode the data as a JSON string
$jsonStr = json_encode($myObj);
echo $jsonStr;
}

 

function printHTML1(keyword){ 
	
	
	const element = document.getElementById("dropDown1");
		
	//const checkValue = element.options[element.selectedIndex].value;
	const checkText = element.options[element.selectedIndex].text;
	
	var val1 = checkText;

	var xmlhttp = new XMLHttpRequest();
	
	
	var keyword1 = keyword;
	var url = "drawfirsttwoforms.php?keyword=" + keyword.value + "&" + "val1=" + val1;
	


	xmlhttp.onreadystatechange = function() {
		
	if (this.readyState == 4 && this.status == 200) {
		
		
		var jsonData = JSON.parse(this.responseText);
		var answerHtml = jsonData.htmlstuff;
		document.getElementById("codehere").innerHTML = answerHtml;

		createAndModifyDivs();


		}
	};
	
	xmlhttp.open("GET", url , true);
	
	xmlhttp.send();
	
	
}

 

upload2.php


<?php
session_start();
$productID = $_POST['productID'];
$filename = $_POST['filename'];

 

hi guys

I have two functions and they work well, but now i have a problem in the last if

the email is sent like www.yoursite.com/reset_password.php?userid=0&code=

and not http://your.url/set_new_password.php?userid=564979&code=54c4a2767c2f485185ab72cdcf03ab59

so, the problem is that i can get the value of hash and the userid.
If i do an echo "$hash" in the function code(); it shows the value like 564979&code=54c4a2767c2f485185ab72cdcf03ab59
my question is, how i can do the same in the last if? above two functions. Same occur in the last select select userid from password_reset where code=? none userid is showed, it is always zero.


Code: [Select]
<?
function check($sql, $db, $email) {
if(!empty($_POST['email'])) {

$email = $_POST["email"];
if ($sql = $db->prepare("select email from users where email=?")) {
$sql->bind_param('s', $email);

$sql->execute();

$sql->bind_result($email);

if ($sql->fetch()) {
return true;
}
else {
return false;
}
}
}
}



function code($sql, $db, $hash, $pwdHasher, $userExists, $sendPass) {

if (check($sql, $db, $email)) {

$pwdHasher = new PasswordHash(8, FALSE);

$hash = $pwdHasher->HashPassword($userExists["email"]);

$sendPass=$hash;
($sql = $db->prepare('insert into password_reset (code) values (?)'));
$sql->bind_param('s', $hash);

$sql->execute();
$sql->fetch();
return true;
}
}




if (code($sql, $db, $hash, $pwdHasher, $userExists, $sendPass)) {
($sql = $db->prepare("select userid from password_reset where code=?"));

$sql->bind_param('s', $hash);
$sql->execute();
$sql->bind_result($hash);
$sql->fetch();
echo $hash;
$pwrurl = "www.yoursite.com/reset_password.php?userid=" .$hash . "&code=" . $sendPass;

$mailbody = "Dear user,<br><br>If this e-mail does not apply to you please ignore it. It appears that you have requested a password reset at our website www.yoursitehere.com<br>
To reset your password, please click the link below. If you cannot click it, please paste it into your web browser's address bar.<br> <a href='$pwrurl'>$pwrurl</a>  <br> <br>
Thanks,\nThe Administration";

$mail->MsgHTML($mailbody);

$mail->AddAddress($email,"Membro");

$mail->IsHTML(true);

if(!$mail->Send()) {
echo "Deu erro: " . $mail->ErrorInfo;
} else {
echo "Enviado com sucesso";
}


$sql->close();
$db->close();

}


?>



any help?

thanks

Hey,
Im needing some help with an update form that I have created using PHP/MySQL. Basically the form is working great (updating records, retrieving records and showing errors) but there is a problem with the errors.

If there are no errors and I edit the existing text input values, the database updates fine. However if I edit the existing text input values and there is an error, the edited input values dont save, they revert back to the values of the database.

I understand why this is happening, its because the text inputs are set to show the values of the database so if i edit the existing values and an error occurs or the page is refreshed, the values revert back to the database values. However id like it so that if any text in the text field have been edited and an error occurs, the text stays to how it is until the user by passes any errors and then the database is updated.

Hopefully this makes sense. I have attached the php page just incase anybody wants to look into it but any help would be much appreciated!

Also, im not looking for someone to just to fix this for me but if someone knows my problem and can guide me in the right direction, that would be great.

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

Hi,

My company has 240+ locations and as such some users (general managers) cover multiple sites.  When I run a query to pull user information, when the user has multiple sites to his or her name, its adds the second / third sites to the next columns, rather than wrapping it inside the same table cell.  It also works the opposite way, if a piece of data is missing in the database and is blank, its pull the following columns in.  Both cases mess up the table and formatting.  I'm extremely new to any kind of programming and maybe this isn't the forum for this question but figured I'd give it a chance since I'm stuck.

The HTML/PHP code is below:

<table id="datatables-column-search-select-inputs" class="table table-striped" style="width:100%">

                                        <thead>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                                <th>Actions</th>

                                            </tr>

                                        </thead>

                                        <tbody>

                                            <?php

                                            //QUERY TO SELECT ALL USERS FROM DATABASE

                                            $query = "SELECT * FROM users";

                                            $select_users = mysqli_query($connection,$query);

                                            

                                            // SET VARIABLE TO ARRAY FROM QUERY

                                            while($row = mysqli_fetch_assoc($select_users)) {

                                                $user_id = $row['user_id'];

                                                $user_firstname = $row['user_firstname'];

                                                $user_lastname = $row['user_lastname'];

                                                $username = $row['username'];

                                                $user_phone = $row['user_phone'];

                                                $user_image = $row['user_image'];

                                                $user_title_id = $row['user_title_id'];

                                                $user_role_id = $row['user_role_id'];

                                            

                                                // POPULATES DATA INTO THE TABLE

                                                echo "<tr>";

                                                echo "<td>{$user_id}</td>";

                                                echo "<td>{$user_firstname}</td>";

                                                echo "<td>{$user_lastname}</td>";

                                                echo "<td>{$username}</td>";

                                                echo "<td>{$user_phone}</td>";

                                            

                                                //PULL SITE STATUS BASED ON SITE STATUS ID

                                                $query = "SELECT * FROM sites WHERE site_manager_id = {$user_id} ";

                                                $select_site = mysqli_query($connection, $query);

                                                while($row = mysqli_fetch_assoc($select_site)) {

                                                    $site_name = $row['site_name'];

                                                    echo "<td>{$site_name}</td>";

                                                }

                                                echo "<td>{$user_title_id}</td>";

                                                echo "<td>{$user_role_id}</td>";

                                                echo "<td class='table-action'>

                                                    <a href='#'><i class='align-middle' data-feather='edit-2'></i></a>

                                                    <a href='#'><i class='align-middle' data-feather='trash'></i></a>

                                                    </td>";

                                                //echo "<td><a href='users.php?source=edit_user&p_id={$user_id}'>Edit</a></td>";

                                                echo "</tr>";

                                            }   

                                            ?>

 

                                            <tr>

                                                <td>ID</td>

                                                <td>FirstName</td>

                                                <td>LastName</td>

                                                <td>Username</td>

                                                <td>Phone #</td>

                                                <td>Location</td>

                                                <td>Title</td>

                                                <td>Role</td>

                                                <td class="table-action">

                                                <a href="#"><i class="align-middle" data-feather="edit-2"></i></a>

                                                <a href="#"><i class="align-middle" data-feather="trash"></i></a>

                                                </td>

                                            </tr>

                                        </tbody>

                                        <tfoot>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                            </tr>

                                        </tfoot>

                                    </table>

Hi all,

Just curious why this works:

Code: [Select]
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')";
}
And this does not:

$headdata_1 = "'$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]'";
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values($headdata_1)";
}it puts $data[#'s] in the database fields instead of the actual data that '$data[0]','$data[1]'... relates to.

I wrote a script to create the values in $headdata_1 based on the number of headers in $csvheaders1 but can't seem to get it working in the sql statement.

Thanks

Hi all,

I'm a first time poster here and I would really appreciate some guidance with my latest php challenge! I've spent the entire day googling and reading and to be honest I think I'm really over my head and need the assistance of someone experienced to advise the best way to go!

I have a multi dimensional array that looks like (see below); the array is created by CodeIgniter's database library (the rows returned from a select query) but I think this is a generic PHP question as opposed to having anything to do with CI because it related to working with arrays.

I'm wondering how I might go about searching the array below for the key problem_id and a value equal to a variable which I would provide. Then, when it finds an array with a the matching key and variable, it outputs the other values in that part of the array too.

For example, using the sample data below. How would you recommend that I search the array for all the arrays that have the key problem_id and the value 3 and then have it output the value of the key problem_update_date  and the value of the key problem_update_text. Then keep searching to find the next occurrence?

Thanks in advance, as above, I've been searching really hard for the answer and believe i'm over my head!

Output of print_r($updates);

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #30
    [result_id] => Resource id #35
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 5
    [row_data] => 
)


Output of print_r($updates->result_array());

Array
(
    [0] => Array
        (
            [problem_update_id] => 1
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Some details about a paricular issue
            [problem_update_active] => 1
        )

    [1] => Array
        (
            [problem_update_id] => 4
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Another update about the problem with an ID of 3
            [problem_update_active] => 1
        )

    [2] => Array
        (
            [problem_update_id] => 5
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of four
            [problem_update_active] => 1
        )

    [3] => Array
        (
            [problem_update_id] => 6
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of 6
            [problem_update_active] => 1
        )

    [4] => Array
        (
            [problem_update_id] => 7
            [problem_id] => 3
            [problem_update_date] => 2010-10-12
            [problem_update_text] => Some new update about the problem with the ID of 3
            [problem_update_active] => 1
        )

)

Hello, I have read tutorials, searched forums for 2 weeks, and not found the assistance I require. I now jump in to ask my questions with the assistance from those much wiser then I...

I am new to this arena, so I honor your understanding to my situation.

I have 2 Solar Inverters that I have at my home, and I have a RS232 data port on each that is now connected to my home network via an IP converter to upload the data of the power they make each hour to a simple website I made, so I can see what is going on durring the hours I am at work. The information goes to my FTP site and the data falls into the MySQL table perfectly. I am trying to get the PHP and MySQL code to list the data into the forms/tables on the web page.

For this project I have set up Dreamweaver CS5 and a test server on my home PC, to get this working. All the data on the web host MySQL table is the same as in the test server (other then the host, name, and password but it works fine).

I have a very basic MySQL Named "inverters", and the table below named "feed"...

+---------+----------+------------+---------+------------+----------+
| Unit ID | Date | Time | Power | Volts | Current |
+---------+----------+------------+---------+------------+----------+
| 1 |YYYY-MM-DD| 12:00:00 | 560 | XXXX | XXXX |
+---------+----------+------------+---------+------------+----------+
| 1 |YYYY-MM-DD| 13:00:00 | 565 | XXXX | XXXX |
+---------+----------+------------+---------+------------+----------+
| 1 |YYYY-MM-DD| 14:00:00 | 890 | XXXX | XXXX |
+~~~~~~+~~~~~~+~~~~~~~~+~~~~~~+~~~~~~~+~~~~~~~+

Etc....

The 'Time' has 24 rows for each day, each 'Date" shows the same date for each of the 24 rows of 'Time".

The 'Power', is assigned as double the Volts and Current are "float".

I am able to SUM the Total "Power" of all the "Power" Rows with...

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

mysql_select_db("inverters", $con);
$qry = mysql_query(" SELECT SUM(Power) AS total FROM feed ");
$row = mysql_fetch_assoc($qry);
echo $row['total'];
mysql_close($con);
?>

I have been trying for weeks to get "the CURRENT DAY power", Week Power, the month power etc to show the data on the webpage with no luck.

A very simple table on the website... As seen on the website.

+-----------+----------------+-----------------+-----------------+
| Today | This Month | This Year | Lifetime Power |
+-----------+----------------+-----------------+-----------------+
|????????| ??????????|???????????|----working----|
+-----------+----------------+-----------------+-----------------+

For the Current Day, I have tried this, but it does not work...

$query = mysql_query("SELECT(date), SUM(Power) AS 'day_total' FROM feed WHERE (date) = CURDATE() GROUP BY (date) ORDER BY (date) ");
$result = mysql_fetch_array($query);
$daytotal = $result["day_total"];
echo $row['day_total'];
mysql_close($con);

For the Month, I have tried this, but it does not work...

$query = mysql_query("SELECT MONTH(date), SUM(Power) AS month_total FROM feed GROUP BY Month(date)");
$result = mysql_fetch_array($query);
echo $row['month_total'];
mysql_close($con);

For the YEAR, I have tried this, but it does not work...

$query = mysql_query("SELECT date, SUM(Power) AS total FROM feed GROUP BY date");
$result = mysql_fetch_array($query);
echo $row['year_total'];
mysql_close($con);

I am reading and reading. Online I see how to get user names, and the time they register, and how many 'visitor' hits per year or month etc, but none have been informative to my situation. I think the more I read on the PHP and MySQL website manual, the more stupid I have become...

Using Google to seach "how to get the SUM of Current Date" only showes me how to enter the current date on a webpage or in a table row, not how to SUM the values of a table of the current day.

I also want to have a PHP graph (I have PHPgraphLIB now) on another page, and control the graph images by using a simple "Date Picker" or calendar, but that ran into the same type of issues as anything I write does not generate or show the results. I spent days using Prototype.js calendars and AJAX to connect the server side to the graphs and calendar etc..., but that is a different issue... hahaha

I would greatly honor any assistance to my learning and functioning of this.

Thank You,

Alan

Hey! How've you been? This should be simple but I can't make it work. I have a few database values from a user entry. The page queries the database and I can print them no problem. I want to add them and display the total of these values. I've tried about two dozen ways of doing and I just can't get them to add. Where I have "fee_total" I want it to be the sum of the values "fee+upgrade7+tax". This is the snippet of what I'm working on. I won't attach any of what I have tried because, well, there are too many attempts and nothing worked

    $sql = ("SELECT * FROM Teamregister WHERE pkSoloregisterID=$pkSoloregisterID");
    $query = mysql_query($sql);
    $result = mysql_query($sql);
    $myrow = mysql_fetch_array($result);

    printf ('<form action="https://www.mysite.com/cgi-bin/webscr" method="post">
      <p>Your registration fee is <strong>$%s</strong>.</p>', $myrow['total_fee']);
      echo ("<input type='hidden' name='item_name_1' value='Registration Fee'>");
      printf ('<input type="hidden" name="amount_1" value="%s">', $myrow['total_fee']);
      echo ("<br /><div align='center'>
      <input type='submit'' value='Pay Online'>
      </form>');

Make sense? Like I said, the values are already there but the math isn't happening. To check I tried using individual DB values instead of "total_fee" and the numbers show up. Just cannot get them to add.

How do you get the values in an array and name them as variables?

Lets say I want the 0 and the 2...

Array ( => 02.02.2011 [1] => 97% [2] => 538 [3] => 20 [4] => 63,247 (2.20) [5] => 77,639 [6] => 195,617 [7] => 09.13.2010 )

I've got two tables (classOfferings, instructors). The fields I'm dealing with are 'co.instructorId', 'i.instructorId', 'i.fName', 'i.lName'.
I have a form with dynamically generated drop downs.
What I would like to do is check classOfferings table to see which instructors are teaching classes then display them in drop down with the 'instructorId' as the value and 'fName' and 'lName' as the user selectable part.  So I have found the distinct 'instructorId', but I can't make 'fName' and 'lName' appear as the user selectable part.
The code below produces a drop down which has invisible values, but still posts a value.

<select size="1" name="instructor">
<option value="" selected>Search By Teacher...</option>
<?

$instrList=mysql_query("select distinct instructorId from classOfferings order by instructorId asc");
$instrNameList=mysql_query("select fName, lName from instructors where classOfferings.instructorId = instructors.instructorId order by lName asc");

// Show records by while loop.
while($instructor_list=mysql_fetch_assoc($instrList)){
$instrNames = ($instr_Name['fName']) . ($instr_Name['lName']);
?>
<option value="<? echo $instructor_list['instructorId']; ?>" <? if($instructor_list['instructorId']==$select){ echo "selected"; } ?>>
<? echo $instrNames; ?></option>
<?
// End while loop.
}
?>

</select>

This topic has been moved to MySQL Help.

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

I connected to a database.  i want to know how i can get the value out of that field and add it to the values of another.  i don't want to make any changes to the database.  i just want to use the values for coding.  please, if anyone knows how to do this, let me know.

hi guys hope some1 can help. 

im creating a system that will allow stock to be added to a database and modifed.  However on the add section, nothing adds it only inputs a new id row in the database and the other fields are blank.   Can anyone have a look for me
This sections is the form handler once the user has input a stockname and stock qty


Code: [Select]
<?php
session_start();


?>

<!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=utf-8" />
<title>stock</title>
</head>

<body>
<?php
$stockname = &$_POST['stockname'];
$stockqty = &$_POST['stockqty'];


$connect = mysql_connect("localhost","root", "") or die ("Couldn't Connect!");
mysql_select_db("stock", $connect) or die("Couldn't find db"); // select database

$query = mysql_query("SELECT * FROM stocks WHERE stockname=$stockname, stockqty=$stockqty");
$numrows = mysql_num_rows($query);


if ($numrows!=0)
{
echo("Item already exists!  Try Updating the items instead!");
}
else
{
$queryreg = mysql_query("INSERT INTO `stock` . `stocks` (`id`, `stockname`, `stockqty`) VALUES (NULL,'$stockname','$stockqty')");

echo("stock added!");
}


?>
<center><table>
<tr>
    <td>
       
        Stock_id
        </td>
        <td>
       
        Stock_name
        </td>
        <td>
       
        Stock_Qty
        </td>
    </tr>
</table></center>
</body>
</html>

Thanks


Lance

Hi,

I've can use the following URL to filter the query below:

www.mysite.com?levels=PreK
...this will show me alll the PreK members.

www.mysite.com?levels=Elem
...this will show me all the Elem members.

How do I filter it to show both me BOTH the PreK and Elem members?

Do I need to change the query?

        WHERE ((user_info.Type LIKE '$Type%')
                and ((user_info.snr_First LIKE '%$name%')
                or (user_info.snr_Last LIKE '%$name%'))
      and (user_info.snr_Home_phone LIKE '$snr_Home_phone%')
    and (user_info.snre_eMail LIKE '$snre_eMail%')
    and ((user_info.PreK LIKE '$levels%')
or (user_info.Elem LIKE '$levels%')
or (user_info.MS LIKE '$levels%')
or (user_info.HS LIKE '$levels%')
or (user_info.College LIKE '$levels%')
        or (user_info.Admin LIKE '$levels%')
                or (user_info.Prvt LIKE '$levels%')))
         ORDER BY user_info.$sort LIMIT $eu, $limit ";
$result = mysql_query($query);

Thanks.

~Wayne