Re: [PHP-DB] Display data begin with "A"

2001-04-07 Thread Naga Sean
Okay it's working now.. How if I want to display all the data begin with NUMBERS. like "1,2,3,...,0" --- "Frank M. Kromann" <[EMAIL PROTECTED]> > wrote: >wyoy could use a SQL statement like this: > >select * from myTable where LastName like "A%" > >- Frank > >> Guys, >>

[PHP-DB] Still not - Display data begin with "A"

2001-04-07 Thread Naga Sean
It still not working I want to get the result of people with the first later is "A" in my database Here is my syntax : $result = mysql_query("SELECT * FROM mydata WHERE name like '$begin'%",$db); the $begin is from the URL link www.sample.com/name?begin=a Thanks --- "Frank M

[PHP-DB] Display data begin with "A"

2001-04-07 Thread Naga Sean
Guys, How to view the result from the table. If I only want to display persons begin with letter A in the front. _ www.kaskus.com - FREE EMAIL SERVICE -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [

[PHP-DB] SOLVED SORRY - Delete all Data and keep the Table

2001-04-02 Thread Naga Sean
How to delete all the data in database, without delete the table. Looks like I can't delete all the data with single click in PHPmyAdmin mySQL -naga _ www.kaskus.com - FREE EMAIL SERVICE -- PHP Database Mailing List (http://www.php

[PHP-DB] Delete all Data and keep the Table

2001-04-02 Thread Naga Sean
How to delete all the data in database, without delete the table. Looks like I can't delete all the data with single click in PHPmyAdmin mySQL -naga _ www.kaskus.com - FREE EMAIL SERVICE -- PHP Database Mailing List (http://www.php

[PHP-DB] DONE - Confuse w/ count function? / THANKS

2001-03-30 Thread Naga Sean
$result); > >echo "The number of items in the database is: $numberOfItems\n"; > >hTH > >-Original Message- >From: Naga Sean [mailto:[EMAIL PROTECTED]] >Sent: Friday, March 30, 2001 11:59 AM >To: [EMAIL PROTECTED] >Subject: [PHP-DB] Conf

[PHP-DB] Confuse w/ count function?

2001-03-30 Thread Naga Sean
I try to use this count function, but no matter how. I got this result from $t = Resource id #4 $t = mysql_query("SELECT COUNT(*) FROM my_table",$db); echo($t); any comments ? -naga --- Andrei Skorokhod <[EMAIL PROTECTED]> > wrote: >if you just need the number > >SELECT COUNT(*

[PHP-DB] Take out one Data and show it in page

2001-03-28 Thread Naga Sean
I had a question here. How to pull up one database, and then view that row what I mean here is NO NAME AGE 1 JOHN 12 2 RYAN 23 3 JIM42 I want to take JOHN out from database using URL www.example.com/template.php?name=JOHN here is my coding so far, and I know it's wr

[PHP-DB] Select Database number & show it

2001-03-28 Thread Naga Sean
Friends, Can you tell me how to select database between 1-5 and then show it to the web. ex : 1 xx 2 xx 3 xx 4 xx 5 xx 6 xx 7 xx 8 xx 9 xx 10 xx I think it's easy, but I'm a beginner here. so I don't know how to do that. Tha