Jump to content


Photo

Please help short q


  • Please log in to reply
1 reply to this topic

#1 Monshery

Monshery
  • Members
  • PipPipPip
  • Advanced Member
  • 44 posts

Posted 22 June 2006 - 07:28 PM

Well trying to fatch details from SQL to a page but in a table and i get error





[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]<?php
if (($_POST['SAGE'] != 0) && ($_POST['EAGE'] != 0))
if(isset($_POST['GAMEP']))
{
$MMO_LINK=mysql_connect('xxxxxxx','xxxxxxx','xxxxxxx') or die("Connection fail");
mysql_select_db('mmodate',$MMO_LINK);
$MMO_USERD = mysql_query("SELECT MYNAME,MYLASTNAME,GENDER,GENDERWANT,COUNTRY,CITY,GAMEP,PIC,ABOUTME,ABOUTYOU,AGE FROM USERDETAIL WHERE GENDER = '$_POST[GENDER]' && GAMEP = '$_POST[GAMEP]' && GENDERWANT = '$_POST[GENDERWANT]' && COUNTRY = '$_POST[COUNTRY]' && AGE >= '$_POST[SAGE]' && AGE <= '$_POST[EAGE]'",$MMO_LINK);
$MMO_PRINGD = mysql_fetch_array($MMO_USERD);
if(isset($MMO_PRINGD['GAMEP']))
{
[!--coloro:#33FF33--][span style=\"color:#33FF33\"][!--/coloro--]?>
<HTML>
<body>
<table width="460" height="128" border="1">
<tr>
<td height="81"><table width="453" height="103" border="1">
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="446" height="37" border="1">
<tr>
<td><? echo "My name is:" .$MMO_PRINGD['MYNAME'];?></td>
<td><? echo "My famely name is:" .$MMO_PRINGD['MYLASTNAME'];?></td>
<td><? echo "I am a male:" .$MMO_PRINGD['GENDER'];?></td>
<td><? echo "Would like to meet:" .$MMO_PRINGD['GENDERWANT'];?></td>
<td><? echo "I live in:" .$MMO_PRINGD['COUNTRY'];?></td>
<td><? echo "In the city:" .$MMO_PRINGD['CITY'];?></td>
<td><? echo "I play:" .$MMO_PRINGD['GAMEP'];?></td>
</tr>
</table></td>
</tr>
</table>
</body>
<? [!--colorc--][/span][!--/colorc--] [!--coloro:#FF6666--][span style=\"color:#FF6666\"][!--/coloro--]*/ --- without this code and just the red line benife its all working great but when i add this table its screwing all up Why ? */[!--colorc--][/span][!--/colorc--]
}

[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]echo $MMO_PRINGD['MYNAME']. $MMO_PRINGD['MYLASTNAME']. $MMO_PRINGD['GENDER']. $MMO_PRINGD['GENDERWANT']. $MMO_PRINGD['COUNTRY']. $MMO_PRINGD['CITY'] .$MMO_PRINGD['GAMEP'] .$MMO_PRINGD['PIC'] .$MMO_PRINGD['ABOUTME'] .$MMO_PRINGD['ABOUTYOU'] .$MMO_PRINGD['AGE'];[!--colorc--][/span][!--/colorc--]} [!--coloro:#FF6666--][span style=\"color:#FF6666\"][!--/coloro--]*/ this is check to check if i get variable - and i do */[!--colorc--][/span][!--/colorc--]
else echo "You must fill in the details";
else echo "You must choose a age";
?>[/quote]



THnx in advanced.

#2 Monshery

Monshery
  • Members
  • PipPipPip
  • Advanced Member
  • 44 posts

Posted 22 June 2006 - 08:04 PM

Now its as it sould be :-)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users