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
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
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
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/
[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:
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
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
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 |
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
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,
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
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
12 matches
Mail list logo