Monshery Posted June 24, 2006 Share Posted June 24, 2006 i am tring to load data to a table after i load it from mysql:Code:[code]<?phpif (($_POST['SAGE'] != 0) && ($_POST['EAGE'] != 0))if(isset($_POST['GAMEP'])){$MMO_LINK=mysql_connect('localhost','Monshery','m7625zsw') 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']))?><html><body><table width="457" height="120" border="1"> <tr> <td height="82"><table width="489" height="117" border="1"> <tr> <td><img src="Pics/Eve-Online/Login_r1_c1.jpg" width="154" height="113"></td> <td>About me:<? echo $MMO_PRINGD['ABOUTME'];?></td> <td>About her:<? echo $MMO_PRINGD['ABOUTYOU'];?></td> </tr> </table></td> </tr> <tr> <td height="30"><table width="495" border="1"> <tr> <td>my name: <? echo $MMO_PRINGD['MYNAME'];?></td> <td>Last name: <? echo $MMO_PRINGD['MYLASTNAME']; ?></td> <td>age: <? echo $MMO_PRINGD['AGE']; ?></td> <td>country:<? echo $MMO_PRINGD['COUNTRY'];?></td> <td>city:<? echo $MMO_PRINGD['CITY'];?></td> <td>Game i play:<? echo $MMO_PRINGD['GAMEP'];?></td> <td>i am a:echo <? $MMO_PRINGD['GENDER'];?></td> </tr> </table></td> </tr> </table> </BODY> </HTML><?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'];}else echo "You must fill in the details";else echo "You must choose a age";?>[/code]I get this error after i try to run it .Parse error: syntax error, unexpected $end in C:\wamp\www\Yanivs\MMO-Date\FOUND.PHP on line 482Thanks in advanced and sorry for the long text - any help will be appriciated. Quote Link to comment Share on other sites More sharing options...
hackerkts Posted June 24, 2006 Share Posted June 24, 2006 Hmm.. What's few lines before line 482 and after.I think you short of [b];[/b] Quote Link to comment Share on other sites More sharing options...
Monshery Posted June 24, 2006 Author Share Posted June 24, 2006 But everything after this code is a HTML - how comes i need to use ; on HTML code ?this is exacly whats comes after that code.[code] <td width="145"> </td> </tr> <tr> <td height="18" colspan="3"> </td> </tr> </table> <p><FONT face="Verdana, Arial, Helvetica, sans-serif">©2006MMO-Date Webmaster and web-creator, All rights reserved for comments<A href="mailto:enigman1@012.net.il">(click )</A></FONT></p> </DIV></TD> </TR></TBODY></TABLE></BODY></HTML>[/code] Quote Link to comment Share on other sites More sharing options...
hackerkts Posted June 24, 2006 Share Posted June 24, 2006 [code]if(isset($MMO_PRINGD['GAMEP']))[/code]Hmm.. I'm not really sure about your code, but I think you short of [b]{[/b][code]if(isset($MMO_PRINGD['GAMEP'])) {[/code]And I think there's some problem with[code]else echo "You must fill in the details";else echo "You must choose a age";[/code]Maybe it should be[code]else {echo "You must fill in the details";echo "You must choose a age";}[/code] Quote Link to comment Share on other sites More sharing options...
redarrow Posted June 24, 2006 Share Posted June 24, 2006 You missed a echo statement ok.corrected code[code]<html><body><table width="457" height="120" border="1"> <tr> <td height="82"><table width="489" height="117" border="1"> <tr> <td><img src="Pics/Eve-Online/Login_r1_c1.jpg" width="154" height="113"></td> <td>About me:<? echo $MMO_PRINGD['ABOUTME'];?></td> <td>About her:<? echo $MMO_PRINGD['ABOUTYOU'];?></td> </tr> </table></td> </tr> <tr> <td height="30"><table width="495" border="1"> <tr> <td>my name: <? echo $MMO_PRINGD['MYNAME'];?></td> <td>Last name: <? echo $MMO_PRINGD['MYLASTNAME']; ?></td> <td>age: <? echo $MMO_PRINGD['AGE']; ?></td> <td>country:<? echo $MMO_PRINGD['COUNTRY'];?></td> <td>city:<? echo $MMO_PRINGD['CITY'];?></td> <td>Game i play:<? echo $MMO_PRINGD['GAMEP'];?></td> <td>i am a:<? echo $MMO_PRINGD['GENDER'];?></td> </tr> </table></td> </tr> </table> </BODY> </HTML>[/code] Quote Link to comment Share on other sites More sharing options...
Monshery Posted June 24, 2006 Author Share Posted June 24, 2006 Look:[code]if (($_POST['SAGE'] != 0) && ($_POST['EAGE'] != 0)) /* if this works it will go to next if*/if(isset($_POST['GAMEP']))/* if this next if works it will execute the whole code */{ /* i have this '{' mark as you see and its close after the second part of the php code open */[/code]Second code [code]<?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'];/* all this is just a check for my self to see if i actualy pulling date from SQL without a problem and - no problem (without the table) */} /* this mark end the block as before */else echo "You must fill in the details";/* this one will run if first if wont work.*/else echo "You must choose a age";/* this will work if second if wont work.*/?>[/code] Quote Link to comment Share on other sites More sharing options...
redarrow Posted June 24, 2006 Share Posted June 24, 2006 <?phpif (($_POST['SAGE'] != 0) && ($_POST['EAGE'] != 0)) {if(isset($_POST['GAMEP'])) {$MMO_LINK=mysql_connect('localhost','Monshery','m7625zsw') 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']))?><html><body><table width="457" height="120" border="1"> <tr> <td height="82"><table width="489" height="117" border="1"> <tr> <td><img src="Pics/Eve-Online/Login_r1_c1.jpg" width="154" height="113"></td> <td>About me:<? echo $MMO_PRINGD['ABOUTME'];?></td> <td>About her:<? echo $MMO_PRINGD['ABOUTYOU'];?></td> </tr> </table></td> </tr> <tr> <td height="30"><table width="495" border="1"> <tr> <td>my name: <? echo $MMO_PRINGD['MYNAME'];?></td> <td>Last name: <? echo $MMO_PRINGD['MYLASTNAME']; ?></td> <td>age: <? echo $MMO_PRINGD['AGE']; ?></td> <td>country:<? echo $MMO_PRINGD['COUNTRY'];?></td> <td>city:<? echo $MMO_PRINGD['CITY'];?></td> <td>Game i play:<? echo $MMO_PRINGD['GAMEP'];?></td> <td>i am a:<?echo $MMO_PRINGD['GENDER'];?></td> </tr> </table></td> </tr> </table> </BODY> </HTML><?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']; }}else{if($AGE=="none") {echo "You must choose an age"; }?> Quote Link to comment Share on other sites More sharing options...
Monshery Posted June 24, 2006 Author Share Posted June 24, 2006 Same error - just tried you added {/} the problem wasnt with those marks its was something else.If i completly remove the table - everything works the second i add the table its all screw up . E.G:[code]<?phpif (($_POST['SAGE'] != 0) && ($_POST['EAGE'] != 0))if(isset($_POST['GAMEP'])){$MMO_LINK=mysql_connect('localhost','Monshery','m7625zsw') 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']))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'];}else echo "You must fill in the details";else echo "You must choose a age";?>[/code]This code work just fine - it echoing all the variable i asked.But when i try to echo the variable into table it gives me this error.this is code when i try to echo into table:[code] <?phpif (($_POST['SAGE'] != 0) && ($_POST['EAGE'] != 0))if(isset($_POST['GAMEP'])){$MMO_LINK=mysql_connect('localhost','Monshery','m7625zsw') 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']))?><html><body><table width="457" height="120" border="1"> <tr> <td height="82"><table width="489" height="117" border="1"> <tr> <td><img src="Pics/Eve-Online/Login_r1_c1.jpg" width="154" height="113"></td> <td>About me:<? echo $MMO_PRINGD['ABOUTME'];?></td> <td>About her:<? echo $MMO_PRINGD['ABOUTYOU'];?></td> </tr> </table></td> </tr> <tr> <td height="30"><table width="495" border="1"> <tr> <td height="60">my name: <? echo $MMO_PRINGD['MYNAME'];?></td> <td>Last name: <? echo $MMO_PRINGD['MYLASTNAME']; ?></td> <td>age: <? echo $MMO_PRINGD['AGE']; ?></td> <td>country:<? echo $MMO_PRINGD['COUNTRY'];?></td> <td>city:<? echo $MMO_PRINGD['CITY'];?></td> <td>Game i play:<? echo $MMO_PRINGD['GAMEP'];?></td> <td>i am a:echo <? $MMO_PRINGD['GENDER'];?></td> </tr> </table></td> </tr> </table> </BODY> </HTML><?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'];}else echo "You must fill in the details";else echo "You must choose a age";?>[/code]thanks. for your help. Quote Link to comment Share on other sites More sharing options...
redarrow Posted June 24, 2006 Share Posted June 24, 2006 Your select statement is wrong, why use post with only viewing ok.$query="select * from xxxx where xxxxx ='xxxxxx' "; Quote Link to comment Share on other sites More sharing options...
Monshery Posted June 24, 2006 Author Share Posted June 24, 2006 you mean to change it to get ? Quote Link to comment Share on other sites More sharing options...
redarrow Posted June 24, 2006 Share Posted June 24, 2006 [!--sizeo:5--][span style=\"font-size:18pt;line-height:100%\"][!--/sizeo--]try this way ok fully tested ok.[!--sizec--][/span][!--/sizec--][code]<?php$MMO_LINK=mysql_connect('localhost','Monshery','m7625zsw') or die("Connection fail");mysql_select_db('mmodate',$MMO_LINK);$MMO_USERD = "select * FROM USERDETAIL WHERE GENDER = '$GENDER' && GAMEP = '$GAMEP' && GENDERWANT = '$GENDERWANT' && COUNTRY = '$COUNTRY' && AGE >= '$SAGE' && AGE <= '$EAGE' ";$result=mysql_query($MMO_USERD);while($MMO_PRINGD=mysql_fetch_assoc($result)) {?><html><body><table width="457" height="120" border="1"><tr><td height="82"><table width="489" height="117" border="1"><tr><td><img src="Pics/Eve-Online/Login_r1_c1.jpg" width="154" height="113"></td><td>About me:<? echo $MMO_PRINGD['ABOUTME'];?></td><td>About her:<? echo $MMO_PRINGD['ABOUTYOU'];?></td></tr></table></td></tr><tr><td height="30"><table width="495" border="1"><tr><td>my name: <? echo $MMO_PRINGD['MYNAME'];?></td><td>Last name: <? echo $MMO_PRINGD['MYLASTNAME']; ?></td><td>age: <? echo $MMO_PRINGD['AGE']; ?></td><td>country:<? echo $MMO_PRINGD['COUNTRY'];?></td><td>city:<? echo $MMO_PRINGD['CITY'];?></td><td>Game i play:<? echo $MMO_PRINGD['GAMEP'];?></td><td>i am a:<?echo $MMO_PRINGD['GENDER'];?></td></tr></table></td></tr></table></BODY></HTML><?}}?>[/code][!--sizeo:5--][span style=\"font-size:18pt;line-height:100%\"][!--/sizeo--]this will show all data in the database ok.[!--sizec--][/span][!--/sizec--] Quote Link to comment Share on other sites More sharing options...
Monshery Posted June 24, 2006 Author Share Posted June 24, 2006 Same error mate but thanks for tring to help i will just try to learn the whole PHP 5 book i have before trying to make something.Thnx all for tring to help me. Quote Link to comment Share on other sites More sharing options...
redarrow Posted June 24, 2006 Share Posted June 24, 2006 How can this be wrong and not show the data lol[code]<?php$MMO_LINK=mysql_connect('localhost','Monshery','m7625zsw') or die("Connection fail");mysql_select_db("mmodate",$MMO_LINK);$MMO_USERD = "select * FROM USERDETAIL WHERE GENDER = '$GENDER' && GAMEP = '$GAMEP' && GENDERWANT = '$GENDERWANT' && COUNTRY = '$COUNTRY' && AGE >= '$SAGE' && AGE <= '$EAGE' ";$result=mysql_query($MMO_USERD);while($MMO_PRINGD=mysql_fetch_assoc($result)) {?><html><body><table width="457" height="120" border="1"><tr><td height="82"><table width="489" height="117" border="1"><tr><td><img src="Pics/Eve-Online/Login_r1_c1.jpg" width="154" height="113"></td><td>About me:<? echo $MMO_PRINGD['ABOUTME'];?></td><td>About her:<? echo $MMO_PRINGD['ABOUTYOU'];?></td></tr></table></td></tr><tr><td height="30"><table width="495" border="1"><tr><td>my name: <? echo $MMO_PRINGD['MYNAME'];?></td><td>Last name: <? echo $MMO_PRINGD['MYLASTNAME']; ?></td><td>age: <? echo $MMO_PRINGD['AGE']; ?></td><td>country:<? echo $MMO_PRINGD['COUNTRY'];?></td><td>city:<? echo $MMO_PRINGD['CITY'];?></td><td>Game i play:<? echo $MMO_PRINGD['GAMEP'];?></td><td>i am a:<?echo $MMO_PRINGD['GENDER'];?></td></tr></table></td></tr></table></BODY></HTML><?}?>[/code] Quote Link to comment Share on other sites More sharing options...
Monshery Posted June 24, 2006 Author Share Posted June 24, 2006 i'm combining between dreamweever and php i just typed in the script window the php code and i get this error so i dont know what to tell you but i will read some more and i will succeed 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.