-Felix-

No one can do this? Seriously, I thought it was just a couple of rows of code, not a big deal!?

Let's say there's site A with lots of text and information. There is information that is changing weekly, even daily. Take for example currency rates. They change hourly. Now on my site, I simply want to quote/fetch the live currency rate from that other site. How to do this with PHP?

Could you post a simple example code? I'm somewhat a beginner in PHP coding.

Often you see websites that quote information from another site, for example prices: Website A presents a product and then quotes the price from website B, the seller, and gets that information displayed on their site (Website A). The advantage of this over manually getting this information is that it is automatically updated when the seller changes their price and thus you don't have to visit this site B every day/week to check if the price has changed. Instead, everytime your page is loaded it will fetch the price information from that other site. Now, how do I do this???

When I a user registers a new account, he/she must choose a user name. Of course, I dont want two users to pick the same username, so what I need to know is how to search the MySQL table to find out if a specific user name has already been picked? For example, a user enters desired username: Bob So I need to search if there already is a user registered with "Bob" How do I do this? mysql_query("SEARCH.....") ????

Hey its me again and stupid questions volume 3.... I dont get any errors, the following code just does not write anything to MySQL. mysql_connect ("localhost", "login", "password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("database"); $serialnumber=$_SESSION['Serialnumber']; $Quality=$_SESSION['Quality'].'; '.$_SESSION['Quality2']; mysql_query("INSERT INTO Tablename (Serialnumber,ID, Date, Details,Quality,Time,Status,Address) VALUES ($serialnumber,'1',$date,$Details,$Quality,$Time,'Waiting','Address')"); mysql_close();

ok, it reports abcd is the username Im using. But I dont get this...I have only one profile in this database because Im testing, I have made sure many times that there really is the correct username, in the correct field. ???

nope, doesnt work either. Somehow Im guessing that there is something wrong with the "Email" Im using as an index? In the database admin I have set Email-field as a Primary field, but it is not an index field. Could this be causing the problem?

mysql_connect ("localhost", "login", "password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("login_database"); $username=$_POST['user']; echo $_POST['user']; $result=mysql_query("SELECT * FROM Profiles WHERE Email = $username"); $row=mysql_fetch_assoc($result); $SQLEmail=$row['Email']; $SQLPassword=$row['Password']; I get an error

umm...thanks for the replies guys, but you lost me lol ...Im using a web based admin tool to store mysql data. I guess Im really a beginner. could you explain a little more specifically what I should do? I can add a field, and then choose a type for it, default values etc., but I dont know what type would be best in this case when same car can have multiple qualities.

Lets say I have the details of 500 cars stored in mysql database. What would be the best way to categorize these so that I can easily print a list of all the "blue cars" and all the cars with "airconditioning" for example? Assuming that these are all in one table, the best way would probably to add a field that indicates what the color of the car is and if it has aircondition. Ok, but what if one car has both qualities? What would be the best way to do this?