RE: [PHP] Variable Appended To The End of a URL Is Not Working in SQL Query

2002-04-02 Thread Rick Emery 

Jason means that you should execute it from the mysql command line;
In your PHP code:  print $sql.
Then copy from that window and paste into mysql command line and execute.
What are the results?

-Original Message-
From: Dr. Shim [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 10:48 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Variable Appended To The End of a URL Is Not Working
in SQL Query


Hmm, run it manually? I'm a newbie, so, could you explain how I'd do that?
=)

Jason Murray [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I'd say $id is blank, not being passed in, or is equal to a
nonexistant IDArt.

Maybe you should echo out your SQL and run it manually to see
what's going on.

J

--
Jason Murray
[EMAIL PROTECTED]
Web Developer, Melbourne IT
Work now, freak later!

 -Original Message-
 From: Dr. Shim [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 02, 2002 2:41 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP] Variable Appended To The End of a URL Is Not Working in
 SQL Query


 I have a variable which is appeneded to the end of a URL, like

 http://www.your_web_site.com/your_page/?your_variable=your_value

 This would return your_value;

 echo $your_variable;

 But this wouldn't work, and returns an error

 $sql = SELECT * FROM fldField WHERE IDField =  . $id;


 What could possibly be wrong? If you need more info, then
 tell me. Here's my
 code:

 ?php
  $db = @odbc_connect('ReviewDatabase', 'root', '') or exit)(Error
 occured:br$php_errormsg);
  $sql = SELECT * FROM tblArt WHERE IDArt = $id;
  $cursor = @odbc_exec($db, $sql) or exit (Error
 occrued:br$php_errormsg);
  odbc_close($db);
 ?



 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Variable Appended To The End of a URL Is Not Working in SQL Query

2002-04-02 Thread Dr. Shim 

I'm using ODBC (Access). But I can execute the SQL manually in Access too. I
did, here's my query:

SELECT * FROM fldField WHERE IDField = 3;

I have to actually put in a value for IDField, it doesn't recognize my
variable, of coarse. This works just fine.

Rick Emery [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Jason means that you should execute it from the mysql command line;
In your PHP code:  print $sql.
Then copy from that window and paste into mysql command line and execute.
What are the results?

-Original Message-
From: Dr. Shim [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 10:48 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Variable Appended To The End of a URL Is Not Working
in SQL Query


Hmm, run it manually? I'm a newbie, so, could you explain how I'd do that?
=)

Jason Murray [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I'd say $id is blank, not being passed in, or is equal to a
nonexistant IDArt.

Maybe you should echo out your SQL and run it manually to see
what's going on.

J

--
Jason Murray
[EMAIL PROTECTED]
Web Developer, Melbourne IT
Work now, freak later!

 -Original Message-
 From: Dr. Shim [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 02, 2002 2:41 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP] Variable Appended To The End of a URL Is Not Working in
 SQL Query


 I have a variable which is appeneded to the end of a URL, like

 http://www.your_web_site.com/your_page/?your_variable=your_value

 This would return your_value;

 echo $your_variable;

 But this wouldn't work, and returns an error

 $sql = SELECT * FROM fldField WHERE IDField =  . $id;


 What could possibly be wrong? If you need more info, then
 tell me. Here's my
 code:

 ?php
  $db = @odbc_connect('ReviewDatabase', 'root', '') or exit)(Error
 occured:br$php_errormsg);
  $sql = SELECT * FROM tblArt WHERE IDArt = $id;
  $cursor = @odbc_exec($db, $sql) or exit (Error
 occrued:br$php_errormsg);
  odbc_close($db);
 ?



 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Variable Appended To The End of a URL Is Not Working in SQL Query

2002-04-01 Thread Dr. Shim 

I have a variable which is appeneded to the end of a URL, like

http://www.your_web_site.com/your_page/?your_variable=your_value

This would return your_value;

echo $your_variable;

But this wouldn't work, and returns an error

$sql = SELECT * FROM fldField WHERE IDField =  . $id;


What could possibly be wrong? If you need more info, then tell me. Here's my
code:

?php
 $db = odbc_connect('ReviewDatabase', 'root', '') or exit)(Error
occured:br$php_errormsg);
 $sql = SELECT * FROM tblArt WHERE IDArt = $id;
 $cursor = odbc_exec($db, $sql) or exit (Error
occrued:br$php_errormsg);
 odbc_close($db);
?



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Variable Appended To The End of a URL Is Not Working in SQL Query

2002-04-01 Thread Jason Murray 

I'd say $id is blank, not being passed in, or is equal to a 
nonexistant IDArt.

Maybe you should echo out your SQL and run it manually to see
what's going on.

J

