-
Posts
780 -
Joined
-
Last visited
Everything posted by mikebyrne
-
I want the line that stops just above address to go down under the insert button. Any help doing this would be great At present my page is coded like this: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>e-commerce admin page sample |item</title> <link href="../Admin_files/admin.css" rel="stylesheet" type="text/css" /> <script type="text/JavaScript" src="../Admin_files/wrapper.js"></script> </head> <body> <div id="Box"> <div id="logoBox"><a href="http://www.btrax.com/" target="_blank"><img src="../Admin_files/logo.gif" width="51" height="125" border="0" /></a></div> <div id="contentBox"> <!-- logo start --> <div id="container"> <div class="padTop28"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- logo finish --> <!-- menu start --> <div id="container"> <div id="menu1"> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../admin_files/new.php" class="black">Order</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../admin_files/sales.php" class="black">Sales</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_on"><a href="../admin_files/list.php" class="black">Edit item</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../shipping/current.php" class="black">Postage fee</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_on"><!-- --></div> <div id="menu_text_off"><a href="../shipping/current.php" class="black_on">Add User</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../shipping/current.php" class="black">Add Product</a></div> <div id="menu_space1"><!-- --></div> </div> <div class="clr"><!-- --></div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="dotted"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="menu2"> <div id="menu_hide"> <!-- --> </div> <div id="menu_text_off"> </div> <div id="menu_space1"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div class="padTop38"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- menu finish --> <!-- top start --> <div id="container"> <div id="line"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div id="containerBg1"> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="titleText">REGISTER EMPLOYEE</div> <div class="clr"> <!-- --> </div> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- top finish --> <!-- data title start --> <div id="containerBg2"> <div class="padTop2"> <!-- --> </div> <div class="clr"> <!-- --> </div> <form name="form1" method="post" action="signup_ac.php"> <table align="center"> <tr valign="baseline"> <td nowrap align="right">Name:</td> <td><input type="text" name="name" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address:</td> <td><input type="text" name="address" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address1:</td> <td><input type="text" name="address1" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address2:</td> <td><input type="text" name="address2" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address3:</td> <td><input type="text" name="address3" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address4:</td> <td><input type="text" name="address4" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">County:</td> <td><input type="text" name="county" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Zip:</td> <td><input type="text" name="zip" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Telephone:</td> <td><input type="text" name="telephone" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Email:</td> <td><input type="text" name="email" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Username:</td> <td><input type="text" name="username" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Password:</td> <td><input type="password" name="password" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><input type="submit" value="Insert record"></td> </tr> </table> </form> <p> </p> </div> <!-- btm start --> <div id="containerBg1"> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div id="container"> <div id="line"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div class="padTop16"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- btm finish --> </div> </body> </html> My CSS looks like this /* CSS Document */ #Box{ width:931px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; } #logoBox{ width:81px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; background-image:url(../Admin_files/bg_logo.gif); float:left; } #contentBox{ width:850px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:right; } .clr { clear:both; } .clrIE { clear:both; display:inline; } .textError{ color:#b91518; } body { font-family: Arial, Helvetica, sans-serif; background-image:url(../Admin_files/bg_logo.gif); background-repeat:repeat-y; background-color: #ffffff; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; font-size: 11px; color: #595959; line-height:150%; } #container { width:850px; margin-left: auto; margin-right: auto; } #containerBg1 { width:850px; margin-left: auto; margin-right: auto; background-image:url(../Admin_files/bg01.gif); } #containerBg2 { width:850px; height:20px; margin-left: auto; margin-right: auto; background-image:url(../Admin_files/bg02.gif); } #containerBg3 { width:850px; margin-left: auto; margin-right: auto; background-image:url(../Admin_files/bg03.gif); } #containerBg4 { width:850px; margin-left: auto; margin-right: auto; background-image:url(../Admin_files/bg04.gif); } #dotted{ width:auto; height:1px; background-image:url(../Admin_files/bg05.gif); } #line{ width:auto; height:1px; background-color:#c6c5c5; } #logo { width:850px; height:50px; background-image:url(../Admin_files/logo.gif); background-repeat:no-repeat; } #frameIn1{ width:850px; height:20px; background-image:url(../Admin_files/bg01.gif); } #dataTitle{ width:850px; height:20px; background-image:url(../Admin_files/bg02.gif); } #titleBox{ width:850px; height:20px; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; } #dottedIn{ width:850px; height:1px; background-image:url(../Admin_files/bg05.gif); padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; } #menu_off{ width:6px; height:6px; padding:0px 0px 0px 0px; margin:5px 0px 0px 0px; float:left; background-image:url(../Admin_files/menu_off.gif); background-repeat:no-repeat; } #menu_on{ width:6px; height:6px; padding:0px 0px 0px 0px; margin:5px 0px 0px 0px; float:left; background-image:url(../Admin_files/menu_on.gif); background-repeat:no-repeat; } #menu_hide{ width:6px; height:6px; padding:0px 0px 0px 0px; margin:5px 0px 0px 0px; float:left; } #menu_text_off{ width:auto; height:auto; padding:0px 0px 0px 6px; margin:0px 0px 0px 0px; float:left; } #menu_text_on{ width:auto; height:auto; padding:0px 0px 0px 6px; margin:0px 0px 0px 0px; font-weight:bold; color:#000000; float:left; } #menu_text_on_hide{ width:auto; height:auto; padding:0px 0px 0px 6px; margin:0px 0px 0px 0px; font-weight:bold; color:#ffffff; float:left; } #menu_space1{ width:48px; height:6px; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:left; } #menu_space2{ width:24px; height:6px; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:left; } .textWhite{ color:#FFFFFF; } .textBlack{ color:#000000; } .textBlackB{ color:#000000; font-weight:bold; } #btn{ width:818px; height:auto; padding:0px 32px 0px px; margin:0px 0px 0px 0px; text-align:right; } #btn2{ width:818px; height:auto; padding:0px 0px 0px 32px; margin:0px 0px 0px 0px; text-align:left; } #btn3{ width:818px; height:auto; padding:0px 0px 0px 32px; margin:0px 0px 0px 0px; text-align:center; } #btnL{ width:auto; height:23px; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:right; } #btnR{ width:auto; height:23px; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:right; } #btnSpace{ width:16px; height:23px; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:right; } #btn_text{ width:auto; height:auto; padding:0px 32px 0px 32px; margin:0px 0px 0px 0px; text-align:center; } #text_confirm{ width:auto; height:30px; padding:0px 32px 0px 32px; margin:0px 0px 0px 0px; text-align:right; } #titleText{ width:auto; height:auto; padding:0px 32px 0px 18px; margin:0px 0px 0px 0px; color:#000000; font-weight:bold; text-align:left; } #sales_text_and{ width:auto; height:auto; padding:0px 32px 0px 90px; margin:0px 0px 0px 0px; text-align:left; } .tableData{ width:850px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:center; } .editLeft{ width:324px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:left; } .editRight{ width:526px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:right; } .editLeftBox{ width:291px; height:auto; padding:0px 0px 0px 33px; margin:0px 0px 0px 0px; float:left; } .editLeftText{ width:33px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editLeftForm{ width:258px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRightBox{ width:526px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:left; } .editRightText{ width:74px; height:auto; padding:3px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRightForm{ width:452px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRadio1{ width:24px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRadio2{ width:50px; height:auto; padding:2px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRadio3{ width:24px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRadio4{ width:50px; height:auto; padding:2px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRadio5{ width:100px; height:auto; padding:2px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRadioLink1{ width:24px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRadioLink2{ width:50px; height:auto; padding:2px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRadioLink3{ width:24px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRadioLink4{ width:120px; height:auto; padding:2px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editRadioLink5{ width:100px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editItemPrice1{ width:14px; height:auto; padding:3px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editItemPrice2{ width:100px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editSize1{ width:266px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editSize2{ width:24px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editSize3{ width:40px; height:auto; padding:2px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editSize4{ width:24px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editSize5{ width:40px; height:auto; padding:2px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editSize6{ width:99px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:center; float:left; } .editSize7{ width:33px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:center; float:left; } .editSizeTitle1{ width:266px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editSizeTitle2{ width:128px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:left; float:left; } .editSizeTitle3{ width:99px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; text-align:center; float:left; } .editSizeTitle4{ width:33px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:left; } .editSizeLineL{ width:493px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:left; } .editSizeLineR{ width:33px; height:auto; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; float:left; } .padTop400 { padding-top:400px; } .padTop300 { padding-top:300px; } .padTop240 { padding-top:240px; } .padTop220 { padding-top:220px; } .padTop200 { padding-top:200px; } .padTop100 { padding-top:100px; } .padTop90 { padding-top:90px; } .padTop80 { padding-top:80px; } .padTop77 { padding-top:77px; } .padTop75 { padding-top:75px; } .padTop70 { padding-top:70px; } .padTop60 { padding-top:60px; } .padTop50 { padding-top:50px; } .padTop47 { padding-top:47px; } .padTop46 { padding-top:46px; } .padTop41 { padding-top:41px; } .padTop40 { padding-top:40px; } .padTop38 { padding-top:38px; } .padTop37 { padding-top:37px; } .padTop36 { padding-top:36px; } .padTop35 { padding-top:35px; } .padTop33 { padding-top:33px; } .padTop32 { padding-top:32px; } .padTop31 { padding-top:31px; } .padTop30 { padding-top:30px; } .padTop29 { padding-top:29px; } .padTop28 { padding-top:28px; } .padTop27 { padding-top:27px; } .padTop24 { padding-top:24px; } .padTop23 { padding-top:23px; } .padTop22 { padding-top:22px; } .padTop20 { padding-top:20px; } .padTop19 { padding-top:19px; } .padTop18 { padding-top:18px; } .padTop17 { padding-top:17px; } .padTop16 { padding-top:16px; } .padTop15 { padding-top:15px; } .padTop14 { padding-top:14px; } .padTop13 { padding-top:13px; } .padTop12 { padding-top:12px; } .padTop11 { padding-top:11px; } .padTop10 { padding-top:10px; } .padTop9 { padding-top:9px; } .padTop8 { padding-top:8px; } .padTop7 { padding-top:7px; } .padTop6 { padding-top:6px; } .padTop5 { padding-top:5px; } .padTop4 { padding-top:4px; } .padTop3 { padding-top:3px; } .padTop2 { padding-top:2px; } .padTop1 { padding-top:1px; } a:visited { text-decoration: none; color: #879cc3; } a:link { text-decoration: none; color: #879cc3; } a:hover { text-decoration: underline; color: #879cc3; } a:active { text-decoration: none; color: #879cc3; } a.black:link {color: #575757; text-decoration: none;} a.black:visited {text-decoration: none; color: #575757;} a.black:hover {text-decoration: underline; color: #879cc3;} a.black:active {text-decoration: none; color: #879cc3;} a.black_on:link {color: #000000; text-decoration: none;} a.black_on:visited {text-decoration: none; color: #000000;} a.black_on:hover {text-decoration: underline; color: #879cc3;} a.black_on:active {text-decoration: none; color: #000000;} input.order1Form1{ width:166px; height:auto; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } input.coupon2Form1{ width:200px; height:auto; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } input.coupon2Form2{ width:40px; height:auto; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } input.shippingForm1{ width:40px; height:auto; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } input.newsUpFile{ width:245px; height:auto; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } input.newsEditForm01{ width:418px; height:auto; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } input.newsEditForm02{ width:73px; height:auto; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } textarea.newsEditForm03{ width:418px; height:240px; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } input.itemEditForm01{ width:418px; height:auto; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } input.itemEditForm02{ width:200px; height:auto; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } textarea.itemEditForm03{ width:418px; height:240px; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } input.itemEditForm04{ width:73px; height:auto; font-size:11px; background-color: #ffffff; border: solid 1px; border-color: #c3c3c3; } hr { border-top:none; border-bottom: 1px dashed #A5AEC5; }
-
Just wondering if this is correct <img src="<?php echo $row['Image'];?>"
-
Is the structure of my above code correct?? Any help getting this to work would be great!
-
Registration details not passing to database
mikebyrne replied to mikebyrne's topic in PHP Coding Help
Thats great got that working now! THANKS FOR ALL YOUR HELP -
Registration details not passing to database
mikebyrne replied to mikebyrne's topic in PHP Coding Help
Two quick questions 1) How can I redirect the page back to adminreg.php 2) I want to create a new field called Userid and when the "insert record" button is pressed I want the number "2" to be place in the Userid field along with the records -
Registration details not passing to database
mikebyrne replied to mikebyrne's topic in PHP Coding Help
Now im getting the I hope you see this... INSERT INTO adminusers(name, address, address1, address2, address3, address4, county, zip, telephone, email, username, password)VALUES('Michael', '', '', '','', '','' ,'', '', '', '', '') And it seems to be working!! Thanks What do i need to get rid of to just see my page? -
Registration details not passing to database
mikebyrne replied to mikebyrne's topic in PHP Coding Help
Just taken that out but still no difference -
Registration details not passing to database
mikebyrne replied to mikebyrne's topic in PHP Coding Help
No Still no output The whole page for adminreg.php looks like this: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>e-commerce admin page sample |item</title> <link href="../Admin_files/admin.css" rel="stylesheet" type="text/css" /> <script type="text/JavaScript" src="../Admin_files/wrapper.js"></script> </head> <body> <div id="Box"> <div id="logoBox"><a href="http://www.btrax.com/" target="_blank"><img src="../Admin_files/logo.gif" width="51" height="125" border="0" /></a></div> <div id="contentBox"> <form> <!-- logo start --> <div id="container"> <div class="padTop28"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- logo finish --> <!-- menu start --> <div id="container"> <div id="menu1"> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../admin_files/new.php" class="black">Order</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../admin_files/sales.php" class="black">Sales</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_on"><a href="../admin_files/list.php" class="black">Edit item</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../shipping/current.php" class="black">Postage fee</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_on"><!-- --></div> <div id="menu_text_off"><a href="../shipping/current.php" class="black_on">Add User</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../shipping/current.php" class="black">Add Product</a></div> <div id="menu_space1"><!-- --></div> </div> <div class="clr"><!-- --></div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="dotted"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="menu2"> <div id="menu_hide"> <!-- --> </div> <div id="menu_text_off"> </div> <div id="menu_space1"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div class="padTop38"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- menu finish --> <!-- top start --> <div id="container"> <div id="line"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div id="containerBg1"> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="titleText">REGISTER EMPLOYEE</div> <div class="clr"> <!-- --> </div> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- top finish --> <!-- data title start --> <div id="containerBg2"> <div class="padTop2"> <!-- --> </div> <div class="clr"> <!-- --> </div> <td><form name="form1" method="post" action="signup_ac.php"> <table align="center"> <tr valign="baseline"> <td nowrap align="right">Name:</td> <td><input type="text" name="name" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address:</td> <td><input type="text" name="address" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address1:</td> <td><input type="text" name="address1" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address2:</td> <td><input type="text" name="address2" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address3:</td> <td><input type="text" name="address3" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address4:</td> <td><input type="text" name="address4" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">County:</td> <td><input type="text" name="county" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Zip:</td> <td><input type="text" name="zip" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Telephone:</td> <td><input type="text" name="telephone" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Email:</td> <td><input type="text" name="email" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Username:</td> <td><input type="text" name="username" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Password:</td> <td><input type="password" name="password" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><input type="submit" value="Insert record"></td> </tr> </table> </form> <p> </p> </div> <!-- btm start --> <div id="containerBg1"> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div id="container"> <div id="line"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div class="padTop16"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- btm finish --> </div> </body> </html> signup_ac <?php include('adminconnect.php'); // table name $tbl_name="adminusers"; // values sent from form $name=$_POST['name']; $address=$_POST['address']; $address1=$_POST['address1']; $address2=$_POST['address2']; $address3=$_POST['address3']; $address4=$_POST['address4']; $county=$_POST['county']; $zip=$_POST['zip']; $telephone=$_POST['telephone']; $email=$_POST['email']; $username=$_POST['username']; $password=$_POST['password']; echo "I hope you see this..."; $sql="INSERT INTO $tbl_name(name, address, address1, address2, address3, address4, county, zip, telephone, email, username, password)VALUES('$name', '$address', '$address1', '$address2','$address3', '$address4','$county' ,'$zip', '$telephone', '$email', '$username', '$password')"; $result=mysql_query($sql)or die(mysql_error()."<p>With Query<br>$sql"); echo "<p>$sql<p>"; ?> -
Registration details not passing to database
mikebyrne replied to mikebyrne's topic in PHP Coding Help
No, I have it as you do above but still not getting any output on screen and not filling the DB -
Registration details not passing to database
mikebyrne replied to mikebyrne's topic in PHP Coding Help
i changed signup.php to <?php $sql="INSERT INTO $tbl_name(name, address, address1, address2, address3, address4, county, zip, telephone, email, username, password)VALUES('$name', '$address', '$address1', '$address2','$address3', '$address4','$county' ,'$zip', '$telephone', '$email', '$username', '$password')"; $result=mysql_query($sql)or die(mysql_error()."<p>With Query<br>$sql"); echo "<p>$sql<p>"; ?> Nothing seems to happen and no output on screen -
Registration details not passing to database
mikebyrne replied to mikebyrne's topic in PHP Coding Help
No i dont get any errors I've changed it to <?php include('adminconnect.php'); // table name $tbl_name="adminusers"; // values sent from form $name=$_POST['name']; $address=$_POST['address']; $address1=$_POST['address1']; $address2=$_POST['address2']; $address3=$_POST['address3']; $address4=$_POST['address4']; $county=$_POST['county']; $zip=$_POST['zip']; $telephone=$_POST['telephone']; $email=$_POST['email']; $username=$_POST['username']; $password=$_POST['password']; // Insert data into database $sql="INSERT INTO $tbl_name(name, address, address1, address2, address3, address4, county, zip, telephone, email, username, password)VALUES('$name', '$address', '$address1', '$address2','$address3', '$address4','$county' ,'$zip', '$telephone', '$email', '$username', '$password')"; $result=mysql_query($sql)or die(mysql_error()); ?> But still no luck! -
My registration details aren't passing from my form to the database and I'm not sure why My pages are adminreg.php <td><form name="form1" method="post" action="signup_ac.php"> <table align="center"> <tr valign="baseline"> <td nowrap align="right">Name:</td> <td><input type="text" name="name" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address:</td> <td><input type="text" name="address" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address1:</td> <td><input type="text" name="address1" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address2:</td> <td><input type="text" name="address2" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address3:</td> <td><input type="text" name="address3" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Address4:</td> <td><input type="text" name="address4" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">County:</td> <td><input type="text" name="county" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Zip:</td> <td><input type="text" name="zip" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Telephone:</td> <td><input type="text" name="telephone" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Email:</td> <td><input type="text" name="email" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Username:</td> <td><input type="text" name="username" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Password:</td> <td><input type="password" name="password" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><input type="submit" value="Insert record"></td> </tr> </table> </form> signup_ac.php <?php include('adminconnect.php'); // table name $tbl_name=Adminusers; // values sent from form $name=$_POST['name']; $address=$_POST['address']; $address1=$_POST['address1']; $address2=$_POST['address2']; $address3=$_POST['address3']; $address4=$_POST['address4']; $county=$_POST['county']; $zip=$_POST['zip']; $telephone=$_POST['telephone']; $email=$_POST['email']; $username=$_POST['username']; $password=$_POST['password']; // Insert data into database $sql="INSERT INTO $tbl_name(name, address, address1, address2, address3, address4, county, zip, telephone, email, username, password)VALUES('$name', '$address', '$address1', '$address2','$address3', '$address4','$county' ,'$zip', '$telephone', '$email', '$username', '$password')"; $result=mysql_query($sql)or die(mysql_error()); ?> The sql for my db is: CREATE TABLE `adminusers` ( `name` varchar(255) collate latin1_general_ci default NULL, `address` varchar(255) collate latin1_general_ci default NULL, `address1` varchar(255) collate latin1_general_ci default NULL, `address2` varchar(255) collate latin1_general_ci default NULL, `address3` varchar(255) collate latin1_general_ci default NULL, `address4` varchar(255) collate latin1_general_ci default NULL, `county` varchar(255) collate latin1_general_ci default NULL, `zip` varchar(255) collate latin1_general_ci default NULL, `telephone` decimal(10,0) default NULL, `email` varchar(255) collate latin1_general_ci default NULL, `username` varchar(255) collate latin1_general_ci default NULL, `password` varchar(255) collate latin1_general_ci default NULL, `usertype` decimal(10,0) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-
I've tried <div class="editLeftBox"><img src="<?php echo $row['Image'];?>" alt="pic1" width="245" height="245" /></div> But im just getting jibberish on screen (Ive included attachment!)
-
At present my pictures are loaded from a set location but I wont them to be dynamically loaded depending on the users selection on a previous form. My code is: <?php // let's get some data $name = $_POST["something"]; include('adminconnect.php'); $query = "SELECT ProductNo,ProductName,Stockamount,Display,Description,Price,Image FROM Product WHERE ProductNo='$name' "; $result = mysql_query($query) or die (mysql_error()); while ($row = mysql_fetch_array($result)){ // loop through and display ?> <div id="containerBg4"> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="padTop1"> <!-- data Left start --> <div class="editLeft"> <!-- picture1 start --> <div class="editLeftBox">picture1:</div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="editLeftBox"><img src="../../images/pic1.gif" alt="pic1" width="245" height="245" /></div> <div class="clr"> <!-- --> </div> <div class="padTop5"> I'd need the below line to refer to the Image field in my database <div class="editLeftBox"><img src="../../images/pic1.gif" alt="pic1" width="245" height="245" /></div>
-
0Yeah will do, In the process of doing that now. Just trying to figure out now how to store pictures into Navicat (MySQL GUI Frontend)
-
Thats what I thought I was doing! Just cant get the description to come up
-
For some reason I cant get the description to pass, I presume its something to do with /textarea? The code I have is: <textarea type="text" class="itemEditForm03" name="something" value="<?php echo $row['Description'];?>"/> </textarea>
-
ProductNo and Price works!!! But for some reason the ProductName and Description doesn't????
-
So would I need to place the whole layout of the form within the loop? The following just give me an error Parse error: syntax error, unexpected '<' in C:\xampp\htdocs\Admin_files\edit.php on line 212 <?php // let's get some data $name = $_POST["something"]; include('adminconnect.php'); $query = "SELECT ProductNo,ProductName,Stockamount,Display,Description,Price FROM Product WHERE ProductNo='$name' "; $result = mysql_query($query) or die (mysql_error()); while ($row = mysql_fetch_array($result)){ // loop through and display ?> <?php } <div id="containerBg4"> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="padTop1"> <!-- data Left start --> <div class="editLeft"> <!-- picture1 start --> <div class="editLeftBox">picture1:</div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="editLeftBox"><img src="../../images/pic1.gif" alt="pic1" width="245" height="245" /></div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="editLeftBox"> <input type="file" name="uploadfile" class="newsUpFile"> </div> <div class="clr"> <!-- --> </div> <!-- picture1 finish --> <div class="padTop50"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- picture2 start --> <div class="editLeftBox">picture2:</div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="editLeftBox"><img src="../../images/pic2.gif" alt="pic2" width="245" height="245" /></div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="editLeftBox"> <input type="file" name="uploadfile" class="newsUpFile"> </div> <div class="clr"> <!-- --> </div> <!-- picture2 finish --> </div> <!-- data Left finish --> <!-- data Right start --> <div class="editRight"> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Product No:</div> <div class="editRightForm"> <input type="text" class="itemEditForm02" name="something" value="<?php echo $row['ProductNo'];?>" /> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Product Name:</div> <div class="editRightForm"> <input name="0" type="text" class="itemEditForm02" v<?php echo $row['ProductName'];?> /> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Description:</div> <div class="editRightForm"> <textarea type="text" class="itemEditForm03" name="0" value="<?php echo $row['Description'];?>" /> </textarea> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Remarks:</div> <div class="editRightForm"> <input type="text" class="itemEditForm02" name="0" value="" /> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Price:</div> <div class="editRightForm"> <div class="editItemPrice1">$</div> <div class="editItemPrice2"> <input type="text" class="itemEditForm04" name="0" value="<?php echo $row['Price'];?>" /> </div> <div class="clr"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Sale:</div> <div class="editRightForm"> <div class="editRadioLink1"> <input name="link" type="radio" value="yes" /> </div> <div class="editRadioLink2">Yes</div> <div class="editRadioLink3"> <input name="link" type="radio" value="no" checked="checked" /> </div> <div class="editRadioLink4">No - sale price: $ </div> <div class="editRadioLink5"> <input type="text" class="newsEditForm02" name="0" value="380" /> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Display:</div> <div class="editRightForm"> <div class="editRadio1"> <input name="display" type="radio" value="yes" checked="checked" /> </div> <div class="editRadio2">show</div> <div class="editRadio3"> <input name="display" type="radio" value="no" /> </div> <div class="editRadio4">hide</div> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop75"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <!-- data Right finish --> </div> <div class="clr"> <!-- --> </div> <div class="padTop11"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="dottedIn"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <!-- btn start --> <div class="clr"> <!-- --> </div> <div class="padTop16"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="btn"> <div id="btnL"><img src="../images/btn_update.gif" width="73" height="23" /></div> <div id="btnSpace"> <!-- --> </div> <div id="btnR"><img src="../images/btn_clear.gif" width="73" height="23" /></div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div class="padTop16"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- btn finish --> </div> <div class="clr"> <!-- --> </div> <!-- data content finish --> <!-- data btm start --> <div id="containerBg3"> <div class="padTop1"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data btm finish --> ?> </form>
-
if changed it to <input type="text" class="itemEditForm02" name="something" value="<?php echo $row['ProductNo'];?>" /> but still not displaying any output
-
What I'm trying to do is get the user to select the item in list.php. The productNo is then stored and used in edit.php to bring up the corresponding product details ie Price, Decription etc
-
So what would you recommend to get it to work?
-
The variables im trying to show are in edit.php <input type="text" class="itemEditForm02" name="0" value="<?php echo $row['ProductNo'];?>" /> Is this the correct way to phrase the code???
-
I'm trying to get my select variables to pass from my list.php to my edit.php but I just have empty fields at present The code for list.php is <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>e-commerce admin page sample | item</title> <link href="../Admin_files/admin.css" rel="stylesheet" type="text/css" /> <script type="text/JavaScript" src="../Admin_files/wrapper.js"></script> </head> <body> <div id="Box"> <div id="logoBox"><a href="http://www.btrax.com/" target="_blank"><img src="../Admin_files/logo.gif" width="51" height="125" border="0" /></a></div> <div id="contentBox"> <!-- logo start --> <div id="container"> <div class="padTop28"><!-- --></div> <div class="clr"><!-- --></div> </div> <div class="clr"><!-- --></div> <!-- logo finish --> <!-- menu start --> <div id="container"> <div id="menu1"> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../admin_files/new.php" class="black">order</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../admin_files/sales.php" class="black">sales</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_on"><!-- --></div> <div id="menu_text_on"><a href="../admin_files/list.php" class="black_on">Edit item</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../shipping/current.php" class="black">Postage fee</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../shipping/current.php" class="black">Add User</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../shipping/current.php" class="black">Add Product</a></div> <div id="menu_space1"><!-- --></div> </div> <div class="clr"><!-- --></div> <div class="clr"><!-- --></div> <div class="padTop5"><!-- --></div> <div class="clr"><!-- --></div> <div id="dotted"><!-- --></div> <div class="clr"><!-- --></div> <div class="padTop5"><!-- --></div> <div class="clr"><!-- --></div> <div id="menu2"> <div id="menu_hide"><!-- --></div> <div id="menu_text_off"> </div> <div id="menu_space1"><!-- --></div> <div class="clr"><!-- --></div> <!-- --> </div> <div id="menu_space1"><!-- --></div> <div id="menu_on"><!-- --></div> <div id="menu_text_on"><a href="../admin_files/list.php" class="black_on">Games</a></div> <div id="menu_space2"> <!-- --> </div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../admin_files/dvdlist.php" class="black">DVD</a></div> <div id="menu_space2"> <!-- --> </div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../admin_files/cdlist.php" class="black">CD</a></div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> <!-- Double Space undernath CD --> <div class="clr"><!-- --></div> <div class="clr"><!-- --></div> <div class="padTop5"><!-- --></div> <div class="clr"><!-- --></div> <div class="clr"><!-- --></div> <div class="clr"><!-- --></div> <div class="padTop5"><!-- --></div> <div class="clr"><!-- --></div> <!-- menu finish --> <!-- top start --> <div id="container"> <div id="line"><!-- --></div> </div> <div class="clr"><!-- --></div> <div id="containerBg1"> <div class="padTop15"><!-- --></div> <div class="clr"><!-- --></div> </div> <div class="clr"><!-- --></div> <!-- top finish --> <!-- 1px space start --> <div id="containerBg1"> <div class="padTop1"><!-- --></div> <div class="clr"><!-- --></div> </div> <div class="clr"><!-- --></div> <!-- 1px space finish --> <!-- data top start --> <div id="containerBg3"> <div class="padTop1"><!-- --></div> <div class="clr"><!-- --></div> </div> <div class="clr"><!-- --></div> <!-- data top finish --> <!-- data content start --> <div id="containerBg4"> <!-- data start --> <form method="post" action="edit.php"> <table width="800" align="center" border="0" cellspacing="0" cellpadding="0"> <tr align="left"> <td><a href="#">SELECT</a></td> <td><a href="#">PRODCT NO</a></td> <td><a href="#">PRODUCT NAME</a></td> <td><a href="#">STOCK LEVEL</a></td> <td><a href="#">DISPLAY</a></td> <td><a href="#">PRICE</a></td> </tr> <?php // let's get some data include('adminconnect.php'); $query = "SELECT ProductNo,ProductName,Stockamount,Display,Price FROM Product WHERE Producttype = 'Game' "; $result = mysql_query($query) or die (mysql_error()); while ($row = mysql_fetch_array($result)){ // loop through and display ?> <tr align="left"> <td><input type="radio" value="<?php echo $row['ProductNo']; ?>" name="something" /></td> <td><a class="black"><?php echo $row['ProductNo'];?></a></td> <td><?php echo $row['ProductName'];?></td> <td><?php echo $row['Stockamount'];?></td> <td><?php echo $row['Display'] ;?></td> <td><?php echo $row['Price'];?></td> </tr> <tr><td colspan="6"><hr /></td><td></tr> <?php } ?> <tr><td><input type="submit" name="submit" value="Edit" /></td></tr> </table> </div> <div class="clr"><!-- --></div> <!-- data content finish --> <!-- data btm start --> <div id="containerBg3"> <div class="padTop1"><!-- --></div> <div class="clr"><!-- --></div> </div> <div class="clr"><!-- --></div> <!-- data btm finish --> <!-- btm start --> <div id="containerBg1"> <div class="padTop15"><!-- --></div> <div class="clr"><!-- --></div> </div> <div class="clr"><!-- --></div> <div id="container"> <div id="line"><!-- --></div> </div> <div class="clr"><!-- --></div> <div class="padTop16"><!-- --></div> <div class="clr"><!-- --></div> <!-- btm finish --> </div> </div> </body> </html> The code for edit.php is <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>e-commerce admin page sample |item</title> <link href="../Admin_files/admin.css" rel="stylesheet" type="text/css" /> <script type="text/JavaScript" src="../Admin_files/wrapper.js"></script> </head> <body> <div id="Box"> <div id="logoBox"><a href="http://www.btrax.com/" target="_blank"><img src="../Admin_files/logo.gif" width="51" height="125" border="0" /></a></div> <div id="contentBox"> <form> <!-- logo start --> <div id="container"> <div class="padTop28"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- logo finish --> <!-- menu start --> <div id="container"> <div id="menu1"> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../order/new.php" class="black">order</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../sales/sales.php" class="black">sales</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_on"><!-- --></div> <div id="menu_text_on"><a href="../item/list.php" class="black_on">item</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../shipping/current.php" class="black">shipping fee</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../coupon/current.php" class="black">coupon</a></div> <div id="menu_space1"><!-- --></div> <div id="menu_off"><!-- --></div> <div id="menu_text_off"><a href="../news/list.php" class="black">news</a></div> <div class="clr"><!-- --></div> </div> <div class="clr"><!-- --></div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="dotted"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="menu2"> <div id="menu_hide"> <!-- --> </div> <div id="menu_text_off"> </div> <div id="menu_space1"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div class="padTop38"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- menu finish --> <!-- top start --> <div id="container"> <div id="line"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div id="containerBg1"> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="titleText">item / edit</div> <div class="clr"> <!-- --> </div> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- top finish --> <!-- data title start --> <div id="containerBg2"> <div class="padTop2"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="titleBox"> <table width="850" border="0" cellspacing="0" cellpadding="0"> <tr align="left"> <td width="33"> </td> <td width="290" align="left">image</td> <td width="527">detail</td> </tr> </table> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data title finish --> <!-- 1px space start --> <div id="containerBg1"> <div class="padTop1"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- 1px space finish --> <!-- data top start --> <div id="containerBg3"> <div class="padTop1"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data top finish --> <!-- data content start --> <?php // let's get some data $name = $_POST["something"]; include('adminconnect.php'); $query = "SELECT ProductNo,ProductName,Stockamount,Display,Description,Price FROM Product WHERE ProductNo='$name' "; $result = mysql_query($query) or die (mysql_error()); while ($row = mysql_fetch_array($result)){ // loop through and display ?> <?php } ?> <div id="containerBg4"> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="padTop1"> <!-- data Left start --> <div class="editLeft"> <!-- picture1 start --> <div class="editLeftBox">picture1:</div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="editLeftBox"><img src="../../images/pic1.gif" alt="pic1" width="245" height="245" /></div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="editLeftBox"> <input type="file" name="uploadfile" class="newsUpFile"> </div> <div class="clr"> <!-- --> </div> <!-- picture1 finish --> <div class="padTop50"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- picture2 start --> <div class="editLeftBox">picture2:</div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="editLeftBox"><img src="../../images/pic2.gif" alt="pic2" width="245" height="245" /></div> <div class="clr"> <!-- --> </div> <div class="padTop5"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div class="editLeftBox"> <input type="file" name="uploadfile" class="newsUpFile"> </div> <div class="clr"> <!-- --> </div> <!-- picture2 finish --> </div> <!-- data Left finish --> <!-- data Right start --> <div class="editRight"> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Product No:</div> <div class="editRightForm"> <input type="text" class="itemEditForm02" name="0" value="<?php echo $row['ProductNo'];?>" /> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Product Name:</div> <div class="editRightForm"> <input name="0" type="text" class="itemEditForm02" v<?php echo $row['ProductName'];?> /> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Description:</div> <div class="editRightForm"> <textarea type="text" class="itemEditForm03" name="0" value="<?php echo $row['Description'];?>" /> </textarea> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Remarks:</div> <div class="editRightForm"> <input type="text" class="itemEditForm02" name="0" value="" /> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Price:</div> <div class="editRightForm"> <div class="editItemPrice1">$</div> <div class="editItemPrice2"> <input type="text" class="itemEditForm04" name="0" value="<?php echo $row['Price'];?>" /> </div> <div class="clr"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Sale:</div> <div class="editRightForm"> <div class="editRadioLink1"> <input name="link" type="radio" value="yes" /> </div> <div class="editRadioLink2">Yes</div> <div class="editRadioLink3"> <input name="link" type="radio" value="no" checked="checked" /> </div> <div class="editRadioLink4">No - sale price: $ </div> <div class="editRadioLink5"> <input type="text" class="newsEditForm02" name="0" value="380" /> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop3"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- dat start --> <div class="editRightBox"> <div class="editRightText">Display:</div> <div class="editRightForm"> <div class="editRadio1"> <input name="display" type="radio" value="yes" checked="checked" /> </div> <div class="editRadio2">show</div> <div class="editRadio3"> <input name="display" type="radio" value="no" /> </div> <div class="editRadio4">hide</div> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <div class="padTop75"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <!-- data Right finish --> </div> <div class="clr"> <!-- --> </div> <div class="padTop11"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="dottedIn"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- data finish --> <!-- btn start --> <div class="clr"> <!-- --> </div> <div class="padTop16"> <!-- --> </div> <div class="clr"> <!-- --> </div> <div id="btn"> <div id="btnL"><img src="../images/btn_update.gif" width="73" height="23" /></div> <div id="btnSpace"> <!-- --> </div> <div id="btnR"><img src="../images/btn_clear.gif" width="73" height="23" /></div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div class="padTop16"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- btn finish --> </div> <div class="clr"> <!-- --> </div> <!-- data content finish --> <!-- data btm start --> <div id="containerBg3"> <div class="padTop1"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <!-- data btm finish --> </form> </div> <!-- btm start --> <div id="containerBg1"> <div class="padTop15"> <!-- --> </div> <div class="clr"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div id="container"> <div id="line"> <!-- --> </div> </div> <div class="clr"> <!-- --> </div> <div class="padTop16"> <!-- --> </div> <div class="clr"> <!-- --> </div> <!-- btm finish --> </div> </body> </html> The variables im get get to show are <input type="text" class="itemEditForm02" name="0" value="<?php echo $row['ProductNo'];?>" /> etc in edit.php
-
Selecting a product on one form and Edit product on the other?
mikebyrne replied to mikebyrne's topic in PHP Coding Help
Have a good one!!