Simple Select question.......pls help

Elliott

the previous HTML page submits a form with the surname and email address on. I was to find the row in the table which is the correct one.

I have this code, but what is wrong, iver never used this query b4.

Also to retrieve details, what method= does my form on the previous post have to be? Get?

mysql_connect (localhost,elliott,password);
mysql_select_db ("quote");
mysql_query (SELECT * FROM main WHERE surname='$_GET[surname]' AND email='$_GET[email]');

stolzyboy

if you use post use this

<?
extract ($_POST);
$query = "select * from main where surname = '$surname' and email = '$email';";
$result = mysql_query($query) or die(mysql_error());
?>

if you use get use this

<?
extract ($_GET);
$query = "select * from main where surname = '$surname' and email = '$email';";
$result = mysql_query($query) or die(mysql_error());
?>

this is just the query part, of course you will still need the mysql and db connections

Elliott

OK thanks, i put that in, and didnt receive any errors but its not producing any output.

On my html further down that page i have $firstname and $mortgage_quote being output. but nothing is appearing.

I know the * retrieves all the columns on the field, but it doesnt seem to be getting anything.

Also if there are no rows found with the matching details how can i direct them to a html page saying no records found.

stolzyboy

<?
if (mysql_num_rows($result) > 0)
{
do whatever 
}
else
{
include 'pagethatsaysnoresults.html';
}
?>

Elliott

OK thanks, nice one.

Still its not displaying the output.

I have <FORM action=retrieval.php method=GET>

Should it be get or Post?

its taking the user input like surname, and finding it from a table.

Then in the retrieval.php it has the above SQL code. and it displays it with the $surname etc

Could u help on that bit, or am i being annoying 🙁

Elliott

This is my code for the whole php file.

<html>
<body>

<?php
mysql_connect (localhost,elliott,password);
mysql_select_db ("quote");
//mysql_query (SELECT * FROM main WHERE surname='$_GET[surname]' AND email='$_GET[email]');
extract ($_POST);
$query = "select * from main where surname = '$surname' and email = '$email';";
$result = mysql_query($query) or die(mysql_error());




echo "<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>
<html>
<head>
<title>APT Finance</title>
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'>

</head>

