can not retreive data from db

[phpmysqlrules]

Greetings...
Could someone give me some advice abut this piece of code..

I am abel to retrieve the listings from the database but it doesnt give the particulars about each field//

Instead of displaying the name of the actual company city or webpage it just says company city and webpage for the number of retreived results... any idea what I am doing wrong ..ben pulling my hair out (dont have much left ... 🙂

Thanks for your time and response in advance ..much blessings for your help ...phpmysql rules

$query= ("Select 'company', 'city' ,'webpage' from lexus_dealers where state = '$state' ");
$result = mysql_query ($query);
$num_results = mysql_num_rows($result);
echo "<p>There are currently $num_results dealers in the state of $state .<br>";

for ($i=0; $i <$num_results; $i++)

{

$row = mysql_fetch_array($result);

echo htmlspecialchars(stripslashes($row["company"]));

echo htmlspecialchars(stripslashes($row["city"]));

echo htmlspecialchars(stripslashes($row["webpage"]));

}

mysql_close ($link);

[hkucsis]

Take away the ' in the field name

$query= ("Select company, city , webpage from lexus_dealers where state = '$state' ");

[phpmysqlrules]

I appreciate your reply..it worked like a charm..first try bingo...wow

It gets a little confusing when you are reading from a few resources I guess...

Thanks for your help..
PS does any one know of a good php book for newbies ...

I have Luke Welling and Laura Thompson (phpmysql web developement ) not a bad book but they skim over some things that are important to newbies...

Thanks
hkucsis you are the bomb

phpmysqlrules

[billspeg]

hey i have the same book maybe we can get through it together if you are interested since i am a newbie too please e-mail me at [e-mail]

[cgraz]

That's really the only PHP book I ever used, so I can suggest any others, but there are a ton of awesome resources online (such as this one) and great tutorials everywhere. That's what's great about open source. Huge online community of people willing to help.

The best way to supplement a book (IMO) is to read tutorials, use forums wisely (don't post questions like "where's the parse error" cause you can easily find those, but things like concepts, ideas, or problems you run into).

www.devshed.com has great php and mysql tutorials (along the links to the left)

http://www.onlamp.com/php/ is also a great site with easy-to-understand tutorials.

And here are a few more links:
http://www.devarticles.com/cats/9
http://www.edevcafe.com/viewcat.php?id=4

Cgraz