Webmaster Forum / PHP / Database Access / September 2006

Hi, My SQL lessons are very far :(
CREATE TABLE CONTACTS
(ID INT,
NAME VARCHAR(10)

My sql query will not seem to bring back dates in the correct order. It
will brin them back in a semi-order. Here is the query and what it
brings back. Any thoughts on how to get the dates to come back in
order, formatted the way I want? Thanks.

I have created a form, for users to enter the name of a file and it
then gets displayed. This works..
I've editted it so the form now search through a few different fields
and tries to match..

I have a table structured as follow:
id | user_id | credit
---+---------+-----------
1  | 1       | 5

Hi, I need to creater a searcher like for a site, like for example the
search engine of imdb.com.
The os is linux with php and mysql (or postgress)
It needs to search a word(s) and it can return a page with results of

I did a complete export from my MySQL 4.0 db and imported into MySQL
5.0.  But I'm having a problem with the mysql.user table.  From my old
db, I have an entry in there, "remanr", but now when I type the
username and password, I get this message ...

From a performance perspective, assuming my table might grow to a sizeable
number of entries, is it better to use VARCHAR or CHAR?  Intitution says
that CHAR would obviously be faster to search through, but if I'm not using
the VARCHAR element in a WHERE clause then it's probably ...

I want to search the database for users who have email addresses whose email
username matches their stored username.
So assuming my table is like so:
TABLE `users`

I've wrote a statement which generates 150.000 rec's, randomized it and now
I would like to export 1st 10.000 rows (take the sample of data) but don't
know how (?)
I would appreciate any help

I have a table that contains the following records.
+-----+-----+-----------+---------------------------------+------------+----------+

filesize |

I have the following table in mysql:
id    | description
1     | some text1
1-A |

I have the following statement:
SELECT SUM(`Quantity Ordered`) FROM `Sales Detail Information` WHERE
`Catalogue Number` = "FBDCD008";
I can run this as a query in the SQL window, and it works fine.

I'm using this query with PHP and an Access database. It works well and
returns the results expected..
[code]
strSQL = _

I am creating a website to sell music I write, and I want to make use of
MySQL to do things like:
Record Customer Infomation (including logins and passwords)
Record Product Information

am doing something wrong, for sure... I just fail to see it atm where
the failure is. Call me stupid :p
Someone have a look please
<?php