php sql variable (revised)

ghost

0 0

17 years ago

Alright, I asked this in my previous thread but it was garbled etc, so I thought I would ask here. Ok, here's what I need. I have a SQL table with 3 fields, username, password and id. I have manually set the id for me (the only person registered) to 1. What I need to do is to be able to retrieve the value of that column, and add 1 for the next person that registers so it tracks who registered in what order. Can anyone help me out?

ghost

0 0

17 years ago

try something like this: $SQL = SELECT MAX(id) FROM table

then execute the query, grab the result of the query and increment it

ghost

0 0

17 years ago

Yea…I know that but it doesn't work that way. First I realized you have to use LAST(id) and not max, that could cause errors. But it's much more than that, the code should look something like this:

$result = mysql_query(&quot;SELECT LAST(id) FROM users&quot;);
while($row = mysql_fetch_array($result))
{
mysql_select_db(&quot;slpctrl_users&quot;, $con);
mysql_query(&quot;INSERT INTO users (id)VALUES (&#39;$result&#39;)&quot;);
mysql_close($con);
}

Or somethin, but between adding the other information (username and password) I can't get it to work. :@

ghost

0 0

17 years ago

Ok, here's my code.

&lt;html&gt;
&lt;body&gt;
&lt;?php
$username = addslashes($_POST[&#39;username&#39;]);
$password = addslashes($_POST[&#39;password&#39;]);
$con = mysql_connect(&quot;localhost:phpmyadmin&quot;,&quot;censor&quot;,&quot;censor&quot;);
if (!$con)
{
die(&#39;Could not connect: &#39; . mysql_error());
}
$userid = (&quot;SELECT LAST(id) FROM users&quot;);
if ($username == &quot;&quot; || $password == &quot;&quot;)
{
die(&#39;&lt;b&gt;&lt;center&gt;Please specify username or password&lt;/b&gt;&lt;/center&gt;&lt;br&gt;&lt;br&gt;&#39;);
}
while($row = mysql_fetch_array($userid))
{
mysql_select_db(&quot;slpctrl_users&quot;, $con);
mysql_query(&quot;INSERT INTO users (username, password, id)VALUES (&#39;$username&#39;, &#39;$password&#39;, &#39;$userid&#39;)&quot;);
mysql_close($con);
}
echo(&#39;&lt;center&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;&lt;a href=&quot;memberlist.php&quot;&gt;View Registered Members&lt;/a&gt;&lt;/center&gt;&#39;);
?&gt;
&lt;/body&gt;
&lt;/html&gt;

Now, without the: while($row = mysql_fetch_array($userid)) { } and without id and $userid in the query, it works fine but not with it. And I for the life of me can't figure out what is right >_<