Hey CodeProject! So I'm trying to make a query in PHP and mySQL.. One of the database tables has a value I want to SELECT DISTINCT while selecting everything else regularly with an asterisk (*). Example: $model_select = "select DISTINCT model FROM models where shw=1 ORDER BY modelid"; $model_select = "select * FROM models where shw=1 ORDER BY modelid"; Is there a way I can do both DISTINCT and * in the same query command? Or is there a way around this without making 2 queries? It would be great if I could 'cause I'm using the mysql_fetch_array thing. Thanks. -Paul

So I'm writing an index page that calls a header file within a different folder. The pages that seem to not work are the index pages WITHIN other folders and using ../ to get back to the root folder and back into the include folder, if the pages are within the root folder and call the header by going through the include folder, it works. Kind of hard to explain.. But I'm getting these errors..

Warning: main(paul\_menubar\_test/menubar\_test\_filesavail.php) \[function.main\]: failed to open stream: No such file or directory in /home/new2/include/headers.php on line 190

Warning: main() [function.include]: Failed opening 'paul_menubar_test/menubar_test_filesavail.php' for inclusion (include_path='.:/usr/php4/lib/php') in /home/new2/include/headers.php on line 190

And that's an index file that's within a different folder in the root folder. I have an index file in the root folder that does the call for the include/header and it works. If you need any clarification, please ask.. I don't know how else to word it. I've checked google and people just say "lol check ur pointers," I did, like a 100 times. I've tried all sorts of "/," "../" and all that. I've also read that I may need to change the permissions of the folder or something? I'm not sure how to do that.. but the other problem is every single page calls the FOOTER file, which is also in the "include folder," has no problem. -Paul

I found it out. Simple enough.. I was just only wondering WHERE I should make the SQL code. I'm using SQL Manager Lite for MySQL and you just have to go to the database table, click the DLL tab, edit, delete all the code and write whatever you want and execute.

UPDATE tablename SET columnname = 'whatever' WHERE columname = 'asdf' OR columname = 'asdf ®'

Currently I have a column in a MySQL database full of car makes such as Audi, Porsche, and BMW. Although, the make column is filled with either Audi or Audi® or Audi ® and for the other car makes. There are over 2000 rows. I'm trying to figure out how to make every row just "MAKE ®" without typing it because I'm using it to make a menu in php/javascript and it repeats menu items like "Audi" and "Audi®" and "Audi ®." http://i54.tinypic.com/w7zm6c.png I've tried SELECT DISTINCT but that just takes away the repeated makes, I need to change all the makes to follow the same format. For example I have.. $makes_select = "SELECT DISTINCT make FROM files_avail where shw=1 ORDER BY make"; // Fetching of makes I was looking up the MySQL Reference Pages like on here: http://dev.mysql.com/doc/refman/5.0/en/replace.html And query commands like UPDATE and INSERT. But I am unsure of how to do it in MySQL, I didn't want to do anything before I screw up the entire database :3 Thanks! -Faul