Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Expand option to display further query details
Hi, I have a php script which calls messages from a database but I'd like to allow people to make a comments on the messages and view old comments by selecting a button which will expand to show all the comments made on a specific message: Code to retrieve messages... -
Running PHP Script with Cronjob
Hi, I'm attempting to run a PHP script using a Cron job, which imports a csv file into a mysql database. I initially scheduled them to run within crontab but they were never performed. I've tested to ensure PHP is set up correctly and that cron is really running. When I've attempted to run...- mcmon999
- Thread
- Replies: 1
- Forum: Linux (server)
-
Escape apostrophe when importing into MySQL
Hi, I'm trying to import a CSV (tab) delimited file into a MySQL database, however it error's when importing fields with an apostrophe. I'm importing the data using the fgetcsv function: $filename='http://www.test.co.uk/2009-09-14.txt'; $handle = fopen("$filename", "r"); while... -
Parse XML file into MySQL Db - Db error message handling
Hi all, I'm attempting to parse an XML file into a MySQL database using simpleXML but keep encountering the error "Duplicate entry '203581' for key 'PRIMARY'" Is it possible to skip these transactions? so the error does not occur. Would it potentially be possible to do a IF statement and... -
Selecting the most recent records added to a table
I'm trying to select the most recent records added to a table. I have three tables (User, user_training, training) user_trainging is resolving the many to many relationship and the table i am querying. When i run a normal query grouping by the training ID, it selects the first record inserted... -
Concat Variables to build URL
Hi, I apologise in advance but i'm very new to this. I'm trying to join three variables to build a URL: <html> <head> <script type="text/javascript"> var a = 'http://www.testing.com?'; var b = '%PRODUCT_FIELD(MovieURL,1)%'; var c = '&test'; function url(a, b, c) { url = a+b+c return url }...- mcmon999
- Thread
- Replies: 3
- Forum: Javascript
-
Validation
Hi, I'm using an example of some validation i found on the internet but it does not allow me to submit Spaces between words. E.g i can submit "this_is_a_test" but can not insert "This is a test" CODE: <!-- function validateFormOnSubmit(theForm) { var reason = ""; reason +=...- mcmon999
- Thread
- Replies: 4
- Forum: Javascript
-
Dynamic dropdown menus
Hi, I have a form which contains three dropdown menus. The second is dependant on the first dropdown but i can get it to automatically reload the second menu without me having to pressing the submit button: <form name="program_search" action="task_management.php" method="get" > </p> <table... -
Changing Background Colour dependant on date
Hi, i've created a php frontend, that displays a table of data which contains tasks and dates, i need to change the background colour of the cells dependant on how old the tasks are. Does anyone know how i should do this or of any threads that would be useful? Thanks in advance. -
Using Variable to create view
Hi, I'm trying to create a view using a variable entered by the using, i started by using the code below: <?php $programid = $_GET['prog_id']; //echo "$programid"; $period = $_GET['period']; //echo "$period"; $query=mysql_query("drop view IF EXISTS... -
Date Problem
Hi, i have some code that allows the using to input the date. how do i join the day, month and year so it can be reversed into MySQL date format? is this the easiest way to create a date drop down? Code: <tr> <td>Shift Date</td> <td><div align="left"> <?php $months =... -
Update problem
Hi, I have a problem updating a table in MySQL. I'm selecting a specific record to update. the code below outputs the results to screen. <?php $query=mysql_query ("SELECT job_no, staff_no, service_id, airline_id, Flight_no, seat_no, place_met_pax, place_left_pax, status, desk_no, Completed_by...
