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:
---
$sql = "INSERT I
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 letter
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/
Re
<[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 concr
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. decembe
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 | 15
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 inserted
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,
sta
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, Th
Thanks, Lang! I think I understand your description, and will try it
tonight. Thanks so much for responding!
:)
Lang Sharpe wrote:
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
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 fo
13 matches
Mail list logo
