this page wont write to database

[Join us @ facebook]

What's the problem here?

You know we can't help you if you don't tell what the problem is.

[SEO Voter]

Well, so far I can see that you have the ame problem as the last piece of code. You need to use the same if statement in this one too. But the name is "update" this time.

yes this page wont update the database either. that is the problem nik

[Join us @ facebook]

Change your sql statement to this :

"UPDATE links set url = '$url', title = '$title', description = '$description' where id = '".$_GET[links]."'"

By the way this would be faster if you put a limit. Eg.

"UPDATE links set url = '$url', title = '$title', description = '$description' where id = '".$_GET[links]."' LIMIT 1"

u are looking at wrong page, i am on a different one, link_mod.php:

Code:

<?
ob_start();
include("config.php");
if ($logged[username] && $logged[level] >= 2) 
{
// the user is logged in!  We continue...
if ($_POST['update'] != 'Update')
{
// the form hasn't been submitted.  We continue...
$data2 = mysql_query("SELECT * from users where username = '$logged[username]'");
$data2 = mysql_fetch_array($data2);
$urlid = $data2[urlid];
$data = mysql_query("SELECT * from links where id = '$urlid'");
$data = mysql_fetch_array($data);
// the above lines get the information so that it can be displayed in the html form.
echo("
<div align=\"center\"><form method=\"post\">
<table>

<tr>
<td valign=\"top\">Links Title: </td>
<td valign=\"top\"><input name=\"title\" type=\"text\" value=\"$data[title]\"></td>
</tr>
<tr>
<td valign=\"top\">Links URL: </td>
<td valign=\"top\"><input name=\"url\" type=\"text\" value=\"$data[url]\"></td>
</tr>
<tr>
<td height=\"85\" valign=\"top\">Description: <br> </td>
<td valign=\"top\"><textarea cols=\"30\" rows=\"5\" name=\"description\">$data[description]</textarea>
</td>
</tr>
<tr>
<td align=\"center\" colspan=2><input type=\"submit\" name=\"update\" value=\"Update\"></td>
</tr>
</table>
</form>
</div>");
}
else
{
$url = $_POST[url];
$title = $_POST[title];
$description = $_POST[description];
// the above lines set variables used below
$update = ("UPDATE links set url = '$url', title = '$title', description = '$description' where id = '$urlid'");
mysql_query($update) or die(mysql_error());
// updates the information in the database.
echo "Your link has been successfully updated."; 
}
}
else
{
// They aren't logged in!
echo "You have either not paid for your link to even submit it, or you are not logged in.";
}
?>

[Join us @ facebook]

The first query may not work ( "SELECT * from users where username = '$logged[username]'" )

Change it to

"SELECT * from users where username = '".$logged[username]."'"

If you still have problem please also let us know the error message that you get

i htink that query does work because it loads the right link in the form based on what user is logged in, and what URL ID they are assigned manually by me.. it says that it updates teh link but nothing happens

[Join us @ facebook]

I can't figure it out.

Something that you should do is adding slashes to the post vaariables that you use.

eg. $url = addslashes (  $_POST[url] ) ; (instead of $url = $_POST[url]; )

[SEO Voter]

I would say that your $urlid is not being set in the else part...

ya thats what i thought, that it wasnt correctly updating the right ID #.. any suggestions? i tried addslashes (nik) and still no luck..  but i will leave them there as u say it is better but for what reason im not sure..

[SEO Voter]

$urlid is not being set when you are trying to do the update. You have to set it in the "else" part of the page.

$urlid as you see comes from a separate table where i pre-define this variable myself.. so how would i go about doing this? i am still learning the basics of php i am v-confused.. i tried creating new $update query = no luck, tried adding it to the current query = no luck..

edit: by the way after you help me figure this one out, i will send u 500 credits for your trouble

[SEO Voter]

Take this code:

Code:

$data2 = mysql_query("SELECT * from users where username = '$logged[username]'");
$data2 = mysql_fetch_array($data2);
$urlid = $data2[urlid];

and place it in front of the "if" statement. This way you can use it for both the if and else parts.

yep that fixed it and i should of known that, ill send u the credits now.. wondering if ud still be able to help me if i was to PM you in the future and pay credits each time?

[SEO Voter]

Thanks... sure I will help where I can!

[SEO Voter]

Another thing... why not set output buffering in the .htaccess file? Then you don't have to turn it on at the start of each page.

[Guest]

[37.987]

Yahoo crawler, Googlebot, Msnbot, Baidu Spider