Page 1 of 1

Problem to check some values

Posted: Tue Apr 01, 2008 10:49 pm
by clauddiu
I have to generete fields dinamically from database thay are all text fields, this part of the codefor a moving company I do it for free but I get stuck :(

so this will be the edit part of the quote, the fields are genetared automatocalluy from the database, but Now I have to fil the values in each field was submited before.

this is the code, and it's show me only the first match insted of 5

Code: Select all

 
 
//the data from inventory field looks like:
 
/*
Arm Chair=1|
Bed – double/queen=2|
Desk (Student)=2|
Freezer=3|
Pictures=3
*/
 
// here is what I made\
 
// get the data from database
function GetFormValue($table, $field, $where){
 
    global $host, $user, $pass, $database;
    // Connecting, selecting database
    $link = mysql_connect($host,$user, $pass)
    or die('Could not connect: ' . mysql_error());
    //echo 'Connected successfully';
    mysql_select_db($database) or die('Could not select $database');
 
    // Performing SQL query
    $query = "SELECT * FROM `$table` $where";
    $result = mysql_query($query) or die('Query failed: ' . mysql_error());
    // Printing results in HTML
    while ($row = mysql_fetch_assoc($result)) {
 
        $cat =  $row[$field];
 
        return  $cat;
 
    }
    // Free resultset
    mysql_free_result($result);
 
    // Closing connection
    mysql_close($link);
}
 
 
 
// this is the parth where I generate the firlds again and I try to fill them with value from actual quote
 
 //   $mumu = array();
       $mumu = GetFormValue("quotes","inventory","where id='$QuoteID'");
 
       $dudu = explode("|",$mumu);
 
       $cac = count($dudu);
 
 
 
       $fd = array();
       $sanda =array();
       $panda =array();
           foreach ($dudu as $sd) {
    
            $fd = explode("=",$sd);
            //echo $fd[0], " | ", $fd[1],"<br>" ;
            $sanda[] = $fd[0];
            $panda[] = $fd[1];
           }
 
       $cc = count($sanda);
        $asas = 0;
       // get each row
       while($myrow = mysql_fetch_row($mysql_result)){
 
        //get data - eg, reading fields 0 and 1
        $tn = $myrow[0];
        $in= $myrow[1];
        $ln= $myrow[2];
        
        
        
        
        
        if ($numcolsprinted == $numcols) {
            print "</tr>\n<tr>\n";
            $numcolsprinted = 0;
        }
 
 
    if ($in == $sanda[$asas]){
            $out = "$in: <input type=\"text\" value=\"{$panda[$asas]}\" name=\"item|$in|$ln\" size=\"2\">\n";
        }else{
            $out = "$in: <input type=\"text\" value=\"0\" name=\"item|$in|$ln\" size=\"2\">\n";
    }   
            
        //$out = "$in: <input type=\"text\" value=\"0\" name=\"item|$in|$ln\" size=\"2\">\n";
            
 
 
 
 
 
 
        // output row from database
        echo "<td align=\"right\" bgcolor=\"#e2e0e8\">
        
            
            $out
            
        
        </td>\n";
 
        // bump up row counter
        $numcolsprinted++;
        $asas++;
 
       } // end while loop
 

Thank you guys for all your help!