Jump to content

bluedogatdingdong

Members
  • Posts

    10
  • Joined

  • Last visited

    Never

About bluedogatdingdong

  • Birthday 02/10/1962

Contact Methods

  • Website URL
    http://www.erccis.co.uk/data
  • Yahoo
    jzhfarwest

Profile Information

  • Gender
    Not Telling
  • Location
    Penzance, Cornwall

bluedogatdingdong's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Got there eventually - it was simply <?php echo $row_Recordset1['URL']; ?> I'm sure I tried that yesterday!
  2. Hi I have been generating links to pages and passing options within my web site using species.php?Species=<?php echo $row_species[species]; ?> in the properties/links in Dreamweaver for example, which works fine. I now want to create a related links directory and can't get the syntax right. The domain I want to point to is in my database in a field called URL, but whatever I do it seems to want to open the original domain too. I'm sure it's simple - when you know how! Any ideas please?
  3. I'm sure the code must be quite simple, but I can't find an example anywhere. All I want to do is instead of displaying the image name eg boat.jpg actually display the image. Any help much appreciated. Jayne
  4. Hi I'm a newbie, I keep dipping in and out of PHP/MYSQL and am using Dreamweaver to generate code. I am trying to set up a diary of events. I can select all the distinct months and pass to a query page, like so: <?php mysql_select_db($database_cwt, $cwt); $query_Recordset5 = "SELECT distinct monthname(Date), DATE_FORMAT(Date, '%M') as month FROM events ORDER BY events.`Date`"; $Recordset5 = mysql_query($query_Recordset5, $cwt) or die(mysql_error()); $row_Recordset5 = mysql_fetch_assoc($Recordset5); $totalRows_Recordset5 = mysql_num_rows($Recordset5); ?> This works fine and generates the correct url, http://localhost/xampp/testingserver/event...hp?date=January But I can't seem to retrieve it through the query page, I've tried alsorts, most of which is generated by Dreamweaver. <?php $colname_Recordset1 = "1"; if (isset($HTTP_GET_VARS['date'])) { $colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['date'] : addslashes($HTTP_GET_VARS['date']); } mysql_select_db($database_cwt, $cwt); $query_Recordset1 = sprintf("SELECT * FROM events WHERE (DATE_FORMAT('date', '%M') = '%s'", $colname_Recordset1); $Recordset1 = mysql_query($query_Recordset1, $cwt) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?> I seem to be getting worse instead of better. Is my syntax just muddled or have I got it completely wrong? Any suggestions welcome
  5. I have tried your suggestion and it won't insert a record at all now! Sorry I am a real begginer, do I have to alter anything else?
  6. Hi Another problem I can't get my head around. I am trying to insert an record into a table but one of the fields is a lookup to another table ...... (this bit works okay) ...... but I need to be able to make multiplue selections. Althougn it looks like you can selct more than one, it only adds 1 record. See example at http://www.cornwallwildlifetrust.org.uk/ev...dtwotables1.php Username: diaryeditor Password: havefun I've cheated at the moment and passworded the whole directory - next job will be to set up a proper loggin system!
  7. Thanks for all your replies - I used the SQL option in the end. I should have known, I done it once before, and forgot!
  8. I am trying to list a diary of events on my web site. The date format is MySql is yyyy/mm/dd - 2004/07/26 I need to reformat the field on the web page to Monday 26 July 2004 for example I've found all the variables to reformat is straight PHP speak ie "l j F Y" I've tried <?php echo date ("l j F Y", ($row_Recordset1['date'])); ?> but this returns Thursday 1 January 1970, which wasn't at all what I was expecting. So what is the syntax to format the required field? <?php echo $row_Recordset1['Date']; ?>
  9. My test WebpageI can create a Dynamic List Menu without any problems, and I can create a Jump Menu without any problems, but I can't seem to combine the two to create a Dynamic Jump Menu! I just want to populate the Menu with species pulled from the database, which when selected take the user to a Master Detail page. Any help would be appreciated. Jayne
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.