johnnybravo

Hi guys, I'm trying to build a content management system using PHP/MySQL for a design site. My problem lies in the portfolio section of the site. I am working on the Add new project code and want to have the facility to add multiple images or files to the project. I've made a script which launches in a popup window and allows me to upload images and then adds a image reference into a seperate images table in my db but im strugling to link the two together. I dont want to have to upload the images before I add my new project, I want to be able to do it at the same time but I also want to be able to have multiple images for one project. Can anyone point me in the right direction? thanks john

Fantastic, got that working thanks! I have another question now... I want to be able to filter the records... I would like to be able to limit the results to the first entry for each month, is that possible? Code so far is: SELECT ID, DATE_FORMAT(Date, '%W %D %M %Y') as Date from tbltest WHERE DATE_FORMAT(Date, '%j') > '$CurrentDate' ORDER BY DATE_FORMAT(Date, '%j') ASC LIMIT 5 thanks again for your help so far John

Hi I am currently building a Content Managment Driven website using PHP and MySQL. I have come across a problem with my dates... Basically I need to be able to insert a custom date into my database and then retrieve the date and format it in different ways. For example: 17 July 2007 Tuesday 17 July 2007 17/07/2007 Is this possible from one field with the date in MySQL? What format do i need to insert the date into the database? How can i format the date in these different formats? The one really stumping me is the Day of the week??? My next problem is I want to sort these fields, first by the month and then by the date of the month i hope someone can shed some light thanks in advance John

ignore my last comment i have it working now with the code supplied, thanks for your help.

This kind of works, well it gets the data from the database and updates the relevant dropdown selections but if i re-submit the form to write new selections to the database it doesnt do it, it just resets the values to nothing. any ideas? In short i want to be able to update database when i click submit with any modifed changes thanks J

Hi guys... I'm building a content management system using PHP and MySQL so that we can add and remove projects from our website easily. I want several dropdown lists with the options Yes/No (or radio buttons, whichever is easiest) in them and depending on the users choice it will add their choice into the db. I have the Add page working fine, but the problem lies in the update page. if i go to my update page it pulls all the right information back into the HTML form from the DB until it gets to the dropdowns, which it doesnt like. How can i make it select the appropriate option from the dropdowns depending on the DB? If i submit the changes it wont update it either and gives errors from the dropdown code. The code im using for the Add is as follows: <select name="ServiceWeb" class="admin_form"> <option value="No" selected="selected">No</option> <option value="Yes">Yes</option> </select> and the problem code for the Update page <select name="ServiceWeb" class="admin_form"> <?php if ($ServiceWeb=="Yes") { ?> <option value="No">No</option> <option value="Yes" selected="selected">Yes</option> <?php } else { ?> <option value="No" selected="selected">No</option> <option value="Yes">Yes</option> <?php } ?> </select> Another thing to mention is that in the MySQL db i have the entry for ServiceWeb set to TEXT at the moment, this can be changed however you see fit! hope this all makes sense, im sure what im trying to do is SO simple but i have been struggling with it all morning. thanks John

Hi guys, I want to add a couple of audio samples to a clients website.  I would prefer it if they would just simply play on the actual page (only when a button is pressed though) rather than them downloading the clip or it redirecting to another page. The pages are all in php and HTML. What would be the best way to achieve this? thanks John