destined

Thanks Steve I wll try that God bless

Thanks play and Steve i cant change the top left my pastor likes that but opening the Quick links in a new target window is a great idea More comments are welcome Thanks e1

oops cant spell lol i dont know How

Thank you for viewing this post On this [a href=\"http://www.destinedtowin.org/audio.html\" target=\"_blank\"]Audio Page[/a] we have mp3 links What my pastor wants is When a link is clicked or right clicked to play and or save as (normal action) But at the same time open a new window (not a popup) Like have a new page open or redirect to the newsletter.php wile the (normal action) is taking place is this a simple JS or do i need to put the mp3s in a DB and use PHP please point me in the rite direc

Welcome and thanks for looking at this post please look at this site and pull it apart (anything to make it better) [a href=\"http://www.destinedtowin.org\" target=\"_blank\"]Destined To Win[/a]

ok ok ok ...lol i used the first method before comming back here and it work for what i needed to do But now i need to get the same emailaddress/firstname from an other database (users) table: tbl_users Thank You both for your help

[!--quoteo(post=381888:date=Jun 9 2006, 11:23 AM:name=Fyorl)--][div class=\'quotetop\']QUOTE(Fyorl @ Jun 9 2006, 11:23 AM) [snapback]381888[/snapback][/div][div class=\'quotemain\'][!--quotec--] You need:[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']INSERT[/span] [color=green]INTO[/color] [color=orange]`emails`[/color] (email, name) [span style=\'color:blue;font-weight:bold\']SELECT[/span] `emailaddress`, `firstname` [color=green]FROM[/color] [color=orange]`newsletter`;[/color] [!--sql2--][/div][!--sql3--]That will insert the firstname and emailaddress from each row in the newsletter table into a new row in the emails table. [/quote] Thank you for the quick reply God bless

Thanks for looking Iam useing phpMyAdmin and tryin to run a query tables: newsletter, emails I am getteing this #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' firstname)' at line 2 I have tryed a few variations of this I know this is a simple thing to most but not to me Please help INSERT INTO emails (email, name) SELECT * FROM newsletter WHERE (emailaddress, firstname) i tryed closing it with ";

that worked $emailaddress = $_POST['emailaddress']; $query="SELECT emailaddress,username,pwd FROM tbl_users WHERE tbl_users.emailaddress = '$emailaddress'"; Thanks agian Crayon Violent

ok so i might not know PHP but the way to learn is to come here and ask i dont let Dreamweaver do it all Thank you Crayon Violent for trying to help i will try what you said and no this is not a Dreamweaver code ill be back tomorrow Thanks agian Crayon Violent

This was working and all i did was take Zip & Address out of the table i think that is when this stoped working (not sure) I dont know much PHP I let Deramweaver do that for me.. lol it keeps saying the (echo)error that the email ady is not in DB but it is ! Please help [!--coloro:#000099--][span style=\"color:#000099\"][!--/coloro--]its the same if i use this[!--colorc--][/span][!--/colorc--] <?php $db_name = "destined_users"; //this is your database name $db_user = "destined_XXX"; //this is your database username for the database specified above $db_pass = "XXXX"; //this is your database password for the user specified above $db_host = "localhost"; //this is your host for the database, best to leave it as localhost mysql_connect("$db_host", "$db_user", "$db_pass")or die(mysql_error()); mysql_select_db("$db_name") or die(mysql_error()); ?> [!--coloro:#333399--][span style=\"color:#333399\"][!--/coloro--]Or If I Use This[!--colorc--][/span][!--/colorc--] <?php require_once('Connections/user_login.php'); ?> <?php mysql_select_db($database_user_login, $user_login); $query_rsRecover = "SELECT * FROM tbl_users"; $rsRecover = mysql_query($query_rsRecover, $user_login) or die(mysql_error()); $row_rsRecover = mysql_fetch_assoc($rsRecover); $totalRows_rsRecover = mysql_num_rows($rsRecover); ?> [!--coloro:#333399--][span style=\"color:#333399\"][!--/coloro--]here is the Code[!--colorc--][/span][!--/colorc--] <?php require_once('Connections/user_login.php'); ?> <?php mysql_select_db($database_user_login, $user_login); $query_rsRecover = "SELECT * FROM tbl_users"; $rsRecover = mysql_query($query_rsRecover, $user_login) or die(mysql_error()); $row_rsRecover = mysql_fetch_assoc($rsRecover); $totalRows_rsRecover = mysql_num_rows($rsRecover); ?> <? $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } ?> <? if (isset($_POST['submit'])){ $query="SELECT emailaddress,username,pwd FROM tbl_users WHERE [!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]emailaddress[!--colorc--][/span][!--/colorc--] = '$emailaddress'"; $st=mysql_query($query); $recs=mysql_num_rows($st); $row=mysql_fetch_object($st); $em=$row->emailaddress;// email is stored to a variable if ($recs == 0) { echo "<center><font face='Verdana' size='2' ><b>No Password</b><br> Sorry Your email address is not there in our database. You can register and login to use our members pages. <BR><BR><a href='registration.php'> Register </a> </center>"; exit;} $headers4="password@destinedtowin.org"; ///// Change this address within quotes to your address /// $headers .= "From: $headers4\n"; $headers .= "Errors-to: $headers4\n"; //$headers = "Content-Type: text/html; charset=iso-8859-1\n".$headers;// for html mail un-comment this line if(mail("$em","password/user name recovery","This is in response to your request for your login information for \n Destined To Win Ministries at www.destinedtowin.org \n\n username: $row->username \n password: $row->pwd \n\n Thank You \n \n \n Please do not reply to this email","$headers")){echo "<center><font face='Verdana' size='2' ><b>THANK YOU</b> <br>Your password and user name have been sent to your emil address. <br> Please check your mail <BR><BR><a href='login.php'> Login </a><br> <br> </center>";} else{ echo " <center><font face='Verdana' size='2' >There is some system problem in sending login details to your address. Please contact site-admin. <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";} } ?>

solved Can dreamweaver make the code to send users there lost password or can someone help me with this code this it not working i copied it from the web i am new at PHP i need to send user name and pswd to the user If anyone has the code for that please post After sumitting i get this error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in -- lost_passwordck.php on line 21 Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /usr/home/destined/public_html/lost_passwordck.php on line 22 <?php session_start(); session_register("session"); ?> <? if (isset($_POST['submit'])){ $query="SELECT emailaddress,username,pwd FROM tbl_users WHERE tbl_users.emailaddress = '$emailaddress'"; $st=mysql_query($query); [!--coloro:#CC6600--][span style=\"color:#CC6600\"][!--/coloro--]$recs=mysql_num_rows($st); $row=mysql_fetch_object($st);[!--colorc--][/span][!--/colorc--] $em=$row->emailaddress;// email is stored to a variable if ($recs == 0) { echo "<center><font face='Verdana' size='2' color=red><b>No Password</b><br> Sorry Your address is not there in our database . You can signup and login to use our site. <BR><BR><a href='signup.php'> Sign UP </a> </center>"; exit;} $headers4="admin@destinedtowin.org"; ///// Change this address within quotes to your address /// $headers.="Reply-to: $headers4\n"; $headers .= "From: $headers4\n"; $headers .= "Errors-to: $headers4\n"; //$headers = "Content-Type: text/html; charset=iso-8859-1\n".$headers;// for html mail un-comment this line if(mail("$em","Your Request for login details","This is in response to your request for login detailst at site_name \n \nLogin ID: $row->username \n Password: $row->pwd \n\n Thank You \n \n siteadmin","$headers")){echo "<center><font face='Verdana' size='2' ><b>THANK YOU</b> <br>Your password is posted to your emil address . Please check your mail after some time. </center>";} else{ echo " <center><font face='Verdana' size='2' color=red >There is some system problem in sending login details to your address. Please contact site-admin. <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";} } else {echo "<center><font face='Verdana' size='2' color=red >$msg <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";} ?>

i dont know what i am doing Would soneone give me a Requiered fields script Please I tryed [code] if (isset($_POST["submit"])) { // Check for empty fields if ($_POST["email"] == "") {      die("Please fill out all fields"); } [/code] I tryed [code] if($_POST['required_field_1'] == "" || $_POST['required_field_2'] == "" || ..... || $_POST['required_field_n'] == ""){ //put your error here } [/code] Do i put [!--coloro:#993300--][span style=\"color:#993300\"][!--/coloro--]echo[!--colorc--][/span][!--/colorc--] for the error and where do i put it [code] <?php require_once('Connections/destined_test.php'); ?> <?php function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") {   $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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; } if ((isset($_POST['emailaddress'])) && ($_POST['emailaddress'] != "")) {   $deleteSQL = sprintf("DELETE FROM newsletter WHERE emailaddress=%s",                        GetSQLValueString($_POST['emailaddress'], "text"));   mysql_select_db($database_destined_test, $destined_test);   $Result1 = mysql_query($deleteSQL, $destined_test) or die(mysql_error());   $deleteGoTo = "unsubscribed.php";   if (isset($_SERVER['QUERY_STRING'])) {     $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";     $deleteGoTo .= $_SERVER['QUERY_STRING'];   }   header(sprintf("Location: %s", $deleteGoTo)); } mysql_select_db($database_destined_test, $destined_test); $query_rsUnsubscribe = "SELECT * FROM newsletter"; $rsUnsubscribe = mysql_query($query_rsUnsubscribe, $destined_test) or die(mysql_error()); $row_rsUnsubscribe = mysql_fetch_assoc($rsUnsubscribe); $totalRows_rsUnsubscribe = mysql_num_rows($rsUnsubscribe); ?> [/code] [b]EDIT BY OBER: PLEASE USE CODE TAGS WHEN POSTING CODE[/b] thanks ober

Thanks i have phpMyAdmin How would i get the correct Answer to be posted to the rite Question use the QID ?

How do i make a new DB table in dreamweaver? i need to make a question and answers page. How do i get the right Answes to the original Question ? i have used dreanweaver to make this page: [a href=\"http://www.destinedtowin.org/test/page/devotional.php\" target=\"_blank\"]http://www.destinedtowin.org/test/page/devotional.php[/a]