MaxBodine

I am new to this. Using dreamweaver, php and mySQL. I will receive a xls file to upload into mySQL. One of the fields contains the Color, size and qty. I am not sure how to take these and populate a select list? Here is an example of 4 products and the data I get for each. It looks like I should be seperating them after each simicolon. I was reading split should not be used. Just lost. Thanks for any help, I attached a file to look at. Black -:- One Size ~ 0;Black -:- XL ~ 636;Red -:- One Size ~ 0;Red -:- XL ~ 232;White -:- XL ~ 0;White -:- One Size ~ 0 Red/White -:- XL ~ 168;Red/White -:- One Size ~ 0 Red/White -:- XL ~ 192 Light Pink -:- XL ~ 0;Light Pink -:- S/M ~ 0;Light Pink -:- M/L ~ 0;Black -:- S/M ~ 0;Black -:- M/L ~ 0;Black -:- XL ~ 0;White -:- S/M ~ 12;White -:- M/L ~ 0;White -:- XL ~ 0;Red -:- S/M ~ 20;Red -:- M/L ~ 0;Red -:- XL ~ 0 [attachment deleted by admin]

I have populated a dropdown list in Dreamweaver, which loads fine, but it is passing the first item of the list, not the selected one. Not sure why? ??? In a time crunch, Thanks for any help! <? mysql_select_db($database_connJDD, $connJDD); $query_rsSKU = "SELECT products.SKU FROM products"; $rsSKU = mysql_query($query_rsSKU, $connJDD) or die(mysql_error()); $row_rsSKU = mysql_fetch_assoc($rsSKU); $totalRows_rsSKU = mysql_num_rows($rsSKU); ?> <table align="center"> <tr> <td> <p align="center">Select SKU for <br /> Update Product </p> <form id="form5" name="form5" method="post" action="updateProducts.php?ProductNo=<?php echo $row_rsSKU['SKU']; ?>"> <select name="skuList"> <?php do { ?> <option value="<?php echo $row_rsSKU['SKU']?>"<?php if (!(strcmp($row_rsSKU['SKU'], $row_rsSKU['SKU']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rsSKU['SKU']?></option> <?php } while ($row_rsSKU = mysql_fetch_assoc($rsSKU)); $rows = mysql_num_rows($rsSKU); if($rows > 0) { mysql_data_seek($rsSKU, 0); $row_rsSKU = mysql_fetch_assoc($rsSKU); } ?> </select> <br /> <input name="Update" type="submit" value="Update" /> </form> </td> </tr> </table> <?php mysql_free_result($rsSKU); ?>

I have a drop down list that is populated from the database, which works, but I am passing the first item on the list, not the one selected. Not sure what I am doing wrong. I think it is in the action line, but not sure? Appreciate your help! <form id="updateProduct" name="updateProduct" method="post" action="updateProducts.php?ProductNo=<? echo $row_rsSKU['SKU']; ?>"> <div align="center"> <p>Product SKU <select name="selectSKU"> <?php do { ?> <option selected="selected" value="<?php echo $row_rsSKU['SKU']?>"<?php if (!(strcmp($row_rsSKU['SKU'], $row_rsSKU['SKU']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rsSKU['SKU']?></option> <?php } while ($row_rsSKU = mysql_fetch_assoc($rsSKU)); $rows = mysql_num_rows($rsSKU); if($rows > 0) { mysql_data_seek($rsSKU, 0); $row_rsSKU = mysql_fetch_assoc($rsSKU); } ?> </select> </p> <input type="submit" value="Edit this Product" /> </div> </form>

Hi, Tired Newbie here. I have set path for extentions, uncommented the extention for mysqli extention in php.ini, copied all dll files into required folders, restarted sever and I still get Class mysqli not found. Neither mysql or mysqli show in my info.php? Any ideas? I am on a time crunch ??? Thanks