PHP / MySQL

foreverb

Hi,

Im trying to write some php code that allows visitors to search a mysql database.

I think ive done this successfully, however sometimes the page will not load properly, ie there appears to be errors. Its always after the php code that errors seem to occur.

Does anybody know what I mean? Is it a problem with the php code or html or a mixture of both?

Thanks 🙂

Merve

Post your code and we'll be happy to help.

foreverb

Heres the main bit. I'm basically trying to display a table of results for a football (soccer) team. It actually does work (amazingly) but the rest of the page after this point doesnt load correctly. Any advice would be greatly appreciated!

<table width="90%" border="0" cellspacing="0" cellpadding="1" align="center">
<tr>
<td colspan="3" class="newsitemtop" bgcolor="#0033cc"><center>Search Results</center></td>
</tr>
<tr>
<td class="newsitemtop" bgcolor="#000033"><center>Oppositon</td>
<td class="newsitemtop" bgcolor="#000033"><center>Venue</td>
<td class="newsitemtop" bgcolor="#000033"><center>Competition</td>
</tr>
<tr>
<td class="newsitem" bgcolor="#000033"><center> <? echo "$input1"; ?> </td>
<td class="newsitem" bgcolor="#000033"><center><? echo "$input2"; ?></td>
<td class="newsitem" bgcolor="#000033"><center><? echo "$input3"; ?> </td>
</tr>

</table>

<?
$i=0;
while ($i < $num) {

$date=mysql_result($result,$i,"Date");
$oppo=mysql_result($result,$i,"Oppo");
$comp=mysql_result($result,$i,"Comp");
$venue=mysql_result($result,$i,"Venue");
$color=mysql_result($result,$i,"BGColor");
$outcome=mysql_result($result,$i,"Result");
$scorers=mysql_result($result,$i,"Scorers");

<tr>

<?
++$i;
}
?>

</table>

Merve

Post the rest of the page after that point. I don't see anything wrong with your code yet.

foreverb

Thanks for taking a look 🙂

The problem is that there is very little after that, just basically closing off some other tables.

If i remove the above code from the page, the page loads fine. It seems to be just when the above code is entered that the page fails to load correctly.

The page is really very simple apart from the PHP code. I was hoping you would tell me there was something wrong with the code 🙁

tekky

endless loop... you dont have anything assigning a value to $num that I see.....

foreverb

sorry i didnt add that bit in.

$i is assigned to 0. and is incremented each loop until it reaches the number of rows in the Array.

foreverb

and $num is the number of rows in the array

tekky

you can "edit" your posts 😉

and where is $result set?

have you tried adding any debug echo's to see whats being done?

foreverb

OK here' the rest of the code above the stuff i posted earlier.

The actual searching and displaying works perfectly.

Having tried some debug echos it appears that nothing further happens after the the table which displays the results terminates.

Ive checked the HTML code around the PHP and it seems fine

$input1=$opposition; -- Name of team
$input2=$venue; -- Where match was played
$input3=$competition; -- Competition match was played in

if ($input2=='Any Venue' && $input3!='Any Competition') {
$query="SELECT * FROM Results WHERE Opposition='$input1' AND Competition='$input3'"; }

if ($input2!='Any Venue' && $input3=='Any Competition') {
$query="SELECT * FROM Results WHERE Opposition='$input1' AND Venue='$input2'";}

if ($input2=='Any Venue' && $input3=='Any Competition') {
$query="SELECT * FROM Results WHERE Opposition='$input1'"; }

if ($input2!='Any Venue' && $input3!='Any Competition') {
$query="SELECT * FROM Results WHERE Opposition='$input1' AND Venue='$input2' AND Competition='$input3'";}

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>