Programming Help

Web Development



What's Here?

  • Members: 132,460
  • Replies: 471,230
  • Topics: 73,060
  • Snippets: 2,540
  • Tutorials: 666
  • Total Online: 1,371
  • Members: 96
  • Guests: 1,275

Who's Online?

Welcome to Dream.In.Code
Getting PHP Help is Easy!

Join 132,460 PHP Programmers for FREE! Get instant access to thousands of PHP experts, tutorials, code snippets, and more! There are 1,371 people online right now. Registration is fast and FREE... Join Now!




Help With Php/mysql

 
 Reply to this topicStart new topic

Help With Php/mysql
NoVA_X
post 7 Mar, 2005 - 04:32 PM
Post #1


New D.I.C Head

*
Joined: 7 Mar, 2005
Posts: 6
Ok so I have a query...

CODE

$p = $_GET['p'];
$query = 'SELECT * FROM subnav WHERE page = '.$p;


and there are 2 large problems with it:

1) A PHP Problem
Its on a remote server that I use to access my database... Another page with queries works perfectly fine remotely included, but this one cannot seem to grab $_GET['p']. Run directly on the server it grabs it fine.

2) An SQL Problem
When it does return the query right, it comes up with a VERY strange result:

QUOTE
Query Failed : [SELECT * FROM subnav WHERE page = home] : Unknown column 'home' in 'where clause'


It should not be searching for it as a COLUMN! What is going wrong here?
User is offlineProfile CardPM

Go to the top of the page

skyhawk133
post 7 Mar, 2005 - 04:35 PM
Post #2


Head DIC Head

Group Icon
Joined: 17 Mar, 2001
Posts: 14,844



Thanked 45 times

Dream Kudos: 1650

Expert In: Web Development

My Contributions
Very easy solution. You need to put tick marks around your variable, home is being seen as a column name not a value. All strings must have quotes around them.
User is offlineProfile CardPM

Go to the top of the page

NoVA_X
post 7 Mar, 2005 - 07:53 PM
Post #3


New D.I.C Head

*
Joined: 7 Mar, 2005
Posts: 6
Thanks, that worked perfectly anime1.gif Now only 2 things left:

1) The first problem is still unsolved. The included page (subnav.php) doesn't seem to be inheriting the GET. Would this function in index.php help?

CODE
function getSub()
{
 $page = $_GET['p'];
 $include = "remoteserveraddress/subnav.php?".$page;
 include($include);
};


2)
EDIT: Fixed it myself! Spelling typo.

...Help? smile.gif

This post has been edited by NoVA_X: 7 Mar, 2005 - 07:55 PM
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/22/08 12:29PM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live PHP Help!

PHP Tutorials

Reference Sheets

PHP Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month