Mysql query with dynamic php variables

[Bob_PHP_Builder]

Hi i want to be able to search my tables using phpvariables that are created.

These variables need to be changed so i was wondering how i can add php variables to a sql query?

IE

$type_id= mysql_query("select type_id
FROM type
WHERE  !! Think i need php variable here!!!! ");

Or change anyone suggest a good way of doing this?

Thanks in advance

[niroshan]

Hi

You can just use the same technique like you concatinate two strings.

$sql="select type_id FROM type WHERE type_id=".$phpvariable;

$type_id= mysql_query($sql);

Regards,
Niroshan

[Bob_PHP_Builder]

Hmm why do i get Resource id #2 when i echo the variable?

[niroshan]

HI,
Im really sorry I dont undestand what you mean. 😕

Could you please explain me what you really want to do. perhaps some example, so i can really help you.

Thanx,
Regards,
Niroshan

[bogu]

Bob_PHP_Builder wrote:

Hmm why do i get Resource id #2 when i echo the variable?

resource mysql_query ( string query [, resource link_identifier] ) <-- this is from php manual for more details click here.

[Bob_PHP_Builder]

$size=1;


$sql="select type_id FROM type WHERE type_id=".$size; 

$type_id= mysql_query($sql); 

echo type_id;

[niroshan]

Hi,

Now i got your point 🙂 .

mysql_query will only run your query. To display the results you need to use mysql_fetch_array. See below example,

$size=1;
$sql="select type_id FROM type WHERE type_id=".$size;
$type_id= mysql_query($sql);

while($result=mysql_fetch_array($type_id))
{
    echo $result['type_id']."<br/>";

}

Hope this is what you wanted.

Regards,
Niroshan

[Bob_PHP_Builder]

thank you ver much!!!!!

[niroshan]

Your welcome 😃

[Bob_PHP_Builder]

one last problem i am having is adding a ANd to the where clause

this doesn't seem to work? is this the correct way?
$type=1;
$size=1;
$sql="select type_id FROM type WHERE type_id=".$type
"AND size=".$size ;
$type_id= mysql_query($sql);

while($result=mysql_fetch_array($type_id))
{
echo $result['type_id']."<br/>";

}

[niroshan]

Hi,
Soory for getting late to reply.. went out a bit 😃

$type=1;
$size=1;
$sql="select type_id FROM type WHERE type_id=".$type." AND size=".$size ;
$type_id= mysql_query($sql);

while($result=mysql_fetch_array($type_id))
{
echo $result['type_id']."<br/>";

}

YOu have missed the dot(.) after $type

Regards,
Niroshan

[Bob_PHP_Builder]

when i add the dot i get Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource ?

[niroshan]

Can you post me u r coding please.. im just going out now will look at it within 1/2 hour ok.. 😃

[Bob_PHP_Builder]

$type=1; 
$size=1; 
$extra=1;
$sql="select type_id FROM type WHERE type_id=".$type." AND size=".$size. "AND size=".$size ; 
$type_id= mysql_query($sql); 

while($result=mysql_fetch_array($type_id)) 
{ 
echo $result['type_id']."<br/>"; 

} 

[Bob_PHP_Builder]

$type=1; 
$size=1; 
$extra=1;
$sql="select type_id FROM type WHERE type_id=".$type." AND size=".$size. "AND extra=".$extra ; 
$type_id= mysql_query($sql); 

while($result=mysql_fetch_array($type_id)) 
{ 
echo $result['type_id']."<br/>"; 

} 

[niroshan]

HI!

got the error.

you have not put an space after $size with 'AND'.

use this,

$sql="select type_id FROM type WHERE type_id=".$type." AND size=".$size. " AND extra=".$extra ; 

Regards,
Niroshan