Monshery Posted June 22, 2006 Share Posted June 22, 2006 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--]<?phpif (($_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. Quote Link to comment Share on other sites More sharing options...
Monshery Posted June 22, 2006 Author Share Posted June 22, 2006 Now its as it sould be :-) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.