bobicles2

so '$_POST['Event']' would become {$_POST['Event']}? and the $date part should work fine? thanks

www.teamrendition.co.uk For some reason the images at the top are surrounded by a blue box...anyone have any idea why? here is my code for the logo frame at the top Thanks in advance <a href="main.html" target="main"><img src="Images/home.png" alt="Homepage Link" width="124" height="60" onmouseover="this.src='Images/homemouseover.png'" onmouseout="this.src='Images/home.png'" /></a><a href="whatson.php" target="main"><img src="Images/whats on.png" alt="Whats on today" width="124" height="60" onmouseover="this.src='Images/whatsonmouseover.png'" onmouseout="this.src='Images/whats on.png'" /></a><a href="addevent.html" target="main"><img src="Images/addevent.png" alt="Add Event" width="124" height="60" onmouseover="this.src='Images/addeventmouseover.png'" onmouseout="this.src='Images/addevent.png'" /></a><a href="search.html" target="main"><img src="Images/search.png" alt="Search" width="124" height="60" onmouseover="this.src='Images/searchmouseover.png'" onmouseout="this.src='Images/search.png'"/></a><a href="http://z7.invisionfree.com/fattractions/index.php" target="main"><img src="Images/forum.png" alt="Forum" width="124" height="60" onmouseover="this.src='Images/forummouseover.png'" onmouseout="this.src='Images/forum.png'" /></a><a href="register.html" target="main"><img src="Images/register.png" alt="Register" width="124" height="60" onmouseover="this.src='Images/registermouseover.png'" onmouseout="this.src='Images/register.png'" /></a><a href="contact.html" target="main"><img src="Images/contact.png" alt="Contact" width="124" height="60" onmouseover="this.src='Images/contactmouseover.png'" onmouseout="this.src='Images/contact.png'" /></a><a href="loginpage.php" target="main"><img src="Images/login.png" alt="login" width="124" height="60" onmouseover="this.src='Images/loginmouseover.png'" onmouseout="this.src='Images/login.png'"/></a>

I have a drop down menu shown below as you can see it has multiple fields which i want to add to the same entry into my database (as one complete date) this was my attempt $date = $_POST['Year'] . '-' . $_POST['Month'] . '-' . $_POST['Day']; $sql="INSERT INTO Events (Event, Genre, Date, Price, Venue, Tickets) VALUES ('$_POST['Event']','$_POST['Genre']','$date','$_POST['Price']','$_POST['Venue']','$_POST['Tickets']')"; Unfortunatly this doesnt work and gives me this error ; Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/teamrend/public_html/insert.php on line 23 The Full code is posted below thanks in advance for any help!im really struggling to find a way past this here is my html form <form name="form2" method="post" action="insert.php"> <td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#DBDBDB"> <tr> <td colspan="3"><p align="center"><strong>Add Event </strong></p> <p> </p></td> </tr> <tr> <td width="59">Event</td> <td width="4">:</td> <td width="239"><input type="text" name="Event" /></td> </tr> <tr> <td>Genre</td> <td>:</td> <td><select name="genre" id="genre"> <option selected="selected" value="none">Genre</option> <option value="Rock">Rock</option> <option value="Pop">Pop</option> <option value="Indie">Indie</option> <option value="Electro">Electro</option> </select> </td> </tr> <tr> <td>Date</td> <td>:</td> <td> <select name="Year"> <option selected="selected">Year</option> <option value="2010">2010</option> <option value="2011">2011</option> <option value="2012">2012</option> <option value="2013">2013</option> <option value="2014">2014</option> <option value="2015">2015</option> <option value="2016">2016</option> <option value="2017">2017</option> <option value="2018">2018</option> <option value="2019">2019</option> <option value="2020">2020</option> <option value="2021">2021</option> <option value="2022">2022</option> <option value="2023">2023</option> <option value="2024">2024</option> <option value="2025">2025</option> <option value="2026">2026</option> <option value="2027">2027</option> <option value="2028">2028</option> <option value="2029">2029</option> <option value="2030">2030</option> </select> <select name="Month"> <option selected="selected">Month</option> <option value="01">01</option> <option value="02">02</option> <option value="03">03</option> <option value="04">04</option> <option value="05">05</option> <option value="06">06</option> <option value="07">07</option> <option value="08">08</option> <option value="09">09</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> </select> <select name="Day"> <option selected="selected">Day</option> <option value="01">01</option> <option value="02">02</option> <option value="03">03</option> <option value="04">04</option> <option value="05">05</option> <option value="06">06</option> <option value="07">07</option> <option value="08">08</option> <option value="09">09</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> <option value="21">21</option> <option value="22">22</option> <option value="23">23</option> <option value="24">24</option> <option value="25">25</option> <option value="26">26</option> <option value="27">27</option> <option value="28">28</option> <option value="29">29</option> <option value="30">30</option> <option value="31">31</option> </select> </td> </tr> <tr> <td>Price</td> <td>:</td> <td><input type="text" name="Price" /></td> </tr> <tr> <td>Tickets</td> <td>:</td> <td><input type="text" name="Tickets" /></td> </tr> <tr> <td> </td> <td> </td> <td><input type="submit" name="Submit" value="Submit" /></td> </tr> </table></td> </form> and this is insert.php <?php $date = $_POST['Year'] . '-' . $_POST['Month'] . '-' . $_POST['Day']; $con = mysql_connect("localhost","teamrend_rwowen","291Aug89"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("teamrend_rwowen", $con); $date = $_POST['Year'] . '-' . $_POST['Month'] . '-' . $_POST['Day']; $sql="INSERT INTO Events (Event, Genre, Date, Price, Venue, Tickets) VALUES ('$_POST['Event']','$_POST['Genre']','$date','$_POST['Price']','$_POST['Venue']','$_POST['Tickets']')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "Thank You, Your Event has now been added to our Records"; mysql_close($con) ?>

