Home > Archive > PHP SQL > March 2005 > problem with value
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
problem with value
|
|
| Irlan agous 2005-03-28, 3:57 pm |
|
The problem is like this, There are a number of $rows resulting from the
query described below. There is a variable named payment, this has for
example the vualue 2. lets say the query had 5 results, the i want to do a
compare that it shows only 2, depending on the value of $payment
Can someone help me?
$query = "SELECT a.oproep,b.oproep, a.react, b.react, a.logid, b.logid,
a.persid,b.persid, a.logemail, b.logemail,a.persemail,b.persemail
FROM reactie a, reactie b
WHERE a.logid = b.persid AND b.logid = a.persid AND a.logid='$logid' ";
$result = mysql_query($query);
$query_data = mysql_fetch_row($result);// Haal de gegevens uit de tabel
if($result = mysql_query($query)){
$rows = mysql_num_rows($result);
if($rows<1){
echo "<p>You have no Matches";
} else {
echo "<p>You have $rows Match(es)<p><p>";
}}
while($query_data = mysql_fetch_array($result)){
$oproep = $query_data["oproep"];
$persid = $query_data["logid"];
$reactie = $query_data["react"];
$logemail = $query_data["logemail"];
echo " <tr>\n";
echo " <td align=center bgcolor=FFECC4 ><font
color=black><a
href=\"java script:Pop550Picture('../pic/klanten/gegevens.php?id=$persid')\"><p>$oproep</a></td>\n";//
echo " <td align=center bgcolor=FFECC4 ><font
color=black><p>".$reactie."</td>\n";
echo " <td align=center bgcolor=FFECC4 ><font
color=black><p>".$reactie."</td>\n";
echo " <td align=center bgcolor=FFECC4 ><font
color=black><p><a href=\"mailto:".$logemail."\">".$logemail."</a></td>\n";
echo " </tr>\n";//
}
| |
| J.O. Aho 2005-03-28, 3:57 pm |
| Irlan agous wrote:
> The problem is like this, There are a number of $rows resulting from the
> query described below. There is a variable named payment, this has for
> example the vualue 2. lets say the query had 5 results, the i want to do a
> compare that it shows only 2, depending on the value of $payment
not sure I follwo what you mean,
If you want results where the column a.payment is 2, then add that to your query
> $query = "SELECT a.oproep,b.oproep, a.react, b.react, a.logid, b.logid,
> a.persid,b.persid, a.logemail, b.logemail,a.persemail,b.persemail
>
> FROM reactie a, reactie b
> WHERE a.logid = b.persid AND b.logid = a.persid AND a.logid='$logid' AND a.payment=2";
If you just want the two first results from the database, then use
> $query = "SELECT a.oproep,b.oproep, a.react, b.react, a.logid, b.logid,
> a.persid,b.persid, a.logemail, b.logemail,a.persemail,b.persemail
>
> FROM reactie a, reactie b
> WHERE a.logid = b.persid AND b.logid = a.persid AND a.logid='$logid' LIMIT 2";
If you want only those results where a.payment is 2 and only show the two
frist, then use
> $query = "SELECT a.oproep,b.oproep, a.react, b.react, a.logid, b.logid,
> a.persid,b.persid, a.logemail, b.logemail,a.persemail,b.persemail
>
> FROM reactie a, reactie b
> WHERE a.logid = b.persid AND b.logid = a.persid AND a.logid='$logid' AND
a.payment=2 LIMIT 2";
If you want something else, then please try to describe your problem differently.
//Aho
|
|
|
|
|