Problem with mysql_fetch_array

Codes here !

Moderators: egami, macek, gesf

Post Reply
User avatar
freshnet
php-forum Active User
php-forum Active User
Posts: 359
Joined: Tue Feb 22, 2011 8:19 am
Location: Canada

Fri Aug 24, 2012 3:34 am

Your query is selecting a column called rests.name. You can't echo back a column that isn't in your results. You'd have to do something like

Code: Select all

SELECT region, rests.name, rests.zip FROM delivery_areas, rests WHERE city = 'Ciccagna' AND rest_id = rests.id");

NigelRen
php-forum Fan User
php-forum Fan User
Posts: 622
Joined: Fri Aug 05, 2011 9:53 am

Fri Aug 24, 2012 11:22 pm

When your accessing fields from mysql_fetch_array, you should have quotes around the field name, so it should be

Code: Select all

echo $search['rests.name'];

Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 4 guests