Hi peeps...

A good day to all of you yea~ as i know, i can retrieve only the first row by using the keyword limit 1:
select * from tblTesting limit 1
for selecting the first two rows are:...

Hi there,

wanna ask if the sql syntax order by and group by the same?
eg: i have a dropdownlist and the values displayed should be in ascending order. hence is there any difference if i use...

Hi there,

i have question on arranging columns whereby the datatype is date and time how should i arrange them so that the latest date & time entry will be in the first row?

i have a table...

Hmm~ i will try to think abt it more seriuosly later.. if there're still problems occuring, i will try to post it again in here..

THANKS!!

oh that's okie! Thanks for replying too!

The code below means getting the values for selecting more than one items?
<%
cars = Split(Request.Form("car"), ",")
for each car in cars
...

erm.. i don't understand php language.. btw the multiple have already being included in my select tag. i'm using asp lang..

how is tt php array code going to help? i don't understand why array...

oh okie.. THANKS!!

how abt setting the listbox to allow users to select either ALL option or the items on the listbox? So that users can only select ALL and search or select one to more items on...

Oh thank you for giving me tips on using the code tags! As a new user, hence I do not know much of the tags and its functionality. Thanks anyway!

Erm.. That sql statemt you provided is to be...

:eek: I am sorry because i am in a hurry and in a haste to solve this error hence i write my words in short form.

Well, i will translate my message again:

I would like to select records which...

i wud like to select records which userStatus' values is sth.

ive gt a tbl with a userStatus column, dis column is stored with statusID and the values in dis column, userStatus, are either numbers...