Quick PHP Question

[mkx]

I am using the following:

[CODE]$sqlquery = "UPDATE `table` SET `name` = '$name' WHERE `id` = 'id1'";
$results = mysql_query($sqlquery);/CODE]

However, this only seems to be working for the ID that is 4 numerical characters long and not the ID that is 20 characters long with both numerical and alphabetical characters .

Anyway to make this work with both?

[ilbb]

Use quotes exactly:
$name = name
$id = id of row in table

$sqlquery = "UPDATE `table` SET `name` = '".$name."' WHERE `id` = '".$id."'";

What data types do You have in Your sql table?

[ilbb]

and Yes, If You want to work with 20chars id's check atrib ID datatypes:

varchar (20) for alphabetical
int (20) for numeric only

[mkx]

ID = VARCHAR 20. It is also the Key. The script already pulls the ID from the url and when I echo ID1 on the page its correct

[mkx]

Sorry - SET `name` = '55' name is already set in the script itself

[mkx]

varchar (20) for alphabetical
int (20) for numeric only

What should I use for both? It looks something like this 907fasd90f78aha

[GFX Wiz]

varchar (20) for alphabetical
int (20) for numeric only

What should I use for both? It looks something like this 907fasd90f78aha

char (20)

[mkx]

still not working. sorry for the newb question but does anyone know how to just insert an increasing number into the ID table instead? Starting at 1. so each time a new entry is inserted, a new increasing id is created, 1, 2, 3 ., etc. I cant find my php for dummies book

[Sam Granger]

in phpmyadmin next to the attribute tick the auto_increment

[Sam Granger]

or just put auto_increment in your sql

[mkx]

Ok thanks, so how would I retype this line:

$sqlquery = "INSERT INTO $table VALUES('$txn_id','next........

Where I want to replace $txn_id with an auto increment number

[Phoenix66]

Just omit the autoincrement field from your query, it will be generated automatically when you insert other fields.

Use mysql_insert_id() to obtain the value of that field right after the insert query, if you need it...

[mkx]

Got it working, thanks!