[Resolved] "else" or "if"

[rayzun]

Do parameters "else" or "if" allow a default query??

example:

list($first) = explode('/', substr($PATH_INFO,1));
$query = "SELECT DISTINCT male
FROM alpha
WHERE 1
AND male LIKE '$first%';

else if no '$first%';

$query = SELECT DISTINCT male
FROM alpha
WHERE 1
AND male LIKE 'a%';

[LordShryku]

Well, that sudo-code doesn't make much sense, but I'll guess you're saying if $first is not set? In which case you'd want to do the if statement before the query and just an else to the second query.

As far as the default on conditionals, else is the default. If all else fails, do this...

[rayzun]

Please, could someone post an example.

[LordShryku]

if(isset($first)) {
   // execute first query
}
else {
   // execute second query
}

😕

[rayzun]

Is this close???

list($first) = explode('/', substr($PATH_INFO,1));

if(isset($first)) {
$query = "SELECT DISTINCT male
FROM model
WHERE 1
AND male LIKE '$first%'";

}
else {

$query = "SELECT DISTINCT male
FROM model
WHERE 1
AND male LIKE 'a%'";
}

$result = mysql_query($query);
$number = mysql_numrows($result);
{
for ($i=0; $i<$number; $i++) {
$male=mysql_result($result,$i,"male");

echo "$male";
}}

[dalecosp]

[man]if[/man], [man]elseif[/man], and [man]else[/man] are control structures; in some languages these are called conditionals. If takes an boolean expression as its one (and only one) argument. If it evaluates true, then the conditional statements that follow are executed.

Now, likely that's not news to you? Your question is a tad tricky, because of the way it's phrased.

Let's assume MySQL? The point seems to be that if $first exists, you want to call that in the query?

if ($first) {
   $query = "SELECT DISTINCT `male` FROM `alpha` WHERE 1 AND `male` LIKE '$first%'";
} else {
   $query = "SELECT DISTINCT `male` FROM `alpha` WHERE 1 AND `male` LIKE 'a%'";
}

However, if the point is to change the query based on whether or not the first query returns a result (with MySQL), then the boolean value of [man]mysql_query/man can be tested:

   $query = "SELECT DISTINCT `male` FROM `alpha` WHERE 1 AND `male` LIKE '$first%'";
$good_query=mysql_query($query);
if (!$good_query) {
   $query = "SELECT DISTINCT `male` FROM `alpha` WHERE 1 AND `male` LIKE 'a%'";
}

Of course, that's performing one query already --- if your goal was to only query once, we've defeated it.

And then, the last possibility: I've not been able to figure out your question at all, or there are mitigating circumstances; either way, sorry I can't help in that case...

HTH,

[dalecosp]

Originally posted by rayzun
Is this close???

Yes, I'd say so.

LordS, you must type darn fast. I could've sworn there were no responses when I hit "reply"... so I'm responding to post one, but way out of sync. Looks like no more of an idiot than usual, though. Ah, well; getting broadband next week here 😃

[rayzun]

the combination of both replies by dalecosp, and LordShryku have been much help.
Thankyou