Logician

When I: "select * from (table);", they are not alphabetical. I am wanting the table alphabetical when I select *.

Cool, so do you know how it can be done?

I have a column called alphabet, with the fields B, A, C, D: alphabet -------- B A C D I am wanting to know how I can go about moving A up to where B is, so: Alphabet -------- A B C D There are other fields from other columns on this same line: A | Active | Always This procedure would be similar to: ALTER TABLE (table) CHANGE COLUMN (column) (new column name) (type) AFTER (column);, but for a field instead of a column.

When I used it in an interpolated PHP thing, it broke my page. Thanks for the information.

I use PHP's mysql_real_escape_string() when using MySQL's INSERT. What I am wondering is if PHP's mysql_real_escape_string() should also be used when using MySQL's DELETE?

Thanks, The Little Guy. That worked perfectly.

Wow, I meant columns. Sorry about that confusing post. I have been stressing due to crossing the line over to a state of development nightmare. I make allot of mistakes when I stress. ... so when I execute: select * from alphabet; instead of seing: ... I want to see:

When I execute; select * from alphabet; I get the rows: Is it possible to move the column "D" over, so I get: ?

So, it was working all along. I only noticed now when I checked MySQL from terminal. I got it working the way I needed it using the HTML element <PRE> Solved.

OK, I am back on using MySQL with PHP again. This is what I just tried. Its being entered into the MySQL field, but there are not line brakes. $query = "INSERT INTO orders (events) VALUES ('".date(DATE_RFC822)."\nWRITING ORDER TO DATABASE\n')";

ah har! Thanks again haku, it worked a treat!

What I am trying to do is use: if (is_file(./products/$row['gender']/blue.png)) {echo "blue.png";} $row['gender'] is causing a problem. I have tried: {$row['gender']} {.$row['gender'].} .$row['gender']. but they didn't work. drat! Do you know whats wrong?

Arghhh!!! I just tried: ... so close! Thanks haku!

Is it possible to use if() with a file? I am trying to use it like this. if (./blue.png) {echo "blue.png<BR>";}

I see. Damn it! Do you know how making a line brake can be done in MySQL?