I have a HTML form for inserting an event into my database, everything works fine apart from inserting the date, i have broken the date down into 3 small drop down menus so that i could make sure it was inserting in the format so the function CURRENT_DATE would work. however, it doesnt seem to want to add my date! when i fill out the form it sends nothing to the database can anyone shed some light for me? or help the html form is <form name="form2" method="post" action="insert.php"> <td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#DBDBDB"> <tr> <td colspan="3"><p align="center"><strong>Add Event </strong></p> <p> </p></td> </tr> <tr> <td width="59">Event</td> <td width="4">:</td> <td width="239"><input type="text" name="Event" /></td> </tr> <tr> <td>Genre</td> <td>:</td> <td><select name="Genre" size="1"> <option selected="selected" value="none">Genre</option> <option>Rock</option> <option>Pop</option> <option>Indie</option> <option>Electro</option> </select> </td> </tr> <tr> <td>Date</td> <td>:</td> <td> <select name="Date"> <option selected="selected">Year</option> <option>2010</option> <option>2011</option> <option>2012</option> <option>2013</option> <option>2014</option> <option>2015</option> <option>2016</option> <option>2017</option> <option>2018</option> <option>2019</option> <option>2020</option> <option>2021</option> <option>2022</option> <option>2023</option> <option>2024</option> <option>2025</option> <option>2026</option> <option>2027</option> <option>2028</option> <option>2029</option> <option>2030</option> </select> <select name="Date"> <option selected="selected">Month</option> <option>01</option> <option>02</option> <option>03</option> <option>04</option> <option>05</option> <option>06</option> <option>07</option> <option>08</option> <option>09</option> <option>10</option> <option>11</option> <option>12</option> </select> <select name="Date"> <option selected="selected">Day</option> <option>01</option> <option>02</option> <option>03</option> <option>04</option> <option>05</option> <option>06</option> <option>07</option> <option>08</option> <option>09</option> <option>10</option> <option>11</option> <option>12</option> <option>13</option> <option>14</option> <option>15</option> <option>16</option> <option>17</option> <option>18</option> <option>19</option> <option>20</option> <option>21</option> <option>22</option> <option>23</option> <option>24</option> <option>25</option> <option>26</option> <option>27</option> <option>28</option> <option>29</option> <option>30</option> <option>31</option> </select> </td> </tr> <tr> <td>Price</td> <td>:</td> <td><input type="text" name="Price" /></td> </tr> <tr> <td>Tickets</td> <td>:</td> <td><input type="text" name="Tickets" /></td> </tr> <tr> <td> </td> <td> </td> <td><input type="submit" name="Submit" value="Submit" /></td> </tr> </table></td> </form> and here is the insert.php file <?php $con = mysql_connect("localhost","teamrend_rwowen","291Aug89"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("teamrend_rwowen", $con); $sql="INSERT INTO Events (Event, Genre, Date, Price, Venue, Tickets) VALUES ('$_POST[Event]','$_POST[Genre]','$_POST[Date]','$_POST[Price]','$_POST[Venue]','$_POST[Tickets]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "Thank You, Your Event has now been added to our Records"; mysql_close($con) ?>

will test shortly, no internet connection on laptop where im coding stuck on a rubbish uni pc right now thanks for the help CB always appreciate it! going to google the real escape string now as i dont entirely understand it or where to put it

