combination MySQl and PHP explode result

[rayzun]

I dont understand the code
"else" or "if"

example:
domain.com/index.php/A/
The code below will take the first slash after the index.php
"A"
and return all records in the field "male" that begin with "A"

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

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

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

echo "$male";
##

I dont understand how to use:
"else" or "if"
because what if the URL does not contain a slash
every single record from table "alpha" and field "male"
is returned.
domain.com/index.php

Do these 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%'";

[paulnaj]

Hi rayzun,

I don't think I quite understand you.

If ...

$PATH_INFO = 'domain.com/index.php/A/';

... then this ...

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

... sets $first to 'domain.com', not 'A'.

Best to get this straight before I try and help you.

Paul 🙂

PS. Just to let you know ...

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

... could just be written as ...

$query = "SELECT DISTINCT male
FROM alpha
WHERE male LIKE '$first%'";

... and ...

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

echo "$male";
}

... could be written, more naturally, as ...

$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
echo $row['male'];
}

EDIT: Used mysql_fetch_row ... actually meant mysql_fetch_array

[rayzun]

Hi

Thanks
how do I get a query result into vars or blocks

query ... Limit 0,20 // example

$result = mysql_query($query);
while($row = mysql_fetch_array($result)){

echo $row['male']; // echo $row['male1'] - $row['male2'] - $row['19'];

}