HELP MySQL

[tagaroe]

HI,
Could somebody maybe have a look at http://www.business-youthlink.co.za/register.php .
I am using dreamweaver with iis php and mysql, the database we made is devided now in 3 tables.
Dreamweaver can see the database and for testing purpose i only put 3 recordsets.
I would like to now (since nothing shows if i put name etc) how dus it work
MySQL, how do i after putting the infornation bring it to the database and how
can it be saved their without been readeble by the public.
I dont now if this can be understood.
Is it posseble to put a submitbuttom on the page to transfer details in 1 time to data base and how to do this.
I am new in this .
[e-mail]

i welcome all help
thanks in advance

[scriptee]

HI,
Could somebody maybe have a look at http://www.business-youthlink.co.za/register.php .
I am using dreamweaver with iis php and mysql, the database we made is devided now in 3 tables.
Dreamweaver can see the database and for testing purpose i only put 3 recordsets.
I would like to now (since nothing shows if i put name etc) how dus it work
MySQL, how do i after putting the infornation bring it to the database and how
can it be saved their without been readeble by the public.
I dont now if this can be understood.
Is it posseble to put a submitbuttom on the page to transfer details in 1 time to data base and how to do this.
I am new in this .
[e-mail]

i welcome all help
thanks in advance

Hi !
The link you sent has a Mysql connection issue . You are trying to connect to your local server . If you are trying to see the data from your local database from a remote server it wont work. Take a look into it .
If you can elaborate a bit more what you want to achieve, will help in solving the issue.
Thanks

[tagaroe]

hello sriptee,

I do see the database local in dreamweaver, i am able to select recordsets.
This is how far i can go.
I would like to put a submitbuttom on the page who brings all details in ones to the database.
I dont think theirs a problem , the only thing is that i think.
Do i need to put variables? If so how?
If you want i can send to you the whole page, if you can tell me how.
Or maybe let me try to put the php code from the page under.

(code)

