Latest Bytes Forum

Hi everyone, I have a project that I'm working in which the user is allowed to create and add columns to certain tables in mysql. After they add them, I need to be able to display them in a form so I can use them. Now, that part isn't a problem, but what I'm having a problem w/ is that when I submit them through the form, how can I...

I was trying to use the ftp_put command. It worked for the files in the same directory as my php file, but if I try to fetch a file somewhere else on the server with the following syntax for the source file it doesn't work. "\\server\directory_path\filename" also it didn't work with "//server/directory_path/filename"

Howdy, I have a table full of names, last & first, and I would like to do a SQL select to get all of the last names that start with A-H (I'll run another for I-P & Q-Z). The resulting last name, first name combo needs to end up in a drop down box. I can get the results of a query into a drop down just fine, but I can't get the SQL...

Hi I want to be able to split the contents of a text field into two or maybe three columns. The text field contains text AND HTML mark-up. My initial thought was to find the middle character and then go to the nearest space and split the text that way, but it sometimes splits in the middle of an HTML tag: not pretty! My next idea was...

Hey guys, I'm building a web application in php for the first time (I like php a lot..) and have come across a litle stumbling block. I want to access a passed url parameter with $HTTP_GET_VARS in a class, but I can't get it to work. Note the following php page, which creates an object that pulls the "param" parameter in both the class...

I have PHP script running complex query and then calculating data for different conditions from received result set. Actually, it's doing the same as if I would make several queries with different conditions on same data in DB. Calculating data in PHP instead of running several queries (each query has joins on several tables with several...

Hi all, I'm just curious to how forums store the body of messages. Is it just as text in a DB? This seems to me as if the DB would take on gigantic proportions if a lot of people posted regularly. Or is there another trick which is used? I was thinking perhaps saving messages as a text file, with the Db storing a link to the message and...

Hi guys, I'm trying to add php_xslt and php_dom_xml extension to the php interpreter, but the interpreter can't load the files also if they are in the right directory. It happens only for this dlls, not for all the extensions. the libs required by php_xslt are stored correctly in the libs directory (I think that php_xslt bedds only...

Using the GD library, I'm having a bit of difficulty getting imagecolorallocate() to work as I would expect it to. Using a call of $color = imagecolorallocate ($image, 255, 0, 0); (after loading with $image = imagecreatefromjpeg( $filename );), I would expect a call to imageline() using $color to draw a red line. Under GD 2.0.12 this...

Is there a way to reference the 'primary key' field of a record you are actually inserting at the moment. Im using an 'int auto increment' field as the primary key. I could reference it with a select statement and adding a 1 to the last record's primary key. However, there must be a better way to do this - what if someone adds a record...

I have a forum that has registrations dates that were recovered from a previous bulletin board system. All the dates reverted/changed to 2000 rather than the correct 2001-2002. When I look in mySQL I see the dates in a format like "953024461". Since it's not a format I recognize, I don't know how I can go in and edit the dates to 2002. What...

Howdy, For a project I am working on right now I need to be able to calculate the time difference between to given times. (For example...The difference between 11:30 am and 1:45pm being 2:15) Right now the input is setup as 2 text boxes, 2 dropdowns, and 2 radio groups. The text boxes get the hour entered into them, the drop downs holdd...

Let's say I run a server. I have two people using the server. Bill and Joe. Bill is at address.com/bill and Joe is at address.com/joe. Let's say Joe and Bill are both using PHP with sessions on their web pages. Let's say they both create the session variable $_SESSION. Each uses yo for a different purpose. Now we have a user accessing...

How do you make it source your source code is unreadable? I went to a website and tried to look at their source, and it came up blank. I then saved the file and got a message saying something about will not save properly but i saved it anyways. when i went to pull it up it was blank. i would like to do that to my site if possible!! could...

Hello, i have db with text field contents links <A href="http://www.in.world" target=_blank>In.World</A>, After system upgrading links appears as: http://www.my.server/"http://www.in.world/" in MSIE (Win), and: http://www.my.server/\"http://www.in.world\" in Mozilla (Lin) Before upgrade all was correct. my system is now: Linux MDK 2.4.18,...

Hi!, I am using PHP/MySQL on RH Linux 8.0 with these RPMs installed: php-4.2.2-8.0.5 asp2php-0.76.2-3 php-pgsql-4.2.2-8.0.5 php-dbg-server-2.10pl3-6 php-ldap-4.2.2-8.0.5 php-dbg-base-2.10-4

Today I decided to teach myself both PHP and XML ... so I decided to make a little address book. After I finished it I found this: http://www.tonymarston.net/php-mysql/sablotron.html which describes more or less what I did. The main difference is that users are able to add entries into my address book. When an entry is added I get all of...

I have 2 parallel systems for php development Debian linux with apache and PHP4 and Windows XP professional with apache & PHP4 I have been in the habit of debugging on the xp machine before I upload to the debian server If I run this example , it works fine on the linux web server _________________________________

Anyone know if I can run PHP script at command line? Thanks in advance!! -Steven

I'm very new to PHP and am trying to figure out how to parse out a variable "HTTP_REFERER". My reason for this is my site was recently "FEATURED" (sic) on a website called FARK.COM. Because of this I received over 100,000 Hits in less then one hour and it caused my host's server farm to crash. While I understand that I could move to a more...

I have a table of users in mySQL that appears to have a lot of duplicates. What's the best way to look at the userID and email and delete the duplicates? Thanx, Wm

Yesterday, I ran into a problem that seems to stem from an unusual behavior of mysql_fetch_row() and mysql_fetch_assoc(). Specifically, I have a query that selects all of the id's of fields matching certain criteria, and I want to then fetch the complete results of a certain subset of those fields, depending on the current result page and...

Hello Everyone: I would like to make some charts based on data I am retrieving from my DB. The charts should be things like bar-charts, pie-charts, line-graphs etc. Th charts can be in any browser-friendly format (PNG, GIF, JPG).

Hi! Is it possible to generate an export file and still showing different HTML page?? I have a page and when the user clicks on a link I generate export file (with header and data after header) and the page remains the same. It would be nice if I could show another page, like message "data generated!". And I have another question. I...

I am trying to run a fuultext search on two identical tables and use UNION to join the results but no matter what I try, I get a syntax error on the UNION clause. Here's the query: (SELECT ID, Area_Title, Page_Description, MATCH ( Page_Description ) AGAINST ( 'searchforest tree safety' ) AS Score FROM Site_Area_Lookup WHERE MATCH (...