Search found 16 matches

Actual Results

Post Posted: November 23rd, 2003, 1:16 pm

now I got another question, let's say I want to display every username in the table what would be the code?

Post Posted: November 23rd, 2003, 1:14 pm

Hmn ... then it should work. Are you sure the database and table exist, and that you have the right to edit them ? I though I already said this, but if not, the whole server mySQl PhP, etc are all on my machine its localhost. so I have the editing rights and the table is fine. Anyways, thanks for a...

Post Posted: November 23rd, 2003, 9:43 am

The backslashes are there to make sure PHP doesn't see the " as the ending of the string definition. Example: $a = "Variable goes here"; //valid $b = "This is a double quote: ""; //valid $c = "This is a double quote: ""; //invalid By the way, " is not the same as ' for MySQL. I tried it with t...

Post Posted: November 22nd, 2003, 1:57 pm

I believe you needed double quotes around the values: UPDATE tablename SET field = "theNewValue" WHERE field = "theOldValue"; In PHP that would become: [code] $conn = mysql_connect("host","username","pw"); $q = "UPDATE tablename SET field = "$newValue...

Post Posted: November 1st, 2003, 8:24 am

thanks for the help, i'm gonna go try to find my error log folders on my server, hpefully i'll be able to solve this error

Post Posted: October 31st, 2003, 7:32 pm

ok, all the files are up on
http://www.dragonsoftheweb.com/fs
had to put them in txt format so u cna read them, and dont know how to make code appear using xml yet

Post Posted: October 31st, 2003, 7:15 pm

Have you tested to make sure data is stored in the $username and $id variables? In other words they are not blank correct? Also I know you said you had the MySQL table setup, but do you have an ID in that MySQL table that matches the ID that you are sending through the $id variable? Also, what vers...

Post Posted: October 31st, 2003, 5:06 pm

i just tried this on a completely different mySQL database, on my website, hoping that this was just an error with the mysql on my comp, and once again, nothing happens, and no errors.

Post Posted: October 31st, 2003, 4:54 pm

yes i have created the tables, otherwise there would be nothin to update, and yeah, that script does look identical to mine except variable names, i honestly dont know y this doesn't work

Post Posted: October 31st, 2003, 4:23 pm

tnx for the concern well i tried it the way you did it $sql = "UPDATE users SET username = $username WHERE id = $id"; if (!($result = $db->sql_query($sql))) { message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql); } and it gave me this: $result = mysql_query($sq...

Post Posted: October 31st, 2003, 2:10 pm

I do not have an answer for you yet, but I just wanted to let you know that I replaced your password above in your code examples to ****** because I wasn't sure if you used fake credentials there. We do not need anyone trying to hack into your server. If that was your actual info you used, I would ...

Post Posted: October 30th, 2003, 9:14 pm

<?php error_reporting(E_ALL); session_start(); include("top.php"); $id = $_SESSION["id"]; //echo $id; $conn = mysql_connect("localhost","adm","******") or die(mysql_error()); $db = mysql_select_db("fs",$conn) or die(mysql_error()); $result = mysql_query("UPDATE users SET username=$username WHERE...

Post Posted: October 30th, 2003, 8:11 pm

man, I was honestly praying to God that what you said would work, since if it works my whole game is set, I can make the rest of it no problem but Newton's (or Murphy's) Law says" everything that can go wrong, will" Error: Unknown column 'test' in 'field list' test is the username and when username=...

Post Posted: October 25th, 2003, 7:26 pm

UNFLUX wrote:
can we try to use subjects that are appropriate to the question? thanks. :)


how's my post inappropriate to the subject? I suggested an alternative to cookies, since he said he having problems with them

Post Posted: October 25th, 2003, 7:20 pm

<?php error_reporting(E_ALL); session_start(); include("top.php"); $id = $_SESSION["id"]; //echo $id; $conn = mysql_connect("localhost","adm","******") or die(mysql_error()); $db = mysql_select_db("fs",$conn) or die(mysql_error()); $result = mysql_query("UPDATE users SET username='$username' WHE...

Post Posted: October 25th, 2003, 7:09 pm

try using sessions, cookies are blocked for a lot of people nowadays, sessions are very nice and easy to use and also safe
  • Sort by
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.