[SOLVED] & '*' ?

[simon551]

is there a mySql equivalent to the ms & '*' used in a query? I would use this to have a variable where if there is a condition then the variable would be either a  number like 1 or 'all'

[Yesideez]

Can you give an example SQL query?

[simon551]

SELECT tblActivities.ActivityID, tblActivities.Activity
FROM tblActivities
WHERE (((tblActivities.ActivityID) Like (33) & '*'));

[davidz]

Not quite sure what the goal is here.  Are you trying to say to show results where ActivityID is 33 and if there are no results to show everything?

 

Side note: '*' is a wildcard is microsoft, in mySQL '%' means the same

[simon551]

that's how I have used it in ms access. I'm trying to do something like this, though, actually:

if ($myRole='admin') { 
$act=%;
} else
$act=33;
}

[fenway]

that's how I have used it in ms access. I'm trying to do something like this, though, actually:

if ($myRole='admin') { 
$act=%;
} else
$act=33;
}

 

Huh?

[simon551]

That seems to be working. Am I crazy for doing it this way?

 

if ($myRole='admin') { 
$act=%;
} else {
$act=33;
}

 

query:

SELECT tblActivities.ActivityID, tblActivities.Activity
FROM tblActivities
WHERE (((tblActivities.ActivityID) Like '$act'));

 

[Illusion]

it should be if($myRole=='admin')

ur code always sets $act='%'

[fenway]

it should be if($myRole=='admin')

ur code always sets $act='%'

That will match everything... why not just drop the where clause.

[Illusion]

I didn't really bother about what $act variable contain , I just said that if condition is wrong.Yeah I know '%' returns all the records , may be that is what he want.