Redrockhh Posted January 11, 2007 Share Posted January 11, 2007 Hello. I have a excel sheet with a master number of wrin numbers (product codes). It has a full number for example our full number is 0123-000 but the customer only uses 0123 but when they place the order they should use the full wrin but some choose not to. So here is what I am wanting to do. Create a database with all our full wrins in it. But I want to create a form that will full the partial wrin from the database and give me a full wrin. Link to comment https://forums.phpfreaks.com/topic/33738-database-query/ Share on other sites More sharing options...
fenway Posted January 11, 2007 Share Posted January 11, 2007 You mentioned "excel" and "database" in the same breath... expalin. Link to comment https://forums.phpfreaks.com/topic/33738-database-query/#findComment-158607 Share on other sites More sharing options...
Redrockhh Posted January 12, 2007 Author Share Posted January 12, 2007 I have an excel sheet that has all our master wrins in it. I know how to create the database and take the info from excel and input into the database. I just am not sure how to query the the database with a form to retrieve the full wrin from a partial Link to comment https://forums.phpfreaks.com/topic/33738-database-query/#findComment-158778 Share on other sites More sharing options...
fenway Posted January 12, 2007 Share Posted January 12, 2007 OK... you can search for LIKE '0123%', though that can be tricky if they don't all have the same length, or pull out the right "piece". Link to comment https://forums.phpfreaks.com/topic/33738-database-query/#findComment-159548 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.