HELP MySQL

[tagaroe]

Please can somebody explain to me how do i tell a database who has 1 table
and various fields to" accept" nr1 and nr2" take and lock "information from a register.php with a click on a buttom >

Thx in advance.

[e-mail]

PHP IIS MySQL

[ronverdonk]

I don't have a clue what you are asking. Can you explain that in plain language?

Ronald :cool:

[tagaroe]

Please can somebody explain to me how do i tell a database who has 1 table
and various fields to" accept" nr1 and nr2" take and lock "information from a register.php with a click on a buttom >

Thx in advance.

[e-mail]

PHP IIS MySQL

Mr. Ronald , i am busy making a single regestration.php webpage.
I am using MySQL database with 1 table en several fields,
now i would like to now how do i collect de information from the webpage
in 1 time with a click buttom on the webpage.
The webpage is not on the site yet, since i still working on it.
Should you be interested, feel free to visit http://www.business-youthlink.co.za .
Hopefully i did explain it better this thime, if not i shall trail again.

THX

[ronverdonk]

Look at thre sample I posted on logging in a user in the HTML/CSS forum at http://www.thescripts.com/forum/post2216963-8.html

That shows you how to enter data in a form and process it when the submit is clicked.

If you have any more questions, don't hesitate to ask.

Ronald :cool:

[tagaroe]

Thanks Mr. Ronald for the php
I assume that i can put more fields than only username and password,
I must make the page now, if i do have a problem i let you now.

thx again for your help

[e-mail]

http://www.business-youthlink.co.za

[ronverdonk]

You can put as many columns in as you like, it's just a sample on how to collect info from the screen and process it using the MySQL database, nothing else.

Ronald :cool:

[tagaroe]

Hello mr.ronald ,its me again, lieven
I did look at the page that you give the shortcut from,
i did put the not fully finished page on the net.
Wanted to ask you to have a look at it.
The database is find on my pc, i am using dreamweaver and for testing purpose
only in from the first table i use name, trading as and CC.
http://www.business-youthlink.co.za/register.php
I changed this from origanale register.html ,just to keep the page equal to all
the pages.
Mr Ronald, allow me to go back now to my 1,2 question.
One other thing mr. ,is het normal that the php from within dreamweaver
together with the recordsets comes before the html. i don t now maybe i am not
explaining this to well.
Allow me to put the whole page on this message, maybe this would be better.
I still have a lot to learn .



-----------------------------------------

   <?php require_once('Connections/nafcocyouth.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset1 = "SELECT companyprofile.name FROM companyprofile";
$Recordset1 = mysql_query($query_Recordset1, $nafcocyouth) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
 
mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset2 = "SELECT companyprofile.tradingas FROM companyprofile";
$Recordset2 = mysql_query($query_Recordset2, $nafcocyouth) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
 
mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset3 = "SELECT companyprofile.CC FROM companyprofile";
$Recordset3 = mysql_query($query_Recordset3, $nafcocyouth) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 //EN">
<HTML>
 
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-etc etc etc etc etc
 
etc etc etc etc etc
 
 
 
 
            <TD><IMG SRC="images/space.gif" WIDTH="43" HEIGHT="1"></TD>
            <TD><IMG SRC="images/space.gif" WIDTH="96" HEIGHT="1"></TD>
        </TR>
</TABLE>
        <script language="javascript1.2" src="menu.js"></script>
</BODY>
 
</HTML>
<?php
mysql_free_result($Recordset1);
 
mysql_free_result($Recordset2);
 
mysql_free_result($Recordset3);
?>
 

-----------------------------------------------------------------

Sir like i mentioned, only three recordsets i put insite.

-How do i bring this details to the database with entering or with a maybe(submit) buttom.

-How do i make sure that all details are put before it can be submitted?

-Is it normal and allowed that php falls above and under the HTML heading and footer or must i maybe change the html detals to ?xhtml? or what do you think
is required?

If you could help me sir i would be verry thankfull, if you do have a website you
always could forward me with a link.

my email is [e-mail]

thanks in advance