<?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);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset4 = "SELECT companyprofile.govtdept FROM companyprofile";
$Recordset4 = mysql_query($query_Recordset4, $nafcocyouth) or die(mysql_error());
$row_Recordset4 = mysql_fetch_assoc($Recordset4);
$totalRows_Recordset4 = mysql_num_rows($Recordset4);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset5 = "SELECT companyprofile.ngo FROM companyprofile";
$Recordset5 = mysql_query($query_Recordset5, $nafcocyouth) or die(mysql_error());
$row_Recordset5 = mysql_fetch_assoc($Recordset5);
$totalRows_Recordset5 = mysql_num_rows($Recordset5);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset6 = "SELECT companyprofile.publicco FROM companyprofile";
$Recordset6 = mysql_query($query_Recordset6, $nafcocyouth) or die(mysql_error());
$row_Recordset6 = mysql_fetch_assoc($Recordset6);
$totalRows_Recordset6 = mysql_num_rows($Recordset6);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset7 = "SELECT companyprofile.section21 FROM companyprofile";
$Recordset7 = mysql_query($query_Recordset7, $nafcocyouth) or die(mysql_error());
$row_Recordset7 = mysql_fetch_assoc($Recordset7);
$totalRows_Recordset7 = mysql_num_rows($Recordset7);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset8 = "SELECT companyprofile.section21 FROM companyprofile";
$Recordset8 = mysql_query($query_Recordset8, $nafcocyouth) or die(mysql_error());
$row_Recordset8 = mysql_fetch_assoc($Recordset8);
$totalRows_Recordset8 = mysql_num_rows($Recordset8);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset9 = "SELECT companyprofile.soleowner FROM companyprofile";
$Recordset9 = mysql_query($query_Recordset9, $nafcocyouth) or die(mysql_error());
$row_Recordset9 = mysql_fetch_assoc($Recordset9);
$totalRows_Recordset9 = mysql_num_rows($Recordset9);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset10 = "SELECT companyprofile.trust FROM companyprofile";
$Recordset10 = mysql_query($query_Recordset10, $nafcocyouth) or die(mysql_error());
$row_Recordset10 = mysql_fetch_assoc($Recordset10);
$totalRows_Recordset10 = mysql_num_rows($Recordset10);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset11 = "SELECT companyprofile.`10` FROM companyprofile";
$Recordset11 = mysql_query($query_Recordset11, $nafcocyouth) or die(mysql_error());
$row_Recordset11 = mysql_fetch_assoc($Recordset11);
$totalRows_Recordset11 = mysql_num_rows($Recordset11);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset12 = "SELECT companyprofile.`10100` FROM companyprofile";
$Recordset12 = mysql_query($query_Recordset12, $nafcocyouth) or die(mysql_error());
$row_Recordset12 = mysql_fetch_assoc($Recordset12);
$totalRows_Recordset12 = mysql_num_rows($Recordset12);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset13 = "SELECT companyprofile.`101200` FROM companyprofile";
$Recordset13 = mysql_query($query_Recordset13, $nafcocyouth) or die(mysql_error());
$row_Recordset13 = mysql_fetch_assoc($Recordset13);
$totalRows_Recordset13 = mysql_num_rows($Recordset13);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset14 = "SELECT companyprofile.`200` FROM companyprofile";
$Recordset14 = mysql_query($query_Recordset14, $nafcocyouth) or die(mysql_error());
$row_Recordset14 = mysql_fetch_assoc($Recordset14);
$totalRows_Recordset14 = mysql_num_rows($Recordset14);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset15 = "SELECT companyprofile.sector FROM companyprofile";
$Recordset15 = mysql_query($query_Recordset15, $nafcocyouth) or die(mysql_error());
$row_Recordset15 = mysql_fetch_assoc($Recordset15);
$totalRows_Recordset15 = mysql_num_rows($Recordset15);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset16 = "SELECT companyprofile.industry FROM companyprofile";
$Recordset16 = mysql_query($query_Recordset16, $nafcocyouth) or die(mysql_error());
$row_Recordset16 = mysql_fetch_assoc($Recordset16);
$totalRows_Recordset16 = mysql_num_rows($Recordset16);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset17 = "SELECT companyprofile.phisicaladdress FROM companyprofile";
$Recordset17 = mysql_query($query_Recordset17, $nafcocyouth) or die(mysql_error());
$row_Recordset17 = mysql_fetch_assoc($Recordset17);
$totalRows_Recordset17 = mysql_num_rows($Recordset17);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset18 = "SELECT companyprofile.postaladdress FROM companyprofile";
$Recordset18 = mysql_query($query_Recordset18, $nafcocyouth) or die(mysql_error());
$row_Recordset18 = mysql_fetch_assoc($Recordset18);
$totalRows_Recordset18 = mysql_num_rows($Recordset18);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset19 = "SELECT companyprofile.postalcode FROM companyprofile";
$Recordset19 = mysql_query($query_Recordset19, $nafcocyouth) or die(mysql_error());
$row_Recordset19 = mysql_fetch_assoc($Recordset19);
$totalRows_Recordset19 = mysql_num_rows($Recordset19);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset20 = "SELECT companyprofile.tel FROM companyprofile";
$Recordset20 = mysql_query($query_Recordset20, $nafcocyouth) or die(mysql_error());
$row_Recordset20 = mysql_fetch_assoc($Recordset20);
$totalRows_Recordset20 = mysql_num_rows($Recordset20);

mysql_select_db($database_nafcocyouth, $nafcocyouth);
$query_Recordset21 = "SELECT companyprofile.emailaddress FROM companyprofile";
$Recordset21 = mysql_query($query_Recordset21, $nafcocyouth) or die(mysql_error());
$row_Recordset21 = mysql_fetch_assoc($Recordset21);
$totalRows_Recordset21 = mysql_num_rows($Recordset21);
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 //EN">
<HTML>

(code)

php code together with the start of the html of
the page register.php

I did extend now with the first table of the page inside
I find thoes recordsets on the local server and select ,select, for each record set.
To make it to work i think i have to put some more stuff but i dont now how.
If you could help me i would be verry thankfull

[e-mail]

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

[ronverdonk]

tagaroe:
You know by now that you should enclose your code within code, html or php tags. If you don't know how to do that, see the Posting Guidelines at the top of this forum!!

I do not want to strain my eyes reading this unstructured bunch of code.

Ronald :cool: