PHP - Help With For Loop, Checking For 2 Array Variables

This is really blowing my mind... the code is as follows the table, the column names everything is right and contains information but the variables aren't being filled... I don't get it... Anyone have any ideas or options I might not have thought of for debugging?


                        $item_name = ("SELECT * FROM items WHERE id = '$grab_item'");
$que_items = mysql_query($item_name);
while ($item_todel = mysql_fetch_array($que_items, MYSQL_BOTH)) {
$name = $item_todel['name'];
$desc = $item_todel['desc'];
}
echo ($name . "<br>" . $desc . "<br>" . $grab_item);


the only variable thats set is grab_item, fetch_array throws no errors, if I plug in the query straight to the sql I get all the proper information... It's just not filling the two variables....

First page adds a new job number, then the order page loaded with the job number id as a get id. Basically there is a while loop in the order page which shows products/services client can order and he chooses what he requires 'one or eight services' (8 in total) and some other variables like date of order and client name etc. Here is the order item code

The first sql statement executes fine, but in the second sql query nothing happens


$sql="insert into job_order(order_num,order_date,order_customer_id, order_remarks) values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');"; $res=mysql_query($sql);  $id=mysql_insert_id();   foreach($_POST as $key => $value) {          if(!empty($value)) {           $key.' => '.trim(strip_tags($value));            $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES ('$_GET[id]','$value','$value','$value');"; $orderres=mysql_query($order) or die(mysql_error()); } }?>$sql="insert into job_order(order_num,order_date,order_customer_id,
order_remarks)
values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');";
$res=mysql_query($sql);

$id=mysql_insert_id();


foreach($_POST as $key => $value) {


        if(!empty($value)) { 
 
         $key.' => '.trim(strip_tags($value));  
     
         $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES
('$_GET[id]','$value','$value','$value');";
$orderres=mysql_query($order) or die(mysql_error());
}
}
?>



=============

This is the formI have removed parts which are irrelevant. Please note that dateBox and companyBox are not required to be looping as they are only for first table,



echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";?><table><tr><td><h4>JOB ORDER</H4></TD><TD></TD></TR><TR><TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td></tr><tr><td>ORDER DATE</td><td><input type=text name=dateBox></td></tr> <tr><td>COMPANY NAME</td><td><?PHP$sql="select * from customers";$res=mysql_query($sql);echo "<select name=companyBox><option value=''>Please select</option>";WHILE($fetch=mysql_fetch_assoc($res)){ echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";} echo "</select>"; echo "</td></tr>"; ?>   </table> <table><tr><th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th></tr><tr><?PHP$sql="select * from products";$res=mysql_query($sql); WHILE($fetch=mysql_fetch_assoc($res)){ echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td><td><input type=text name=quantBox></td><td><input type=text name=teethBox></td>";echo "</tr>";}echo "</table>";?>echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";
?>
<table>
<tr>
<td><h4>JOB ORDER</H4></TD><TD></TD>
</TR>
<TR>
<TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td>
</tr>
<tr>
<td>ORDER DATE</td><td><input type=text name=dateBox></td>
</tr>

<tr>
<td>COMPANY NAME</td><td>
<?PHP
$sql="select * from customers";
$res=mysql_query($sql);
echo "<select name=companyBox><option value=''>Please select</option>";
WHILE($fetch=mysql_fetch_assoc($res)){

echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";}
echo "</select>";
echo "</td></tr>";
?>



</table>

<table>
<tr>
<th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th>
</tr>
<tr>
<?PHP
$sql="select * from products";
$res=mysql_query($sql);

WHILE($fetch=mysql_fetch_assoc($res)){

echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td>
<td><input type=text name=quantBox></td>
<td><input type=text name=teethBox></td>";
echo "</tr>";}
echo "</table>";
?>



HERE IS THE IMAGE showing the populated services.
http://dubads.com/images/order.jpg

Hi.
I'm still very new to this forum, so i may be asking this the wrong way.
I'm working on a project, but i keep running into the same wall.
Whenever i try to load a page with a variable i named on another page, i get an error telling me that it does not know that variable.
But how do i make it check for the variable before using it?
Example of my code (i only show the first part, as it is the only one relevant):
Code: [Select]
<html><body>
<?php

session_start();
if($_SESSION['username']);
{
$username = $_SESSION['username'];
As you can see i have tried to deal with it using an if statement, but i still get the error.
I bet there is a very simple way to do this, but i cant see it right now.

Hi,

Im trying to generate a random 4- digit code, and then check if it is allready in the database.

My current code is below, but im not sure how to make it loop again, if the code exists.

Also, im not sure if this is the best way of doing this, maybe someone could suggest something better...


This is basicly what im trying to do:
1. hash the code
2. check if it exits in the DB
3. if it does, re-generate, and repeat 2., if not, return it





function getUniqueHash() {
global $mysql_server, $mysql_user, $mysql_password;

$code = substr(md5(uniqid(rand(), true)), 0, 4);

mysql_connect($mysql_server, $mysql_user, $mysql_password); // connect //
$sql = "SELECT * FROM `$mysql_db`.`short` WHERE `short` = '$code'";
$result = mysql_query($sql);
$results = mysql_numrows($result);
if($results > 0) {
//GO BACK AND RE-GENERATE CODE AND REPEAT CHECK
} else {
return $code;
}
mysql_close();
}

PasteBin:
Quote

http://paste.tgxn.net/?s=9

Hey everybody,

I have a script that I think should be working, but it's not...go figure

Here's the snippet that is causing and epic fail:

<?php

foreach($Array as $key => $value){
        $$value = $key;
       }

$checkVal = 'someValue';
$output = isset($$checkVal) ? TRUE : FALSE;

?>


As you can see it basically sets the value of the array element to a var var and then checks agains an input word. If the input word matched the varName of a set variable, we can then assume that word was in the array and return TRUE.

Pretty straight forward and I've tried about 3 different approaches to this, including:
in_array and flipping and checking for isset(array['value']).

The array that is being checked against is usually upwards of 15000 elements.

I would appreciate any knowledge that helps understand any issues in searching large arrays and good ways to get around them, or if it's just an error in my coding/logic, let me know!

Thank You all in advance.

E