RE: [PHP] More newbie help - mixing 2 different things into one database

2002-03-21 Thread Laurie Landry
Oh... maybe I should take a "How to send a full and complete email" newbie class instead? :) Here's the code: Add a Link to the Links Database $subjects"; } // create SQL statement $country_sql = "SELECT countries FROM countries ORDER BY countries ASC"; // execute SQL query and get re

[PHP] Fetching 1 array from either one of 2 possible columns?

2002-03-21 Thread Laurie Landry
I'm working on a query by selection type of form, where if a user selects a subject to get information. Each database entry will have 2 subject fields, Subject 1 being the main subject and Subject 2 being the cross-subject. A table is set up like this: +--+--+--+--+---

[PHP] More newbie help - mixing 2 different things into one database

2002-03-21 Thread Laurie Landry
Hi, In this example: I'm trying to introduce the selection data from another table in the database into this form. The form is a simple form where if missing any data, you're redirected back to the page to form but with data filled in some areas that you had filled in before. Now, instead of ma

[PHP] Links as a query point instead of form drop down box

2001-05-16 Thread Laurie Landry
I understand how to use a dropdown box to make your selection in which that selection is the criteria to display a database content; but I was wondering how I can achieve a query by link. For example, if you went to index.html file where there is a php coding that generates the categories availab

[PHP] MySQL Query not working?

2001-05-14 Thread Laurie Landry
Hi, I've got this sql setup where $sql = "UPDATE CLASS_ADS SET client_id = \"$client_id\", date = \"$date\", category = \"$category\", title = \"$title\", description = \"$description\", contact_name = \"$contact_name\", contact_number = \"$contact_number\", email = \"$email\", url = \"$url\",

RE: [PHP] PHP Editor

2001-05-12 Thread Laurie Landry
I like using Homesite - color coordination of code as well. I use Dreamweaver for the design elements as well, but sometimes it doesn't work very well for php coding. Laurie M. Landry Design & Development www.lmlweb.com [EMAIL PROTECTED] T: (604) 872-6915 F: (425) 732-1547 > -Original Mes