[PHP-DB] **Happy New Year**

2003-12-30 Thread php
Hi PHP Coders, Wishing you all a very happy and prosperous 2004. Aynsoft www.aynsoft.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Problem with INSERT Query

2003-12-30 Thread irinchiang
Hi all: Well, when i bring out the page with the drop down list it was able to display all tutors' names from tutor_name column. Anyway here's a review of my code (snip) again before i continue: --- snip $sql = INSERT

SV: [PHP-DB] Selecting between using letters

2003-12-30 Thread Henrik Hornemann
How about Select LastName from sometable where LastName = 'A' and LastName 'F' Hth Henrik Hornemann -Oprindelig meddelelse- Fra: Doug Parker [mailto:[EMAIL PROTECTED] Sendt: 29. december 2003 23:18 Til: [EMAIL PROTECTED]; [EMAIL PROTECTED] Emne: [PHP-DB] Selecting between using letters

Re: [PHP-DB] **Happy New Year**

2003-12-30 Thread -{ Rene Brehmer }-
A day early =) ... but happy new year to you too Rene Fate would have it, that on Tue, 30 Dec 2003 12:17:29 +0530, [EMAIL PROTECTED] wrote: Hi PHP Coders, Wishing you all a very happy and prosperous 2004. Aynsoft www.aynsoft.com Rene Brehmer aka Metalbunny http://metalbunny.net/

[PHP-DB] Re: Problem with INSERT Query

2003-12-30 Thread Hadi
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all: Well, when i bring out the page with the drop down list it was able to display all tutors' names from tutor_name column. Anyway here's a review of my code (snip) again before i continue:

[PHP-DB] Categories and Items query

2003-12-30 Thread Ali Van Doren
Hello, I am pretty new to PHP and MySQL, and am struggling with this particular page I would like to create. I am building a page which lists categories of house features (e.g. concrete, framing, foundation, etc.) and then the particular features that fall into those categories (e.g. the

[PHP-DB] Re: php-db Digest 30 Dec 2003 12:07:25 -0000 Issue 2191

2003-12-30 Thread Jeremy Shovan
Try this: select LastName from MyTable where left(LastName,1) = 'a' and left(LastName,1) 'f'; How about Select LastName from sometable where LastName = 'A' and LastName 'F' Hth Henrik Hornemann -Oprindelig meddelelse- Fra: Doug Parker [mailto:[EMAIL PROTECTED] Sendt: 29. december

[PHP-DB] Checking for duplicate records before update?

2003-12-30 Thread Jas
Problem. I have a database table that looks like this: eg. +--+--+---+---+-+ | id | hostname | mac | ip| vlan| +--+--+---+---+-+ | 1014 | MTPC-01 | 00:02:B3:A2:9D:ED |

RE: [PHP-DB] Checking for duplicate records before update?

2003-12-30 Thread Peter Lovatt
Hi This is an alternate approach, and may be more elegant and efficient Define hostname, mac, and ip fields as UNIQUE. then INSERT IGNORE into the table. Check to see if a row was inserted using mysql_affected_rows() http://www.mysql.com/doc/en/mysql_affected_rows.html if the row was

[PHP-DB] Re: Categories and Items query

2003-12-30 Thread Ali Van Doren
Well, I figured out how to do my nested loop, so now I think it's a fairly small problem that I have now: how to only select features that should show on the Deluxe Home Features page, or the Standard Home Features page. I have a table named feature_sets with three values (plus keys): both,

[PHP-DB] Re: Categories and Items query

2003-12-30 Thread Lang Sharpe
Having a Standard only, Deluxe only and Both will lead to problems in the future. (i.e. what if you add in a Basic feature set?) What I would do is 1. Get rid of the Both row in feature sets. 2. Have another table called feature_set_features or something better. The table has two columns, The

[PHP-DB] Re: Selecting between using letters

2003-12-30 Thread Kim Steinhaug
Im on my way to bed so short do it yourself answer, but you should look up the regex part of mySQL. I think you can match the beginning and end of a coloumns entry. And using the power of the regex function you could make a WHERE statement for somethink like [a-e] if it was a-e you were looking