Search results

  1. S

    Problem updating database through form

    I've a series of PHP pages on a website which allow you to either update your subscription details or unsubscribe. Firstly you enter your email address and, presuming you enter a valid one, your details are taken from the MySQL database table and listed followed by two buttons - one to update...
  2. S

    MySQL question

    Is it possible to insert a new field into a table (using either PHP or going through phpMyAdmin) that will automatically have a word in it for each record - without needing to edit each record as there's over 1500? Doesn't really matter what the word is, can be 'yes' for example, just needs...
  3. S

    batch emailing

    here's the main chunk of code to show where I'm up to, using PHPMailer (v5) to allow sending out html emails to a database held mailing list $result = @mysql_query($query); while (1==1) { set_time_limit(30); // sets (or resets) maximum execution time to 30 seconds) // .... put code...
  4. S

    MySQL SELECT Query question

    So far all the MySQL queries I've used that include WHERE have been nice and simple, such as: SELECT * FROM subs WHERE exhibitions='yes' But what happens if the field you're dealing with is populated by a series of keywords and you want to make a selection based on just one from that...
  5. S

    database driven html email problem

    I need to be able to set up an email facility for a website that 1. has a small number of templates (eg. header, editable main text body and footer, the information for which will be in a MySQL database) 2. can be sent to multiple email addresses (addresses taken from the same database but...
  6. S

    PHPMailer / MySQL Array Problem

    Attempting to get an example file for PHPMailer 5 to work, one that pulls info from a database to send to multiple recipients. I've ammended the test file to include all my relevant settings (username, password, etc) but am getting the following error message: Warning: mysql_fetch_array()...
  7. S

    PHP problem - if / else

    currently the code in question looks like this: <tr> <td width="140" height="30" align="left" valign="top">Interests</td> <td width="320" height="30" align="left" valign="top"><input type="checkbox" name="exhibitions" value="yes" <?php if ($exhibitions == 'yes') ?>...
  8. S

    how to ignore empty results from MySQL query in PHP?

    I'm planning to try a few approaches to pulling out information from a MySQL database using PHP that will break things down into groups according to year - it's for an art gallery archive. Each group of results will have the year displayed top left (only once), then on the right the list of...
  9. S

    Query String - $_GET problem

    As part of a MySQL driven CMS I need to pass an id to a page which inserts new content into a database table The links on one page, dealt with using an array, include the query string after .php such as ?id=8 - all good. The form page needs to use this id in a hidden field: exhibition_id...
  10. S

    SIMPLE Slideshow / Carousel needed

    Is there such a thing as a really basic slideshow or carousel script out there!? Maybe something in jQuery I've missed? No fancy crossfades or movement, no buttons that only appear if you hover over the image, just a good old click on custom next / previous buttons to get the next image...
  11. S

    PHP Problem

    So close, yet so far I'm attempting to develop a series of pages which display text from a database and have an edit button. When you click on the edit button the text becomes editable (using TinyMCE). The code for editing / updating the text works when the edit button isn't included. The...
  12. S

    PHP Sessions

    I'm attempting to create a page that can switch between 2 sets of content, using Sessions and a form button. Eventually it'll be used in a CMS to switch between an initial preview of how the page content looks and an editable version, but for now I'm just trying to get a basic functioning...
  13. S

    PHP / MySQL SELECT problem

    I'm attempting to set up a simple MySQL SELECT which uses a variable to identify the row it selects. If I use the following (using an actual id rather than a variable) it works perfectly: <?php // Request text for page $content = @mysql_query('SELECT text FROM page_text WHERE id="9"')...
  14. S

    Problem selecting database with PHP

    currently attempting to learn the basics of MySQL and PHP, which was going OK until I wanted to connect to a database. I've created a database and put in some tables, set up a user with username and password, all through MySQL and phpMyAdmin. I've two PHP files, the first storing the...
  15. S

    Simple Slideshow script/module needed for CMS

    I'm looking to use a very simple Slideshow script on a number of pages on a website for an art gallery. No thumbnails or enlargements, purely a single image that will change as you click on next / previous buttons and ideally will have the option to include a caption for each image. I intend...
  16. S

    PHP Scripts

    hello! Any suggestions for good websites with free PHP scrips for forms? cheers
Top