samona

Hi, I was wondering if anyone can help me convert this query to just one regular query. $query = 'Select * From Volume as vol WHERE vol.Volume_ID = (Select Max(Volume_ID) From Volume Where Type = vol.Type and User = vol.User) ORDER BY vol.Type, vol.User';

Try the following: SELECT column_name(s) FROM table_name1, table_name2 ON table_name1.column_name=table_name2.column_name

Try the following $query = "SELECT eachsnake.Avid, specieslist.Scientific_Name, specieslist.Common_Name, specieslist.Image, specieslist.Map, eachsnake.Origin, eachsnake.Location ". "FROM eachsnake, specieslist ". "ON eachsnake.Scientific_Name = specieslist.Scientific_Name";

11 seconds, so a 78% improvement. That's great!

Thanks!!! Indexing worked nicely.

Hi, I have the following query in my php code $query = 'Select * From Table_Name as t WHERE t.t_ID = (Select Max(t_ID) From Table_Name Where Type = t.Type and length = t.length) ORDER BY t.Type, t.length'; It takes about 51 seconds to return the results in this query in a table with only 3,000 records. I was wondering if anyone knows a way to make this query more efficient?

Thanks for all the support. This is why I love this site. Thanks again.

WOW! From reading all these posts, I understand that when the battery power is low the OS will reduce the power to specific parts of the computer. One of these parts would be the wireless NIC which would mean the radio waves would have a shorter range, thus not enough power to compete with other users accessing the same WAP with more power and a wider range. Am I close?

Hi, I was wondering if anyone knew whether low batter power on a tablet PC could be a reason why I keep getting disconnected from the WAP.

what is <?=

Thanks for the reply. Basically what I want to do is set up a website with information about artists, thri music, and their bios. People should be able to search for singers by name, by song, and search for music by category. I'm not sure if I'm making it too complicated.

Hi, I was wondering if I could get some advice/comments/critiques on the database below. I want to make sure I'm going about this database correctly. Thanks. CREATE TABLE IF NOT EXISTS `Artists` ( `ArtistID` mediumint( unsigned NOT NULL auto_increment, `ArtistName` varchar(255) default NULL, `ArtistNotes` varchar(255) default NULL, `ArtistLink` varchar(255) default NULL, PRIMARY KEY (`ArtistID`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `Tracks` ( `TrackID` mediumint( unsigned NOT NULL auto_increment, `TrackTitle` varchar(255) default NULL, `TrackNumber` varchar(255) default NULL, `TrackLength` varchar(255) default NULL, `TrackCategory` varchar(255) default NULL, PRIMARY KEY (`TrackID`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `Categories` ( `CategoryID` mediumint( unsigned NOT NULL auto_increment, `CategoryDescription` varchar(255) default NULL, PRIMARY KEY (`CategoryID`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `Recordings` ( `RecordID` mediumint( unsigned NOT NULL auto_increment, `RecordTitle` varchar(255) default NULL, `RecordArtist` varchar(255) default NULL, `RecordCategory` varchar(255) default NULL, `RecordLabel` varchar(255) default NULL, `RecordNotes` varchar(255) default NULL, `RecordFileLocation` varchar(255) default NULL, `RecordDate` varchar(255) default NULL, PRIMARY KEY (`RecordID`) ) ENGINE=MyISAM;

Thank you all for your responses.

Yes! I see what you're saying. I'll also check out the MVC design pattern because it's the first of heard of it. Thanks!

How do you separate business logic from presentation logic without a Template Engine?

Hi, I was wondering what PhpFreaks users would recommend as far as template engines. I would like to build a small website and I was thinking of using the PEAR template engine ITX. However, I'm not sure if this would be the best way. I heard about Drupal and about how flexible it is, and was wondering if anyone thinks that that would be the best route. Thanks in advance for your advice and comments.

Hi, If i want to update one field in a record would that work or do i have to update all the fields. For example, if I have a table Customers ======== First Name Last Name Address Record ID If I want to just update the address, do I need to insert the First Name and Last Name again or can I just write a query that updates address for that particular Record ID.

I'll try that out.

Hi, I'm trying to hook up a drive that i have on an HP computer into my dell computer so that I can save the files on the HP hard drive to my dell. When i boot it, the computer says it doesn't support PCI device. I can't even get into the bios to make it a slave drive. Any ideas.

Thanks!

I was wondering if anyone knows whether there are 10Gb/s NIC cards for desktops, and whether getting them would even make a difference as far as speed in a 10Gb network. It would probably depend on the application but since I don't know of any application that supports 10Gb/s , I don't think it would be worth spending the money. What say you?

how about $your_file = "./manga/first_directory/"; $chapter = $your_file;

I think he's talking about permissions.

You would probably need javascript for that.

try the function empty(); if (empty($a_answer )){...}