-- 
Jason Murray
[EMAIL PROTECTED]
Web Developer, Melbourne IT
Work now, freak later!

 -Original Message-
 From: Dr. Shim [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 02, 2002 2:41 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP] Variable Appended To The End of a URL Is Not Working in
 SQL Query
 
 
 I have a variable which is appeneded to the end of a URL, like
 
 http://www.your_web_site.com/your_page/?your_variable=your_value
 
 This would return your_value;
 
 echo $your_variable;
 
 But this wouldn't work, and returns an error
 
 $sql = SELECT * FROM fldField WHERE IDField =  . $id;
 
 
 What could possibly be wrong? If you need more info, then 
 tell me. Here's my
 code:
 
 ?php
  $db = @odbc_connect('ReviewDatabase', 'root', '') or exit)(Error
 occured:br$php_errormsg);
  $sql = SELECT * FROM tblArt WHERE IDArt = $id;
  $cursor = @odbc_exec($db, $sql) or exit (Error
 occrued:br$php_errormsg);
  odbc_close($db);
 ?
 
 
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Variable Appended To The End of a URL Is Not Working in SQL Query

2002-04-01 Thread Dr. Shim 

Hmm, run it manually? I'm a newbie, so, could you explain how I'd do that?
=)

Jason Murray [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I'd say $id is blank, not being passed in, or is equal to a
nonexistant IDArt.

Maybe you should echo out your SQL and run it manually to see
what's going on.

J

--
Jason Murray
[EMAIL PROTECTED]
Web Developer, Melbourne IT
Work now, freak later!

 -Original Message-
 From: Dr. Shim [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 02, 2002 2:41 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP] Variable Appended To The End of a URL Is Not Working in
 SQL Query


 I have a variable which is appeneded to the end of a URL, like

 http://www.your_web_site.com/your_page/?your_variable=your_value

 This would return your_value;

 echo $your_variable;

 But this wouldn't work, and returns an error

 $sql = SELECT * FROM fldField WHERE IDField =  . $id;


 What could possibly be wrong? If you need more info, then
 tell me. Here's my
 code:

 ?php
  $db = @odbc_connect('ReviewDatabase', 'root', '') or exit)(Error
 occured:br$php_errormsg);
  $sql = SELECT * FROM tblArt WHERE IDArt = $id;
  $cursor = @odbc_exec($db, $sql) or exit (Error
 occrued:br$php_errormsg);
  odbc_close($db);
 ?



 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Variable Appended To The End of a URL Is Not Working in SQL Query

2002-04-01 Thread Tyler Longren 

Well, there's not $id variable.  And you're trying to select it.

Should be this:
?php
 $db = @odbc_connect('ReviewDatabase', 'root', '') or exit)(Error
occured:br$php_errormsg);
// next line has changed
 $sql = SELECT * FROM tblArt WHERE IDArt = $your_variable;
 $cursor = @odbc_exec($db, $sql) or exit (Error
occrued:br$php_errormsg);
 odbc_close($db);
?

Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Dr. Shim [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 10:41 PM
Subject: [PHP] Variable Appended To The End of a URL Is Not Working in SQL
Query


 I have a variable which is appeneded to the end of a URL, like

 http://www.your_web_site.com/your_page/?your_variable=your_value

 This would return your_value;

 echo $your_variable;

 But this wouldn't work, and returns an error

 $sql = SELECT * FROM fldField WHERE IDField =  . $id;


 What could possibly be wrong? If you need more info, then tell me. Here's
my
 code:

 ?php
  $db = @odbc_connect('ReviewDatabase', 'root', '') or exit)(Error
 occured:br$php_errormsg);
  $sql = SELECT * FROM tblArt WHERE IDArt = $id;
  $cursor = @odbc_exec($db, $sql) or exit (Error
 occrued:br$php_errormsg);
  odbc_close($db);
 ?



 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Variable Appended To The End of a URL Is Not Working in SQL Query

2002-04-01 Thread Dr. Shim 

The your_variable thing was just an example. It actually uses $id (an a
real URL).

Tyler Longren [EMAIL PROTECTED] wrote in message
003001c1da02$f46e65b0$0101a8c0@nightengale">news:003001c1da02$f46e65b0$0101a8c0@nightengale...
Well, there's not $id variable.  And you're trying to select it.

Should be this:
?php
 $db = @odbc_connect('ReviewDatabase', 'root', '') or exit)(Error
occured:br$php_errormsg);
// next line has changed
 $sql = SELECT * FROM tblArt WHERE IDArt = $your_variable;
 $cursor = @odbc_exec($db, $sql) or exit (Error
occrued:br$php_errormsg);
 odbc_close($db);
?

Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Dr. Shim [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 10:41 PM
Subject: [PHP] Variable Appended To The End of a URL Is Not Working in SQL
Query


 I have a variable which is appeneded to the end of a URL, like

 http://www.your_web_site.com/your_page/?your_variable=your_value

 This would return your_value;

 echo $your_variable;

 But this wouldn't work, and returns an error

 $sql = SELECT * FROM fldField WHERE IDField =  . $id;


 What could possibly be wrong? If you need more info, then tell me. Here's
my
 code:

 ?php
  $db = @odbc_connect('ReviewDatabase', 'root', '') or exit)(Error
 occured:br$php_errormsg);
  $sql = SELECT * FROM tblArt WHERE IDArt = $id;
  $cursor = @odbc_exec($db, $sql) or exit (Error
 occrued:br$php_errormsg);
  odbc_close($db);
 ?



 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php