<body bgcolor='#FFFFFF' text='#000000' leftmargin='0' >
<table width='92%' border='0' cellspacing='0' cellpadding='0'>
  <tr>
    <td width='15%' valign='top'>
      <table width='86%' border='0' cellspacing='0' cellpadding='0'>
        <tr>
          <td valign='top' height='96'><img src='images/aptlogo.gif' width='167' height='101'></td>
        </tr>
        <tr>
          <td height='36'><img src='images/tagline.gif' width='167' height='44'></td>
        </tr>
        <tr>
          <td><img src='images/header_home.gif' width='167' height='38'></td>
        </tr>
        <tr>
          <td><img src='images/leftnav_links.gif' width='168' height='21'></td>
        </tr>
        <tr>
          <td><a href='mortgage.htm' ></a></td>
        </tr>
        <tr>
          <td><a href='re_mortgage.htm' </a></td>
        </tr>
        <tr>
          <td><a href='buytolet.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image38','','images/butn_buytolet-over.gif',1)'><img name='Image38' border='0' src='images/butn_buytolet.gif' width='168' height='18'></a></td>
        </tr>
        <tr>
          <td><a href='loans.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image40','','images/butn_loans-over.gif',1)'><img name='Image40' border='0' src='images/butn_loans.gif' width='168' height='18'></a></td>
        </tr>
        <tr>
          <td height='2'><a href='retrieval.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image41','','images/butn_financial-over.gif',1)'><img name='Image41' border='0' src='images/butn_financial.gif' width='168' height='18'></a></td>
        </tr>
        <tr>
          <td height='2'><img src='images/leftnav_butn-bottom.gif' width='168' height='5'></td>
        </tr>
        <tr>
          <td><img src='images/leftnav_resources-shadow.gif' width='168' height='49'></td>
        </tr>
        <tr>
          <td><a href='businessopp.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image21','','images/butn_jobseeker-over.gif',1)'><img name='Image21' border='0' src='images/butn_jobseeker.gif' width='168' height='12'></a></td>
        </tr>
        <tr>
          <td><a href='#' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image35','','images/butn_members-over.gif',1)'><img name='Image35' border='0' src='images/butn_members.gif' width='168' height='12'></a></td>
        </tr>
        <tr>
          <td height='2'><img src='images/leftnav_resources-bottom.gif' width='168' height='13'></td>
        </tr>
        <tr>
          <td><img src='images/blockfade.jpg' width='168' height='289'></td>
        </tr>
      </table>
    </td>
    <td width='85%' valign='top'>
      <table width='75%' border='0' cellspacing='0' cellpadding='0'>
        <tr>
          <td height='67' valign='bottom'><a href='index.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image7','','images/butn_home-over.gif',1)'><img name='Image7' border='0' src='images/butn_home.gif' width='43' height='35'></a><a href='contact.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image29','','images/butn_contact-over.gif',1)'><img name='Image29' border='0' src='images/butn_contact.gif' width='88' height='35'></a><a href='about.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image30','','images/butn_about-over.gif',1)'><img name='Image30' border='0' src='images/butn_about.gif' width='88' height='35'></a><a href='useful_links.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image28','','images/butn_useful-over.gif',1)'><img name='Image28' border='0' src='images/butn_useful.gif' width='88' height='35'></a><a href='recommend.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image32','','images/butn_recommend-over.gif',1)'><img name='Image32' border='0' src='images/butn_recommend.gif' width='92' height='35'></a><a href='help.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image31','','images/butn_help-over.gif',1)'><img name='Image31' border='0' src='images/butn_help.gif' width='43' height='35'></a><a href='site_map.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image34','','images/butn_sitemap-over.gif',1)'><img name='Image34' border='0' src='images/butn_sitemap.gif' width='88' height='35'></a><a href='terms.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image33','','images/butn_terms-over.gif',1)'><img name='Image33' border='0' src='images/butn_terms.gif' width='62' height='35'></a></td>
        </tr>
        <tr>
          <td><object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' codebase='http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0' width='592' height='115'>
              <param name=movie value='images/banner.swf'>
              <param name=quality value=high>
              <embed src='images/banner.swf' quality=high pluginspage='http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash' type='application/x-shockwave-flash' width='592' height='115'>
              </embed>
            </object></td>
        </tr>
        <tr>
          <td background='images/title_back.gif'>
            <table width='100%' border='0' cellspacing='0' cellpadding='0'>
              <tr>
                <td width='24%'>
                  <table width='100%' border='0' cellspacing='0' cellpadding='0'>
                    <tr>
                      <td width='7%'><img src='images/bullet_arrow-header.gif' width='24' height='27'></td>
                      <td width='93%'><font color='#FFFFFF' size='2' face='Arial, Helvetica, sans-serif'><b><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>YOUR
                        QUOTE </font></b></font></td>
                    </tr>
                  </table>
                </td>
                <td width='15%'>
                  <div align='right'><img src='images/bullet_pagefold-header.gif' width='54' height='27'></div>
                </td>
                <td width='22%'><img src='images/bullet_arrow-header.gif' width='24' height='27'></td>
                <td width='39%'>&nbsp;</td>
              </tr>
            </table>
          </td>
        </tr>
        <tr>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td height='315'>
            <div align='center'>
              <table width='100%' border='0' cellspacing='0' cellpadding='8'>
                <tr>
                  <td><strong><font size='2' face='Arial, Helvetica, sans-serif'>Your
                    Details</font></strong></td>
                  <td><font size='2' face='Arial, Helvetica, sans-serif'>&nbsp;</font></td>
                </tr>
                <tr>
                  <td width='36%'><div align='right'><font size='2' face='Arial, Helvetica, sans-serif'>Welcome back </font></div></td>
                  <td width='64%'><font size='2' face='Arial, Helvetica, sans-serif'>$firstname</font></td>
                </tr>

            <tr>
              <td><font size='2' face='Arial, Helvetica, sans-serif'>&nbsp;</font></td>
              <td><font size='2' face='Arial, Helvetica, sans-serif'>&nbsp;</font></td>
            </tr>
            <tr>
              <td><div align='right'><font color='#6699CC' size='3' face='Arial, Helvetica, sans-serif'><strong>Here
                  Is Your Quote :</strong></font></div></td>
              <td><font size='2' face='Arial, Helvetica, sans-serif'>£ ".number_format($mortgage_quote, 2, '.', '')."</font></td>


            </tr>
            <tr>
              <td><font size='1' face='Arial, Helvetica, sans-serif'>&nbsp;</font></td>
              <td><font size='2' face='Arial, Helvetica, sans-serif'>(maximum
                house value you can purchase)</font></td>
            </tr>
            <tr>
              <td><div align='right'><font size='2' face='Arial, Helvetica, sans-serif'>With
                  a deposit of :</font></div></td>
              <td><font size='2' face='Arial, Helvetica, sans-serif'>£ ".number_format($deposit, 2, '.', '')."</font></td>
            </tr>
            <tr>
              <td>&nbsp;</td>
              <td>&nbsp;</td>
            </tr>
            <tr>
              <td height='54' colspan='2'><div align='left'><font size='1' face='Arial, Helvetica, sans-serif'><strong>From
                  the details you entered we may be able to find you an even
                  better quote. If we can do so, we will contact you via one
                  of the methods you specified on the previous form.<br>
