I have built a quote generator that now is going to be updated.
This is my code at the moment:
What I want to do:
The user selects wich client they are quoting for
Then they add hours the job will take then select a, b or c depending on what rate they are charged at
This goes to another page that gives the results, no problem with this it all works but what I nned it to do is:
The clients all have different charge rates so when the client is chosen from the dropdown I want the a, b or c etc to default to the top of the a,b,c menus so the user does not have to keep looking up what rate thay are charged at.
Below the full page code:
PHP Code:
<?php require_once( 'Connections/grey.php' ); ?>
if (! function_exists ( "GetSQLValueString" )) {
GetSQLValueString ( $theValue , $theType , $theDefinedValue = "" , $theNotDefinedValue = "" )
$theValue = get_magic_quotes_gpc () ? stripslashes ( $theValue ) : $theValue ;
$theValue = function_exists ( "mysql_real_escape_string" ) ? mysql_real_escape_string ( $theValue ) : mysql_escape_string ( $theValue );
$theType ) {
"text" :
$theValue = ( $theValue != "" ) ? "'" . $theValue . "'" : "NULL" ;
"long" :
"int" :
$theValue = ( $theValue != "" ) ? intval ( $theValue ) : "NULL" ;
"double" :
$theValue = ( $theValue != "" ) ? "'" . doubleval ( $theValue ) . "'" : "NULL" ;
"date" :
$theValue = ( $theValue != "" ) ? "'" . $theValue . "'" : "NULL" ;
"defined" :
$theValue = ( $theValue != "" ) ? $theDefinedValue : $theNotDefinedValue ;
$theValue ;
mysql_select_db ( $database_grey , $grey );
$query_rsDesignCost = "SELECT * FROM designcosts" ;
$rsDesignCost = mysql_query ( $query_rsDesignCost , $grey ) or die( mysql_error ());
$row_rsDesignCost = mysql_fetch_assoc ( $rsDesignCost );
$totalRows_rsDesignCost = mysql_num_rows ( $rsDesignCost );
mysql_select_db ( $database_grey , $grey );
$query_rsArtworkCost = "SELECT * FROM artworkcost" ;
$rsArtworkCost = mysql_query ( $query_rsArtworkCost , $grey ) or die( mysql_error ());
$row_rsArtworkCost = mysql_fetch_assoc ( $rsArtworkCost );
$totalRows_rsArtworkCost = mysql_num_rows ( $rsArtworkCost );
mysql_select_db ( $database_grey , $grey );
$query_rsMarkup = "SELECT * FROM markup" ;
$rsMarkup = mysql_query ( $query_rsMarkup , $grey ) or die( mysql_error ());
$row_rsMarkup = mysql_fetch_assoc ( $rsMarkup );
$totalRows_rsMarkup = mysql_num_rows ( $rsMarkup );
mysql_select_db ( $database_grey , $grey );
$query_rsClient = "SELECT * FROM ClientCode" ;
$rsClient = mysql_query ( $query_rsClient , $grey ) or die( mysql_error ());
$row_rsClient = mysql_fetch_assoc ( $rsClient );
$totalRows_rsClient = mysql_num_rows ( $rsClient );
?>
<html>
<?php
do {
?>
<option value="<?php echo $row_rsClient [ 'Client' ] ?> "><?php echo $row_rsClient [ 'Client' ] ?> </option>
<?php
} while ( $row_rsClient = mysql_fetch_assoc ( $rsClient ));
$rows = mysql_num_rows ( $rsClient );
$rows > 0 ) {
mysql_data_seek ( $rsClient , 0 );
$row_rsClient = mysql_fetch_assoc ( $rsClient );
?>
</select>
<?php
do {
?> <option value="<?php echo $row_rsDesignCost [ 'Cost' ] ?> "<?php if (!( strcmp ( $row_rsDesignCost [ 'Cost' ], $row_rsClient [ 'Design' ]))) {echo "selected=\"selected\"" ;} ?> ><?php echo $row_rsDesignCost [ 'Code' ] ?> </option>
<?php
} while ( $row_rsDesignCost = mysql_fetch_assoc ( $rsDesignCost ));
$rows = mysql_num_rows ( $rsDesignCost );
$rows > 0 ) {
mysql_data_seek ( $rsDesignCost , 0 );
$row_rsDesignCost = mysql_fetch_assoc ( $rsDesignCost );
?>
</select></td>
<?php
do {
?> <option value="<?php echo $row_rsArtworkCost [ 'Cost' ] ?> "<?php if (!( strcmp ( $row_rsArtworkCost [ 'Cost' ], $row_rsClient [ 'Artwork' ]))) {echo "selected=\"selected\"" ;} ?> ><?php echo $row_rsArtworkCost [ 'Code' ] ?> </option>
<?php
} while ( $row_rsArtworkCost = mysql_fetch_assoc ( $rsArtworkCost ));
$rows = mysql_num_rows ( $rsArtworkCost );
$rows > 0 ) {
mysql_data_seek ( $rsArtworkCost , 0 );
$row_rsArtworkCost = mysql_fetch_assoc ( $rsArtworkCost );
?>
</select></td>
<?php
do {
?>
<option value="<?php echo $row_rsMarkup [ 'percent' ] ?> "><?php echo $row_rsMarkup [ 'Code' ] ?> </option>
<?php
} while ( $row_rsMarkup = mysql_fetch_assoc ( $rsMarkup ));
$rows = mysql_num_rows ( $rsMarkup );
$rows > 0 ) {
mysql_data_seek ( $rsMarkup , 0 );
$row_rsMarkup = mysql_fetch_assoc ( $rsMarkup );
?>
</select></td>
<?php
do {
?>
<option value="<?php echo $row_rsMarkup [ 'percent' ] ?> "><?php echo $row_rsMarkup [ 'Code' ] ?> </option>
<?php
} while ( $row_rsMarkup = mysql_fetch_assoc ( $rsMarkup ));
$rows = mysql_num_rows ( $rsMarkup );
$rows > 0 ) {
mysql_data_seek ( $rsMarkup , 0 );
$row_rsMarkup = mysql_fetch_assoc ( $rsMarkup );
?>
</select></td>
<?php
do {
?>
<option value="<?php echo $row_rsMarkup [ 'percent' ] ?> "><?php echo $row_rsMarkup [ 'Code' ] ?> </option>
<?php
} while ( $row_rsMarkup = mysql_fetch_assoc ( $rsMarkup ));
$rows = mysql_num_rows ( $rsMarkup );
$rows > 0 ) {
mysql_data_seek ( $rsMarkup , 0 );
$row_rsMarkup = mysql_fetch_assoc ( $rsMarkup );
?>
</select></td>
<?php
do {
?>
<option value="<?php echo $row_rsMarkup [ 'percent' ] ?> "><?php echo $row_rsMarkup [ 'Code' ] ?> </option>
<?php
} while ( $row_rsMarkup = mysql_fetch_assoc ( $rsMarkup ));
$rows = mysql_num_rows ( $rsMarkup );
$rows > 0 ) {
mysql_data_seek ( $rsMarkup , 0 );
$row_rsMarkup = mysql_fetch_assoc ( $rsMarkup );
?>
</select></td>
<?php
do {
?>
<option value="<?php echo $row_rsMarkup [ 'percent' ] ?> "><?php echo $row_rsMarkup [ 'Code' ] ?> </option>
<?php
} while ( $row_rsMarkup = mysql_fetch_assoc ( $rsMarkup ));
$rows = mysql_num_rows ( $rsMarkup );
$rows > 0 ) {
mysql_data_seek ( $rsMarkup , 0 );
$row_rsMarkup = mysql_fetch_assoc ( $rsMarkup );
?>
</select></td>
<?php
do {
?>
<option value="<?php echo $row_rsMarkup [ 'percent' ] ?> "><?php echo $row_rsMarkup [ 'Code' ] ?> </option>
<?php
} while ( $row_rsMarkup = mysql_fetch_assoc ( $rsMarkup ));
$rows = mysql_num_rows ( $rsMarkup );
$rows > 0 ) {
mysql_data_seek ( $rsMarkup , 0 );
$row_rsMarkup = mysql_fetch_assoc ( $rsMarkup );
?>
</select></td>
<?php
do {
?>
<option value="<?php echo $row_rsMarkup [ 'percent' ] ?> "><?php echo $row_rsMarkup [ 'Code' ] ?> </option>
<?php
} while ( $row_rsMarkup = mysql_fetch_assoc ( $rsMarkup ));
$rows = mysql_num_rows ( $rsMarkup );
$rows > 0 ) {
mysql_data_seek ( $rsMarkup , 0 );
$row_rsMarkup = mysql_fetch_assoc ( $rsMarkup );
?>
</select></td>
<?php
do {
?>
<option value="<?php echo $row_rsMarkup [ 'percent' ] ?> "><?php echo $row_rsMarkup [ 'Code' ] ?> </option>
<?php
} while ( $row_rsMarkup = mysql_fetch_assoc ( $rsMarkup ));
$rows = mysql_num_rows ( $rsMarkup );
$rows > 0 ) {
mysql_data_seek ( $rsMarkup , 0 );
$row_rsMarkup = mysql_fetch_assoc ( $rsMarkup );
?>
</select></td>
<?php
do {
?>
<option value="<?php echo $row_rsMarkup [ 'percent' ] ?> "><?php echo $row_rsMarkup [ 'Code' ] ?> </option>
<?php
} while ( $row_rsMarkup = mysql_fetch_assoc ( $rsMarkup ));
$rows = mysql_num_rows ( $rsMarkup );
$rows > 0 ) {
mysql_data_seek ( $rsMarkup , 0 );
$row_rsMarkup = mysql_fetch_assoc ( $rsMarkup );
?>
</select></td>
<?php
do {
?>
<option value="<?php echo $row_rsMarkup [ 'percent' ] ?> "><?php echo $row_rsMarkup [ 'Code' ] ?> </option>
<?php
} while ( $row_rsMarkup = mysql_fetch_assoc ( $rsMarkup ));
$rows = mysql_num_rows ( $rsMarkup );
$rows > 0 ) {
mysql_data_seek ( $rsMarkup , 0 );
$row_rsMarkup = mysql_fetch_assoc ( $rsMarkup );
?>
</select></td>
<?php
( $rsArtworkCost );
mysql_free_result ( $rsMarkup );
mysql_free_result ( $rsClient );
?>
Linear Mode
