[PHP-DB] Problem with an update after an insert: MySQL

[Bestman4unowwa]

I'm having trouble with having trouble with doing an update after doing an  
insert on and a select on a table. The order of execution is:
 
 $result = mysql_query(select token from  tokenuserid where  userid = 
'$none' );
if (!$result)
echo  mysql_error();
 
  $numresult = mysql_num_rows($result);
$row =  mysql_fetch_row($result);
$gotToken =  $row[0];

$generatedToken =  date(YmdHis);
$result = mysql_query(insert into tokenuserid  values ('$generatedToken', 
'$none'));
 
  $result = mysql_query(update tokenUserid set userid = '$userid'  where 
token = '$gotToken');
if (!$result)
echo  can't find user; 
 
I can't get this update to take. Actually, I can get this to work on one  
implementation of this database and on the next implementation of this it  
doesn't work. returning the error after the update. The MySQL version is  
3.23.52. 
Is it because I have a capital U in the name tokenUserid in the update  
statement? I could believe this as a reason since the table is defined as:  
tokenuserid - (without any caps). If this is the problem then why does it occur 
 in one 
implementation and not the other?

Re: [PHP-DB] Problem with an update after an insert: MySQL

[Bestman4unowwa]

Bastien, Thanks for your help!. 
 
I think I found the answer to my problem. My system is a windows based  
system and it is not windows based. The system where the code doesn't work is  
Unix 
and is case sensitive. I went online to the mysql reference and found this  
link, _http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html_ 
(http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html) 

[PHP-DB] Any recomendations on a report writer to use with MY-SQL

[Bestman4unowwa]

Does Crystal Reports work with MY-SQL? Are there any open source tools that  
are like Crystal Reports?

[PHP-DB] Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

[Bestman4unowwa]

When I have a html page with an embedded php method behind a button, when I click the 
button I can't run the PHP, instead my browser pops up a dialog box with a request a 
file download of my PHP script.

Also, when I run a php in my browser either nothing happens or I get the file load.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

[Bestman4unowwa]

Thanks Peter and Jasper. I changed the httpd.conf to make sure they point to the 
proper Load module and add type and PHPInidir but still no luck.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Can't access HTTP Post Array

[Bestman4unowwa]

I'm running Apache/2.0.49 and PHP/4.3.5 on windows XP with MSIE 6.0. -- local host.

When I try to access the variables in the array (HTTP POST), they are empty or null. 
Did I miss a PHP or Apache setting in the php.ini or httpd.conf?

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] TMP folder Keeps getting changed back to Read Only

[Bestman4unowwa]

Is there something in windows xp that negates my turning off the read only?

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php