The page is on www.designwizardembroidery.com/dakota
If you enter 3D0108 in the box on the right and then click submit, nothing will show up in the new page.
The code for that php page is the following:
<?php $number=$_POST['DakotaNumber']; $connection=mysqli_connect ("p50mysql73.secureserver.net", "name", "password") or die ("I cannot connect to the database."); $database = "DakotaCatalog"; mysqli_select_db ($connection, $database) or die ("The Database is currently down. We apologize."); $nameQuery = "SELECT Name FROM DakotaDesigns WHERE Number = '$number'"; $result = mysqli_query ($connection, $nameQuery) or die ("couldn't find the name or number"); mysqli_query($nameQuery); echo $result; mysqli_close(); ?>
The $number variable gets the post from the previous page from the button.
The connection I've gone over multiple times to make sure it is right.
What is supposed to come back is under $nameQuery - the name of the design that corresponds with that number.
1) if it can't find the name should the "couldn't find the name or number" come out on the screen?
And if it can find the name, should it then echo $result?
I just want to make sure that this is getting the info from the catalog.
Thanks so much for anyone's help!
This post has been edited by foxkj: 15 August 2008 - 10:03 AM