Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Mixing PHP and HTML output in an ECHO
I cannot believe I haven't run into this until now. Take a look at what I'm trying to do: echo "<option value=$my_office[office_id] <? if ($office == $my_office[office_id]) echo \"selected\"; ?>>$my_office[office_name]"; The embedded PHP shows up in the HTML source... -
Error after moving code from Linux to Win32
I'm having a difficult time figuring out what PHP setting is causing this problem to crop up when I moved an application from a Linux box to a Windows XP machine. On my Linux box, I accessing them like so: echo $row[last]; This same code on my XP box generates this error: Notice: Use of... -
Selecting dates using PHP/MySQL and UNIX Timestamps
I'm building a scheduling module for a large project. I am storing a START time and STOP time in UNIX timestamp format in MySQL INT fields. I didn't use the formal timestamp field type, as I didn't want to deal with the automatic update feature associated with it. Furthremore, (I thought -... -
Selecting specific dates/ranges using MySQL, PHP, and UNIX Timestamps
I'm building a scheduling module for a large project. I am storing a START time and STOP time in UNIX timestamp format in MySQL INT fields. I didn't use the formal timestamp field type, as I didn't want to deal with the automatic update feature associated with it. Furthremore, (I thought -... -
Daylight Savings Time and Timestamps
I have a PHP app where I have to schedule people for X number of weeks at a time. I simply take my UNIX timestamp and increment it by 604800 for each week I need to schedule, which works great with one exception... The TIME in the timestamp changes when I hit April for Daylight Savings time... -
Need some good PHP Calendar code
I am doing dynamic calendar using a MySQL database, and what I really need is some basic example code for display day, week, and month views in a traditional calendar format. If the code already had places to plug in my dynamic data, that would be super cool. I have been all over the Net, and... -
Need help with a tricky query, 3 tables involved
Okay, I'm working with PHP and MySQL. I have 3 tables I'm working with: a Users table, a Sources table, and a Permissions table. Sources have a one to many relationship with the Permissions table. Each entry is just a source id (links to source_id in Sources table) plus a user id (links to... -
Newbie: Selecting data from multiple tables, Join or Sub-Query?
I'm a novice SQL user, in need of some help. My situation is this... I have two tables, one is a users table where naturally each user has a unique id (emp_id). The second table contains records that are owned by one specific user, and there is a field named "emp_id" which contains...
