Jump to content

Grant Holmes

Members
 View Profile  See their activity

  • Posts

    221

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by Grant Holmes

  1. Grant Holmes
    FWIW, I tried my edit and got a parse error.
  2. Grant Holmes
    I'm a newbie, but yes, the include IS there!! So are you saying this goes into ANY query "open" I do??? In my line 11, I have: include("dbinfo.inc.php"); mysql_connect($dbhost,$username,$password); mysql_select_db($database) or die( "Unable to select database") To make sure I understand... change the above to: include("dbinfo.inc.php"); $conn = mysql_connect($dbhost,$username,$password); mysql_select_db($database) or die( "Unable to select database") mysql_query($query,$conn); Do I need to do this on every query?
  3. Grant Holmes
    Last bump. Anymore help gang?
  4. Grant Holmes
    "@" removed. And fixed two results/die statements. By "mysql info", do you mean the connection info? If so, yes I am. So, after all that, I'm back to a page without errors that doesn't save the results. sigh.
  5. Grant Holmes
    Okay, so I found that one place where it wasn't and one place where the "DIE" part was missing. So now my code is: <?php include_once("security/MYsecurity.php"); ?> <?php $DOCROOT = $_SERVER['DOCUMENT_ROOT'] ; ?> <? $id = $_REQUEST["id"]; include("dbinfo.inc.php"); mysql_connect($dbhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); if (!empty($_REQUEST["submit"])) { extract($_REQUEST); if ($_REQUEST["submit"] == "Delete") { $query = "DELETE FROM SongList WHERE id=".$ud_id; $result=mysql_query($query) or die(mysql_error()); // **********added the 'die' here header("Location: song_list.php?del=1"); } else { $query="UPDATE SongList SET active = '".$ud_active."', SongTitle = '".$ud_SongTitle."', ArtistPrimary = '".$ud_ArtistPrimary."', ArtistSecondary = '".$ud_WriterPrimary."', WriterSecondary = '".$ud_WriterSecondary."', Contact_Info_ZipCode = '".$ud_RelatedURL."', RelatedURL = '".$ud_Comments."', PartOf = '".$ud_PartOf."', SongStatus = '".$ud_SongStatus."', SongPace = '".$ud_SongPace."', Minutes = '".$ud_Minutes."', YearRecorded = '".$ud_YearRecorded."', YearWritten = '".$ud_YearWritten."', RecordLabel = '".$ud_RecordLabel."', Lyrics = '".$ud_Lyrics."', active = '".$ud_active."' WHERE id = '".$ud_id."'"; $result=mysql_query($query); header("Location: song_list.php?id=".$ud_id); } } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML> <HEAD> <TITLE>Edit Request</TITLE> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="GOOGLEBOT" CONTENT="NOARCHIVE"> <META NAME="ROBOTS" CONTENT="NONE"> <LINK REL="stylesheet" TYPE="text/css" HREF="CSS/SEC.css"> </HEAD> <?php $query='SELECT * FROM SongList where id = "'.$id.'"'; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<H1>Edit Song Details</H1>"; $result=mysql_query($query) or die(mysql_error());// ***********added whole line here ?> <center><div style='width:100%; background-color:silver; text-align:right'> <?php SECShowAdminLink(); ?> <?php SECShowLogoutLink(); ?> </div></center> <table border="1" cellspacing="2" cellpadding="2" width="800" class="sortable"> <tr> <th width="130">Song info</th> <TH valign="top" width="30">Comments</TH> <TH valign="top" width="30">Lyrics</TH> <TH valign="top" width="30">Details</TH> <th> </th> </tr> <? $i=0; while ($i < $num) { $active=mysql_result($result,$i,"active"); $SongTitle=mysql_result($result,$i,"SongTitle"); $ArtistPrimary=mysql_result($result,$i,"ArtistPrimary"); $ArtistSecondary=mysql_result($result,$i,"ArtistSecondary"); $WriterPrimary=mysql_result($result,$i,"WriterPrimary"); $WriterSecondary=mysql_result($result,$i,"WriterSecondary"); $RelatedURL=mysql_result($result,$i,"RelatedURL"); $Comments=mysql_result($result,$i,"Comments"); $PartOf=mysql_result($result,$i,"PartOf"); $SongStatus=mysql_result($result,$i,"SongStatus"); $SongPace=mysql_result($result,$i,"SongPace"); $Minutes=mysql_result($result,$i,"Minutes"); $YearRecorded=mysql_result($result,$i,"YearRecorded"); $YearWritten=mysql_result($result,$i,"YearWritten"); $RecordLabel=mysql_result($result,$i,"RecordLabel"); $Lyrics=mysql_result($result,$i,"Lyrics"); $id=mysql_result($result,$i,"id"); ?> <form method="post"> <input type="hidden" name="ud_id" value="<? echo $id; ?>"> <tr> <td valign="top"><STRONG>Title: <input type="text" name="ud_SongTitle" value="<? echo $SongTitle; ?>"><BR> Artists: </STRONG><input type="text" name="ud_ArtistPrimary" value="<? echo $ArtistPrimary; ?>"><input type="text" name="ud_ArtistSecondary" value="<? echo $ArtistSecondary; ?>"> <BR> Writers: <input type="text" name="ud_WriterPrimary" value="<? echo $WriterPrimary; ?>"><input type="text" name="ud_WriterSecondary" value="<? echo $WriterSecondary; ?>"><BR> Status: <input type="text" name="ud_SongStatus" value="<? echo $SongStatus; ?>"><BR> <SMALL>1-On Playlist<BR>2-Needs Added<BR>3-No Track</SMALL><BR><BR> Pace: <input type="text" name="ud_SongPace" value="<? echo $SongPace; ?>"><BR> <SMALL>Slow Medium Faster Smokin</SMALL> </td> <TD valign="top" width="30"> <textarea id="Comments" name="ud_Comments" rows="20" cols="40" wrap='physical'><?php echo $Comments; ?></textarea></TD> <TD valign="top" width="30"> <textarea id="Lyrics" name="ud_Lyrics" rows="20" cols="40" wrap='physical'><?php echo $Lyrics; ?></textarea></TD> <TD valign="top" width="30"> <SMALL>Length:</SMALL> <input type="text" name="ud_Minutes" value="<? echo $Minutes; ?>"><BR><BR> <SMALL>Recorded in:</SMALL> <input type="text" name="ud_YearRecorded" value="<? echo $YearRecorded; ?>"><BR><BR> <SMALL>Year Written:</SMALL> <input type="text" name="ud_YearWritten" value="<? echo $YearWritten; ?>"><BR><BR> <SMALL>Year Written:</SMALL> <input type="text" name="ud_RecordLabel" value="<? echo $RecordLabel; ?>"><BR><BR> </TD> <TD valign="top"> <?php $checked = $Active ? 'checked' :''; echo "active ? <input type='checkbox'' name='ud_active'' value='1' $checked>"; ?> </TD> <TD rowspan="2" valign="top"> <CENTER><input type="submit" name="submit" value="Update"> <BR><BR><input type=button value="Cancel" onClick="history.go(-1)"><BR><BR> <input type="submit" name="submit" value="Delete" onclick="return confirm('Are you sure you want to delete this record? This cannot be undone!')"></CENTER> </form></TD> </TR> <TR> <TD valign="top" colspan="2"><SMALL>Related URL:</SMALL><BR> <textarea id="RelatedURL" name="ud_RelatedURL" rows="1" cols="50" wrap='physical'><?php echo $RelatedURL; ?></textarea> </TD> <TD valign="top" colspan="2"> <SMALL>Part Of:</SMALL><BR> <textarea id="PartOf" name="ud_PartOf" rows="1" cols="50" wrap='physical'><?php echo $PartOf; ?></textarea> </TD> </TR> <?php ++$i; } echo "</table><BR>"; ?> Now when I hit the page I get: Warning: mysql_query(): Access denied for user 'apache'@'localhost' (using password: NO) in /var/www/vhosts/MYSITE.com/httpdocs/datatube/songs_edit.php on line 52 Warning: mysql_query(): A link to the server could not be established in /var/www/vhosts/MYSITE.com/httpdocs/datatube/songs_edit.php on line 52 Access denied for user 'apache'@'localhost' (using password: NO)
  6. Grant Holmes
    So you're saying here: <?php $query='SELECT * FROM SongList where id = "'.$id.'"'; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<H1>Edit Song Details</H1>"; ?> Do this?? <?php $query='SELECT * FROM SongList where id = "'.$id.'"'; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<H1>Edit Song Details</H1>"; $result=mysql_query($query) or die(mysql_error()); ?> ??
  7. Grant Holmes
    So I know we're all on the same page now.... The page displays, there are no errors showing, but no changes are saved to the table. Here's where I am: <?php include_once("security/Mysecurity.php"); ?> <?php $DOCROOT = $_SERVER['DOCUMENT_ROOT'] ; ?> <? $id = $_REQUEST["id"]; include("dbinfo.inc.php"); mysql_connect($dbhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); if (!empty($_REQUEST["submit"])) { extract($_REQUEST); if ($_REQUEST["submit"] == "Delete") { $query = "DELETE FROM SongList WHERE id=".$ud_id; $result=mysql_query($query); header("Location: song_list.php?del=1"); } else { $query="UPDATE SongList SET active = '".$ud_active."', SongTitle = '".$ud_SongTitle."', ArtistPrimary = '".$ud_ArtistPrimary."', ArtistSecondary = '".$ud_WriterPrimary."', WriterSecondary = '".$ud_WriterSecondary."', Contact_Info_ZipCode = '".$ud_RelatedURL."', RelatedURL = '".$ud_Comments."', PartOf = '".$ud_PartOf."', SongStatus = '".$ud_SongStatus."', SongPace = '".$ud_SongPace."', Minutes = '".$ud_Minutes."', YearRecorded = '".$ud_YearRecorded."', YearWritten = '".$ud_YearWritten."', RecordLabel = '".$ud_RecordLabel."', Lyrics = '".$ud_Lyrics."', active = '".$ud_active."' WHERE id = '".$ud_id."'"; $result=mysql_query($query); header("Location: song_list.php?id=".$ud_id); } } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML> <HEAD> <TITLE>Edit Request</TITLE> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="GOOGLEBOT" CONTENT="NOARCHIVE"> <META NAME="ROBOTS" CONTENT="NONE"> <LINK REL="stylesheet" TYPE="text/css" HREF="CSS/SEC.css"> </HEAD> <?php $query='SELECT * FROM SongList where id = "'.$id.'"'; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<H1>Edit Song Details</H1>"; ?> <center><div style='width:100%; background-color:silver; text-align:right'> <?php SECShowAdminLink(); ?> <?php SECShowLogoutLink(); ?> </div></center> <table border="1" cellspacing="2" cellpadding="2" width="800" class="sortable"> <tr> <th width="130">Song info</th> <TH valign="top" width="30">Comments</TH> <TH valign="top" width="30">Lyrics</TH> <TH valign="top" width="30">Details</TH> <th> </th> </tr> <? $i=0; while ($i < $num) { $active=mysql_result($result,$i,"active"); $SongTitle=mysql_result($result,$i,"SongTitle"); $ArtistPrimary=mysql_result($result,$i,"ArtistPrimary"); $ArtistSecondary=mysql_result($result,$i,"ArtistSecondary"); $WriterPrimary=mysql_result($result,$i,"WriterPrimary"); $WriterSecondary=mysql_result($result,$i,"WriterSecondary"); $RelatedURL=mysql_result($result,$i,"RelatedURL"); $Comments=mysql_result($result,$i,"Comments"); $PartOf=mysql_result($result,$i,"PartOf"); $SongStatus=mysql_result($result,$i,"SongStatus"); $SongPace=mysql_result($result,$i,"SongPace"); $Minutes=mysql_result($result,$i,"Minutes"); $YearRecorded=mysql_result($result,$i,"YearRecorded"); $YearWritten=mysql_result($result,$i,"YearWritten"); $RecordLabel=mysql_result($result,$i,"RecordLabel"); $Lyrics=mysql_result($result,$i,"Lyrics"); $id=mysql_result($result,$i,"id"); ?> <form method="post"> <input type="hidden" name="ud_id" value="<? echo $id; ?>"> <tr> <td valign="top"><STRONG>Title: <input type="text" name="ud_SongTitle" value="<? echo $SongTitle; ?>"><BR> Artists: </STRONG><input type="text" name="ud_ArtistPrimary" value="<? echo $ArtistPrimary; ?>"><input type="text" name="ud_ArtistSecondary" value="<? echo $ArtistSecondary; ?>"> <BR> Writers: <input type="text" name="ud_WriterPrimary" value="<? echo $WriterPrimary; ?>"><input type="text" name="ud_WriterSecondary" value="<? echo $WriterSecondary; ?>"><BR> Status: <input type="text" name="ud_SongStatus" value="<? echo $SongStatus; ?>"><BR> <SMALL>1-On Playlist<BR>2-Needs Added<BR>3-No Track</SMALL><BR><BR> Pace: <input type="text" name="ud_SongPace" value="<? echo $SongPace; ?>"><BR> <SMALL>Slow Medium Faster Smokin</SMALL> </td> <TD valign="top" width="30"> <textarea id="Comments" name="ud_Comments" rows="20" cols="40" wrap='physical'><?php echo $Comments; ?></textarea></TD> <TD valign="top" width="30"> <textarea id="Lyrics" name="ud_Lyrics" rows="20" cols="40" wrap='physical'><?php echo $Lyrics; ?></textarea></TD> <TD valign="top" width="30"> <SMALL>Length:</SMALL> <input type="text" name="ud_Minutes" value="<? echo $Minutes; ?>"><BR><BR> <SMALL>Recorded in:</SMALL> <input type="text" name="ud_YearRecorded" value="<? echo $YearRecorded; ?>"><BR><BR> <SMALL>Year Written:</SMALL> <input type="text" name="ud_YearWritten" value="<? echo $YearWritten; ?>"><BR><BR> <SMALL>Year Written:</SMALL> <input type="text" name="ud_RecordLabel" value="<? echo $RecordLabel; ?>"><BR><BR> </TD> <TD valign="top"> <?php $checked = $Active ? 'checked' :''; echo "active ? <input type='checkbox'' name='ud_active'' value='1' $checked>"; ?> </TD> <TD rowspan="2" valign="top"> <CENTER><input type="submit" name="submit" value="Update"> <BR><BR><input type=button value="Cancel" onClick="history.go(-1)"><BR><BR> <input type="submit" name="submit" value="Delete" onclick="return confirm('Are you sure you want to delete this record? This cannot be undone!')"></CENTER> </form></TD> </TR> <TR> <TD valign="top" colspan="2"><SMALL>Related URL:</SMALL><BR> <textarea id="RelatedURL" name="ud_RelatedURL" rows="1" cols="50" wrap='physical'><?php echo $RelatedURL; ?></textarea> </TD> <TD valign="top" colspan="2"> <SMALL>Part Of:</SMALL><BR> <textarea id="PartOf" name="ud_PartOf" rows="1" cols="50" wrap='physical'><?php echo $PartOf; ?></textarea> </TD> </TR> <? ++$i; } echo "</table><BR>"; ?>
  8. Grant Holmes
    Okay kids, it's getting deep. Yes, that worked. I'm not sure why. I'm SURE I don't care!! Thanks a BUNCH!!!! hey, if you're bored... I'm stuck on this one: More Header Fun
  9. Grant Holmes
    phpSensei, your solution returns zeros: "0000-00-00 00:00:00" and I don't see where you're assigning the value to: $time rhodesa, yours still returns a blank page.
  10. Grant Holmes
    bump
  11. Grant Holmes
    I wouldn't spend a lot of time on it. There are hundreds of free/cheap ecommerce solutions out there including (yuk) paypal. SSL cert is easy. Go to GeoCerts.com and they'll hook you up. Some hosts include this with their ecommerce, so make sure you need it first.
  12. Grant Holmes
    rhodesa, I need to leave the T off, as I store this value in my table and the field isn't set for that, so would leaving it off still work?
  13. Grant Holmes
    Thanks for the help gang. phpSensei, I read that page, but I'm noob to PHP and have no idea what to edit/add/whatever. rhodesa, (see above on being a newbie)... I put that above my code within the php like this: date_ default_ timezone_ set('America/Los_Angeles'); $time=date("Y-m-d H:i:s"); but then the page failed to display. HELP!?
  14. Grant Holmes
    I have a processing form reporting the time when a record is inserted. This field is never changed. However, our server (Yahoo) is in London. My client is in CA. I'd like to post a time relevant to LA. In my page I do: $time=date("Y-m-d H:i:s"); Is there a way to subtract the 9 hour difference? H-9??
  15. Grant Holmes
    See: header("Location: song_list.php?del=1"); } else { $query="UPDATE SongList SET active = '".$ud_active."', SongTitle = '".$ud_SongTitle."', ArtistPrimary = '".$ud_ArtistPrimary."', ArtistSecondary = '".$ud_WriterPrimary."', WriterSecondary = '".$ud_WriterSecondary."', Contact_Info_ZipCode = '".$ud_RelatedURL."', RelatedURL = '".$ud_Comments."', PartOf = '".$ud_PartOf."', SongStatus = '".$ud_SongStatus."', SongPace = '".$ud_SongPace."', Minutes = '".$ud_Minutes."', YearRecorded = '".$ud_YearRecorded."', YearWritten = '".$ud_YearWritten."', RecordLabel = '".$ud_RecordLabel."', Lyrics = '".$ud_Lyrics."', active = '".$ud_active."' WHERE id = '".$ud_id."'"; } // I added this, but this just moved the error down one row. ?>
  16. Grant Holmes
    Thought if I posted the error it might help. Parse error: parse error, unexpected $ in /var/www/vhosts/MySite.com/httpdocs/datatube/songs_edit.php on line 141
  17. Grant Holmes
    aschk, I honestly understand little about all this!! What you wrote was pretty much Greek to me!! Please don't worry about clarifying. Ken, I did some double-checking to make sure I'd put your code where it was supposed to be, etc. The error is now showing on line 141. In my editor, I don't see a line 141. Hmmmm.... <?php include_once("security/SECsecurity.php"); ?> <?php $DOCROOT = $_SERVER['DOCUMENT_ROOT'] ; ?> <? $id = $_REQUEST["id"]; include("dbinfo.inc.php"); mysql_connect($dbhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); if (!empty($_REQUEST["submit"])) { extract($_REQUEST); if ($_REQUEST["submit"] == "Delete") { $query = "DELETE FROM SongList WHERE id=".$ud_id; $result=mysql_query($query); header("Location: song_list.php?del=1"); } else { $query="UPDATE SongList SET active = '".$ud_active."', SongTitle = '".$ud_SongTitle."', ArtistPrimary = '".$ud_ArtistPrimary."', ArtistSecondary = '".$ud_WriterPrimary."', WriterSecondary = '".$ud_WriterSecondary."', Contact_Info_ZipCode = '".$ud_RelatedURL."', RelatedURL = '".$ud_Comments."', PartOf = '".$ud_PartOf."', SongStatus = '".$ud_SongStatus."', SongPace = '".$ud_SongPace."', Minutes = '".$ud_Minutes."', YearRecorded = '".$ud_YearRecorded."', YearWritten = '".$ud_YearWritten."', RecordLabel = '".$ud_RecordLabel."', Lyrics = '".$ud_Lyrics."', active = '".$ud_active."' WHERE id = '".$ud_id."'"; ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML> <HEAD> <TITLE>Edit Request</TITLE> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="GOOGLEBOT" CONTENT="NOARCHIVE"> <META NAME="ROBOTS" CONTENT="NONE"> <LINK REL="stylesheet" TYPE="text/css" HREF="CSS/SEC.css"> </HEAD> <?php $query='SELECT * FROM SongList where id = "'.$id.'"'; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<H1>Edit Song Details</H1>"; ?> <center><div style='width:100%; background-color:silver; text-align:right'> <?php SECShowAdminLink(); ?> <?php SECShowLogoutLink(); ?> </div></center> <table border="1" cellspacing="2" cellpadding="2" width="800" class="sortable"> <tr> <th width="130">Song info</th> <TH valign="top" width="30">Comments</TH> <TH valign="top" width="30">Lyrics</TH> <TH valign="top" width="30">Details</TH> <th> </th> </tr> <? $i=0; while ($i < $num) { $active=mysql_result($result,$i,"active"); $SongTitle=mysql_result($result,$i,"SongTitle"); $ArtistPrimary=mysql_result($result,$i,"ArtistPrimary"); $ArtistSecondary=mysql_result($result,$i,"ArtistSecondary"); $WriterPrimary=mysql_result($result,$i,"WriterPrimary"); $WriterSecondary=mysql_result($result,$i,"WriterSecondary"); $RelatedURL=mysql_result($result,$i,"RelatedURL"); $Comments=mysql_result($result,$i,"Comments"); $PartOf=mysql_result($result,$i,"PartOf"); $SongStatus=mysql_result($result,$i,"SongStatus"); $SongPace=mysql_result($result,$i,"SongPace"); $Minutes=mysql_result($result,$i,"Minutes"); $YearRecorded=mysql_result($result,$i,"YearRecorded"); $YearWritten=mysql_result($result,$i,"YearWritten"); $RecordLabel=mysql_result($result,$i,"RecordLabel"); $Lyrics=mysql_result($result,$i,"Lyrics"); $id=mysql_result($result,$i,"id"); ?> <form method="post"> <input type="hidden" name="ud_id" value="<? echo $id; ?>"> <tr> <td valign="top"><STRONG>Title: <input type="text" name="ud_SongTitle" value="<? echo $SongTitle; ?>"><BR> Artists: </STRONG><input type="text" name="ud_ArtistPrimary" value="<? echo $ArtistPrimary; ?>"><input type="text" name="ud_ArtistSecondary" value="<? echo $ArtistSecondary; ?>"> <BR> Writers: <input type="text" name="ud_WriterPrimary" value="<? echo $WriterPrimary; ?>"><input type="text" name="ud_WriterSecondary" value="<? echo $WriterSecondary; ?>"><BR> Status: <input type="text" name="ud_SongStatus" value="<? echo $SongStatus; ?>"><BR> <SMALL>1-On Playlist<BR>2-Needs Added<BR>3-No Track</SMALL><BR><BR> Pace: <input type="text" name="ud_SongPace" value="<? echo $SongPace; ?>"><BR> <SMALL>Slow Medium Faster Smokin</SMALL> </td> <TD valign="top" width="30"> <textarea id="Comments" name="ud_Comments" rows="20" cols="40" wrap='physical'><?php echo $Comments; ?></textarea></TD> <TD valign="top" width="30"> <textarea id="Lyrics" name="ud_Lyrics" rows="20" cols="40" wrap='physical'><?php echo $Lyrics; ?></textarea></TD> <TD valign="top" width="30"> <SMALL>Length:</SMALL> <input type="text" name="ud_Minutes" value="<? echo $Minutes; ?>"><BR><BR> <SMALL>Recorded in:</SMALL> <input type="text" name="ud_YearRecorded" value="<? echo $YearRecorded; ?>"><BR><BR> <SMALL>Year Written:</SMALL> <input type="text" name="ud_YearWritten" value="<? echo $YearWritten; ?>"><BR><BR> <SMALL>Year Written:</SMALL> <input type="text" name="ud_RecordLabel" value="<? echo $RecordLabel; ?>"><BR><BR> </TD> <TD valign="top"> <?php $checked = $Active ? 'checked' :''; echo "active ? <input type='checkbox'' name='ud_active'' value='1' $checked>"; ?> </TD> <TD rowspan="2" valign="top"> <CENTER><input type="submit" name="submit" value="Update"> <BR><BR><input type=button value="Cancel" onClick="history.go(-1)"><BR><BR> <input type="submit" name="submit" value="Delete" onclick="return confirm('Are you sure you want to delete this record? This cannot be undone!')"></CENTER> </form></TD> </TR> <TR> <TD valign="top" colspan="2"><SMALL>Related URL:</SMALL><BR> <textarea id="RelatedURL" name="ud_RelatedURL" rows="1" cols="50" wrap='physical'><?php echo $RelatedURL; ?></textarea> </TD> <TD valign="top" colspan="2"> <SMALL>Part Of:</SMALL><BR> <textarea id="PartOf" name="ud_PartOf" rows="1" cols="50" wrap='physical'><?php echo $PartOf; ?></textarea> </TD> </TR> <? ++$i; } echo "</table><BR>"; ?>
  18. Grant Holmes
    I'm not sure I follow you, but the one file where the variables are stored, it is ONLY php and has no html or <HEAD> section
  19. Grant Holmes
    The "other" host is Yahoo. We're looking to move the site. As you may know, getting Yahoo to do ANYTHING (like answer tech support questions) is nigh on impossible.
  20. Grant Holmes
    Ken, thank you for the extensive and thoughtful reply. I used your "reverse the quotes" code and got this: Parse error: parse error, unexpected '}' in /var/www/vhosts/MYSIte.com/httpdocs/datatube/songs_edit.php on line 140 [as a separate issue, can you tell my why a query like this DOES work with a different host? Is it the PHP.ini restrictions?] Next: Where do I put the error check? Immediately after the query code we're trying to fix? Last: Escape String: I am using POST. Does this code replace what we're working on, or where would it go. Sorry I'm such a noob, gang. I REALLY appreciate the help.
  21. Grant Holmes
    JacobYaYa, You nailed it. That works great. ricerocket, you were correct. This one is solved. Coooooool stuff. Thanks gang!
  22. Grant Holmes
    Thanks for the response. For my clarity (btw, this was written for me by a php friend and is working on another site as is") That I don't understand... Okay. My code looks like this: active = "'.$ud_active.'", SongTitle = "'.$ud_SongTitle.'", Appears to use BOTH quote marks (") AND single quotes ('). You're saying to make them JUST single quotes?
  23. Grant Holmes
    bump... Can anyone see anything wrong in the processing portion? If my tests are correct, if I change the "active" status, that is working. However, no other fields changed pass the data to the table.
  24. Grant Holmes
    phpSensei, I tried that, and several variations and can't get it to work. I think we're on the same page, but let me restate, just in case. ON the variables page, I want to define where the CSS is for this "section". On the page(s) of this section, I want to call that one variable for where the CSS is. This is not a critical issue, but am trying to learn as I do this too. That help?
  25. Grant Holmes
    I hope my subject line is close! At the top of my php page in the <HEAD> is this: <LINK REL="stylesheet" TYPE="text/css" HREF="CSS/SEC.css"> I have another page on my site where I store a bunch of variables: <?php include_once("security/Mysecurity.php"); ?> There I store: $MYcss = "../CSS/SEC.css"; How can I put that in the page so it recognizes the CSS? I've tried about 10 things and nothing works.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.