Ok so i have a HTML form seen below, which is linked to the file insert.php also seen below, when i enter the information all the text i enter goes into my database but the options i select from the drop down menu do not, can someone help? thanks ADDEVENT.HTML <form name="form2" method="post" action="insert.php"> <td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#DBDBDB"> <tr> <td colspan="3"><p align="center"><strong>Add Event </strong></p> <p> </p></td> </tr> <tr> <td width="59">Event</td> <td width="4">:</td> <td width="239"><input type="text" name="Event" /></td> </tr> <tr> <td>Genre</td> <td>:</td> <td><select name="genre" id="genre"> <option selected="selected">Genre</option>option <option value="Rock">Rock</option> <option value="Pop">Pop</option> <option value="Indie">Indie</option> <option value="Electro">Electro</option> </select> </td> </tr> <tr> <td>Date</td> <td>:</td> <td> <select name="Year"> <option selected="selected">Year</option> <option value="2010">2010</option> <option value="2011">2011</option> <option value="2012">2012</option> <option value="2013">2013</option> <option value="2014">2014</option> <option value="2015">2015</option> <option value="2016">2016</option> <option value="2017">2017</option> <option value="2018">2018</option> <option value="2019">2019</option> <option value="2020">2020</option> <option value="2021">2021</option> <option value="2022">2022</option> <option value="2023">2023</option> <option value="2024">2024</option> <option value="2025">2025</option> <option value="2026">2026</option> <option value="2027">2027</option> <option value="2028">2028</option> <option value="2029">2029</option> <option value="2030">2030</option> </select> <select name="Month"> <option selected="selected">Month</option> <option value="01">01</option> <option value="02">02</option> <option value="03">03</option> <option value="04">04</option> <option value="05">05</option> <option value="06">06</option> <option value="07">07</option> <option value="08">08</option> <option value="09">09</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> </select> <select name="Day"> <option selected="selected">Day</option> <option value="01">01</option> <option value="02">02</option> <option value="03">03</option> <option value="04">04</option> <option value="05">05</option> <option value="06">06</option> <option value="07">07</option> <option value="08">08</option> <option value="09">09</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> <option value="21">21</option> <option value="22">22</option> <option value="23">23</option> <option value="24">24</option> <option value="25">25</option> <option value="26">26</option> <option value="27">27</option> <option value="28">28</option> <option value="29">29</option> <option value="30">30</option> <option value="31">31</option> </select> </td> </tr> <tr> <td>Price</td> <td>:</td> <td><input type="text" name="Price" /></td> </tr> <tr> <td>Tickets</td> <td>:</td> <td><input type="text" name="Tickets" /></td> </tr> <tr> <td> </td> <td> </td> <td><input type="submit" name="Submit" value="Submit" /></td> </tr> </table></td> </form> INSERT.PHP <?php $con = mysql_connect("localhost","teamrend_rwowen","291Aug89"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("teamrend_rwowen", $con); $sql="INSERT INTO Events (Event, Genre, Date, Price, Venue, Tickets) VALUES ('$_POST[Event]','$_POST[Genre]','$_POST[Date]','$_POST[Price]','$_POST[Venue]','$_POST[Tickets]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "Thank You, Your Event has now been added to our Records"; mysql_close($con) ?>

Ok so ive used some tutorials and spent some time and managed to get a very very simple log in script working fine, however, what i want to do now is learn how to take advantage of this for example...make it so only members who are logged in can do certain things on my site. My website is an events management site (similar to seetickets/ticketmaster) however, users can add there own events to the database, this feature works however, its available to ALL users i want to make it so only users who have logged into the site can use this feature i have no idea where to begin really, everyone here usually gives fantastic advice so any help is useful! thanks rob

Now to find the HTML Form information... not sure if it exists sad times!

got it working using CURRENT_DATE just need to alter the html part now so the form input can only be in format 0000-00-00 so this doesnt mess up! thanks for all the help guys! this forum never lets me down !

issue us a varchar not date in my table....however, i can easily change i just used varchar to test my database was working! im not sure what date input is....is it 00/00/00? or like 00/00/0000? thanks rob

I have this code That pulls up "todays issue" from the table...but im looking to change it so that it pulls up items in the database with todays date. i.e - an issue with the date 15/02/10 would be displayed on the screen on that date only... i know its the above part i need to alter but im not really sure how If anyone has any other advice id be grateful im doing this for a school project so im aware its very basic but i honestly appreciate all advice as for me its all part of the learning curve and im keen to improve! Thanks in advance Rob

So i have a main.html page with HTML <form action="insert.php" method="post"> Event Name: <input type="text" name="Event" /> <br> Genre: <input type="text" name="Genre" /> <br> Date: <input type="text" name="Date" /> <br> Price: <input type="text" name="Price" /> <br> Tickets: <input type="text" name="Tickets" /> <br> <input type="submit" /> </form> I believe this is a simple form for just inputing data but i really do have poor knowledge! I then have a php page called insert.php and that page looks like so ; And my database looks as shown below This was meant to be a simple script to allow me to add information to the table but....i carnt get it to work despite playing around with it for ageessss could anyone help? or suggest a fresh code? its frustrating me to no end ! Thanks! Rob