[SOLVED] Getting userid

[ShaolinF]

Hi Guys,

 

I need to populate 2 tables with data. One is the users table and the other is a purchase table. Now this is the code I am using for the users table:

 

$insert = mysql_query("INSERT INTO users VALUES ('', '".$_SESSION['NAME']."', '".$_SESSION['CONTACTNO']."', '".$_SESSION['EMAILADD']."', '".$_SESSION['GENDER']."')");

 

Now for the purchase field, is there anyway I could grab the userid for the user above without going through a lengthy SELECT statement ? Please note, there is no user registration allowed on the website.

[p2grace]

Sure can

 

$userid = mysql_insert_id();

 

Edit: Make sure you put that after the query.

[ShaolinF]

Thanks. I have now added the INSERT for purchase and am getting the following error:

 

Parse error: syntax error, unexpected T_VARIABLE

 

code (ERROR is in the $insert variable):

//Grab userid and eventid to be used for purchase table
$userid = mysql_insert_id();
$eventid = mysql_query("SELECT eventid FROM event WHERE eventset = 1")
//Update time to time of input into DB


// Add purchase details
$insert = mysql_query("INSERT INTO purchase VALUES ('', '$userid', '$eventid', '".$_SESSION['TICKET']."', '".$_SESSION['TOTALPRICE']."', 'N', '')") or die(mysql_error());

[revraz]

Missing a semi colon

 

$eventid = mysql_query("SELECT eventid FROM event WHERE eventset = 1"); <------

[p2grace]

Yeup,

 

Nice catch revraz

[ShaolinF]

Thanks, didnt see that.

 

Yet again another 2 problems. First of all, I am trying to insert the date into the table but its not going.

 

This is how I defined the column:

timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

 

How I am adding date into the the column:

$date  = date("D dS M,Y h:i a");	//Update time to time of input into DB

// Add purchase details
$insert2 = mysql_query("INSERT INTO purchase VALUES ('', '$userid', '$eventid', '".$_SESSION['TICKET']."', '".$_SESSION['TOTALPRICE']."', 'N', '$date')") or die(mysql_error());

 

sECOND PROBLEM:

the eventid when inserted into the db does not work. See code:

 

$eventid = mysql_query("SELECT eventid FROM event WHERE eventset = 1");

 

 

[revraz]

Since you set the MySQL Column to TIMESTAMP, you have to follow their format.

 

'0000-00-00 00:00:00'

[p2grace]

sECOND PROBLEM:

the eventid when inserted into the db does not work. See code:

 

$eventid = mysql_query("SELECT eventid FROM event WHERE eventset = 1");

 

Is the name of the field "eventid"?  You could also try using complete syntax.

 

$eventid = mysql_query("SELECT `eventid` FROM `event` WHERE `eventset` = '1'");

[ShaolinF]

Well I checked its output and it gave me a resource # something. I will have to use mysql_fetch_array. Is there any other way as I only want 1 record ?

[revraz]

You have to fetch the resource.

[p2grace]

That's not returning the actual id.  You need to do something like this:

 

$run = mysql_query("SELECT eventid FROM event WHERE eventset = 1");
$eventid = mysql_result($run,"0","eventid");