<BR>
                      Please Note this quote is for illustration purposes only, and is reliant upon correct information entered previously.
                        </strong></font></div></td>
                </tr>
              </table>
            </div>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</body>
</html>";

?>
</body>
</html>

stolzyboy

<?php
mysql_connect (localhost,elliott,password);
mysql_select_db ("quote");
//mysql_query (SELECT * FROM main WHERE surname='$_GET[surname]' AND email='$_GET[email]');
extract ($_POST);
$query = "select * from main where surname = '$surname' and email = '$email';";
$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result))
{
$firstname = $row['firstname'];
$mortgage_quote = $row['mortgage_quote'];
}
?>
<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>
<html>
<head>
<title>APT Finance</title>
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'>

</head>

<body bgcolor='#FFFFFF' text='#000000' leftmargin='0' >
<table width='92%' border='0' cellspacing='0' cellpadding='0'>
  <tr>
    <td width='15%' valign='top'>
      <table width='86%' border='0' cellspacing='0' cellpadding='0'>
        <tr>
          <td valign='top' height='96'><img src='images/aptlogo.gif' width='167' height='101'></td>
        </tr>
        <tr>
          <td height='36'><img src='images/tagline.gif' width='167' height='44'></td>
        </tr>
        <tr>
          <td><img src='images/header_home.gif' width='167' height='38'></td>
        </tr>
        <tr>
          <td><img src='images/leftnav_links.gif' width='168' height='21'></td>
        </tr>
        <tr>
          <td><a href='mortgage.htm' ></a></td>
        </tr>
        <tr>
          <td><a href='re_mortgage.htm' </a></td>
        </tr>
        <tr>
          <td><a href='buytolet.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image38','','images/butn_buytolet-over.gif',1)'><img name='Image38' border='0' src='images/butn_buytolet.gif' width='168' height='18'></a></td>
        </tr>
        <tr>
          <td><a href='loans.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image40','','images/butn_loans-over.gif',1)'><img name='Image40' border='0' src='images/butn_loans.gif' width='168' height='18'></a></td>
        </tr>
        <tr>
          <td height='2'><a href='retrieval.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image41','','images/butn_financial-over.gif',1)'><img name='Image41' border='0' src='images/butn_financial.gif' width='168' height='18'></a></td>
        </tr>
        <tr>
          <td height='2'><img src='images/leftnav_butn-bottom.gif' width='168' height='5'></td>
        </tr>
        <tr>
          <td><img src='images/leftnav_resources-shadow.gif' width='168' height='49'></td>
        </tr>
        <tr>
          <td><a href='businessopp.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image21','','images/butn_jobseeker-over.gif',1)'><img name='Image21' border='0' src='images/butn_jobseeker.gif' width='168' height='12'></a></td>
        </tr>
        <tr>
          <td><a href='#' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image35','','images/butn_members-over.gif',1)'><img name='Image35' border='0' src='images/butn_members.gif' width='168' height='12'></a></td>
        </tr>
        <tr>
          <td height='2'><img src='images/leftnav_resources-bottom.gif' width='168' height='13'></td>
        </tr>
        <tr>
          <td><img src='images/blockfade.jpg' width='168' height='289'></td>
        </tr>
      </table>
    </td>
    <td width='85%' valign='top'>
      <table width='75%' border='0' cellspacing='0' cellpadding='0'>
        <tr>
          <td height='67' valign='bottom'><a href='index.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image7','','images/butn_home-over.gif',1)'><img name='Image7' border='0' src='images/butn_home.gif' width='43' height='35'></a><a href='contact.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image29','','images/butn_contact-over.gif',1)'><img name='Image29' border='0' src='images/butn_contact.gif' width='88' height='35'></a><a href='about.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image30','','images/butn_about-over.gif',1)'><img name='Image30' border='0' src='images/butn_about.gif' width='88' height='35'></a><a href='useful_links.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image28','','images/butn_useful-over.gif',1)'><img name='Image28' border='0' src='images/butn_useful.gif' width='88' height='35'></a><a href='recommend.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image32','','images/butn_recommend-over.gif',1)'><img name='Image32' border='0' src='images/butn_recommend.gif' width='92' height='35'></a><a href='help.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image31','','images/butn_help-over.gif',1)'><img name='Image31' border='0' src='images/butn_help.gif' width='43' height='35'></a><a href='site_map.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image34','','images/butn_sitemap-over.gif',1)'><img name='Image34' border='0' src='images/butn_sitemap.gif' width='88' height='35'></a><a href='terms.htm' onMouseOut='MM_swapImgRestore()' onMouseOver='MM_swapImage('Image33','','images/butn_terms-over.gif',1)'><img name='Image33' border='0' src='images/butn_terms.gif' width='62' height='35'></a></td>
        </tr>
        <tr>
          <td><object classid='clsid<img src="images/smilies/biggrin.gif" border="0" alt="">27CDB6E-AE6D-11cf-96B8-444553540000' codebase='http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0' width='592' height='115'>
              <param name=movie value='images/banner.swf'>
              <param name=quality value=high>
              <embed src='images/banner.swf' quality=high pluginspage='http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash' type='application/x-shockwave-flash' width='592' height='115'>
              </embed>
            </object></td>
        </tr>
        <tr>
          <td background='images/title_back.gif'>
            <table width='100%' border='0' cellspacing='0' cellpadding='0'>
              <tr>
                <td width='24%'>
                  <table width='100%' border='0' cellspacing='0' cellpadding='0'>
                    <tr>
                      <td width='7%'><img src='images/bullet_arrow-header.gif' width='24' height='27'></td>
                      <td width='93%'><font color='#FFFFFF' size='2' face='Arial, Helvetica, sans-serif'><b><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>YOUR
                        QUOTE </font></b></font></td>
                    </tr>
                  </table>
                </td>
                <td width='15%'>
                  <div align='right'><img src='images/bullet_pagefold-header.gif' width='54' height='27'></div>
                </td>
                <td width='22%'><img src='images/bullet_arrow-header.gif' width='24' height='27'></td>
                <td width='39%'>&nbsp;</td>
              </tr>
            </table>
          </td>
        </tr>
        <tr>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td height='315'>
            <div align='center'>
              <table width='100%' border='0' cellspacing='0' cellpadding='8'>
                <tr>
                  <td><strong><font size='2' face='Arial, Helvetica, sans-serif'>Your
                    Details</font></strong></td>
                  <td><font size='2' face='Arial, Helvetica, sans-serif'>&nbsp;</font></td>
                </tr>
                <tr>
                  <td width='36%'><div align='right'><font size='2' face='Arial, Helvetica, sans-serif'>Welcome back </font></div></td>
                  <td width='64%'><font size='2' face='Arial, Helvetica, sans-serif'><? echo $firstname; ?></font></td>
                </tr>

            <tr>
              <td><font size='2' face='Arial, Helvetica, sans-serif'>&nbsp;</font></td>
              <td><font size='2' face='Arial, Helvetica, sans-serif'>&nbsp;</font></td>
            </tr>
            <tr>
              <td><div align='right'><font color='#6699CC' size='3' face='Arial, Helvetica, sans-serif'><strong>Here
                  Is Your Quote :</strong></font></div></td>
              <td><font size='2' face='Arial, Helvetica, sans-serif'><? echo "£ " . number_format($mortgage_quote, 2, '.', ''); ?></font></td>


            </tr>
            <tr>
              <td><font size='1' face='Arial, Helvetica, sans-serif'>&nbsp;</font></td>
              <td><font size='2' face='Arial, Helvetica, sans-serif'>(maximum
                house value you can purchase)</font></td>
            </tr>
            <tr>
              <td><div align='right'><font size='2' face='Arial, Helvetica, sans-serif'>With
                  a deposit of :</font></div></td>
              <td><font size='2' face='Arial, Helvetica, sans-serif'><? echo "£ " . number_format($mortgage_quote, 2, '.', ''); ?></font></td>
            </tr>
            <tr>
              <td>&nbsp;</td>
              <td>&nbsp;</td>
            </tr>
            <tr>
              <td height='54' colspan='2'><div align='left'><font size='1' face='Arial, Helvetica, sans-serif'><strong>From
                  the details you entered we may be able to find you an even
                  better quote. If we can do so, we will contact you via one
                  of the methods you specified on the previous form.<br>
<BR>
                      Please Note this quote is for illustration purposes only, and is reliant upon correct information entered previously.
                        </strong></font></div></td>
                </tr>
              </table>
            </div>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</body>
</html>

stolzyboy

if you use method = get, you use the

extract ($_GET);

if you use method = post, you use the

extract ($_POST);

Elliott

Thanks Stolzyboy, i owe you sooooo much.

Youve made this student in England, very happy 😃

Thanks again for ya time.