Passing variable sql php

Expand Post »

Hi,

I have a web site in which I pass many javascript variables to php and the other way round. This is my last passing variable challenge, and I cannot figure it out.

There's an alphabet letter that i pass into showhide1(v) function, and i try to pass it to IN(). For example IN ('b') will retrieve all items beginning with letter b.

The way I did it below does not work for some reason. Does anyone know how to do it?

Thanks

PHP Syntax (Toggle Plain Text)
function showhide1(v)
{
 
<?php
$result = mysql_query("SELECT * FROM birdstable
WHERE left(Name, 1) IN ($_GET[v]) 
ORDER BY Name;"); 
 
while($row = mysql_fetch_assoc($result)){  
$varr= $row['BirdID'];
?>
document.getElementById("Layer1").innerHTML = "hello";
 
<?php
 
}
?>
 
 
}
function showhide1(v)
{

<?php
$result = mysql_query("SELECT * FROM birdstable
WHERE left(Name, 1) IN ($_GET[v]) 
ORDER BY Name;"); 

while($row = mysql_fetch_assoc($result)){  
$varr= $row['BirdID'];
?>
document.getElementById("Layer1").innerHTML = "hello";

<?php

}
?>


}

Last edited by Mylena; Oct 4th, 2008 at 2:53 pm.

Similar Threads

passing an ip address in the url. in PHP
pagination not displaying results in PHP
Passing Variables in PHP
get html element value using php in PHP
Can a text link pass php variables? in PHP

Mylena

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

30 posts
since Jul 2007

Permalink

Oct 6th, 2008

Re: Passing variable sql php

i think you can't get the java script function values by this way: $_GET[v].
if you want to send javascript values to php try this way:

PHP Syntax (Toggle Plain Text)
function showhide1(x)
{
d.action="yourpage.php?v="+x;
d.submit();
}
function showhide1(x)
{
d.action="yourpage.php?v="+x;
d.submit();
}

And the you can get the function value by $_GET['v'];
then pass it to N() ...

Last edited by Shanti C; Oct 6th, 2008 at 4:08 am.

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Please help me with sorting column heading

Next Thread in PHP Forum Timeline: Image upload into directory storing path in database

DaniWeb Message

Cancel Changes

User Name
Password