jmatulevich

i have written a couple of nice databases with php frontends... one is a vendor card which keep track of all our vendors with what they sell, locations etc etc... this is managable by our sales staff, I also but a product Spec Form and a Customer requirments forms... these are very interactive and function quite well... The problem now is I am on Different servers with php 5 and some of the functions that worked before like " Update Set" are not working. I can write to the DB but cant update. If i started this on 5 then i would read and research it to get it working, but seems all the stuff I find online is what made it work in 4.3..... Thats where I am ... in the 4.3 to 5 void!... lol Jeff

i am missing something then... it still will not updating... I will play with it more... Thanks

BTW I do have many many years in HTML and Graphic Design. So this is just a natural expansion for me

i write very simple MySQL and PHP for our IntraNet... I use joomla, magento, etc for the webpages for the public. I would like to see how to do things a little more effectively. EG... I would take bits and pieces of code that function the way I want from many different posts and tutorials around and place it in my php in order to get it to function. I know that any professional would look at this code and say something like "OMG... why do it that way, when this is far less coding... ??" So a nice How to on MySQL and PHP5 building Databases and PHP from Scratch... Thanks

Being self taught and new to alot of this, I hope i don't bother you all too much... If anyone has a recommendation for a "How To:" I would be interested. Dallas, TX Jeff

I was able to get all the reads fixed by just enabling the registar_globals. And I am able to Create new records, but this does not update for some reason <?php mysql_query("UPDATE $table SET replacement_item = '$replacement_item' WHERE item_number = '$item_number'"); ?> Do i need to use $item_number = mysql_real_escape_string($_POST['item_number']); in this file also?... Sorry about the newb questions. I have very little mileage on this...

Fixed it ... Thanks so much... I need to probably re-write this entire thing... but once <?php $item_number = mysql_real_escape_string($_POST['item_number']); $result = mysql_query("SELECT * FROM $table WHERE item_number = '$item_number' "); while($row = mysql_fetch_array($result)) { echo $row['item_number']; } ?> The rest of the page filled in nicely

from a Form feeding the page... <FORM NAME="ViewItem" METHOD=POST ACTION="submit_view_item.php"> <div align="center"> <table width="275" border="0" align="center" bgcolor="#FFFFFF"> <tr> <td><div align="center" class="SubHeader">To VIEW Item Data <br> Select Item Number from List </div> <label></label></td> </tr> <tr> <td><div align="center"> <?php $query = "SELECT * FROM $table ORDER BY item_number"; $result = mysql_query($query) or die(mysql_error()); echo "<SELECT NAME=\"item_number\">\n"; while ($row = mysql_fetch_assoc($result)) { echo "<OPTION VALUE=\"$row[item_number]\">$row[item_number]</option>\n"; } echo "</SELECT>\n"; ?> <input type = "Submit" name = "Submit2" value = "Look-Up" /> </div></td> </tr> <tr> <td height="26"><div align="center"></div></td> </tr> </table> </div> </FORM>

I can hit the DB no problem.... However the code below is returning blank... is there a new Query for 5? ~~~~~~~~~~~~~~ <?php $result = mysql_query("SELECT * FROM $table WHERE item_number = '$item_number' "); while($row = mysql_fetch_array($result)) { echo $row['item_number']; } ?>