timtom3

[!--quoteo(post=384281:date=Jun 15 2006, 12:12 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jun 15 2006, 12:12 PM) [snapback]384281[/snapback][/div][div class=\'quotemain\'][!--quotec--] I don't know of any off-hand, but as I recall, the Developer Zone on the MySQL site has a number of them. [/quote] Cheers mate, I see your from Toronto, a bit of the subject but are there a lot of tours run from TO to Niagara?

Hi does anybody have a tutorial on how to cluster?

Hi if I want to remove an item in my database for example an e-mail address for a table using a text box where the user enters there e-mail address then clicks unsubscribe, how would i get the e-mail address to check if its in the database

Hi I was just wondering if there was any free graph scripts that were easy to install as I have a page count on my site that goes into mysql and would like to display it as a graph. Also how would i collecet the information for what time of day a page has been view and with what browser?

How easy would it be to set up and control a community website using the following programs? VirtuaNews - for reviews PhotoPost - for users to upload photo's vBulletin Version 3.0.7 - blog section Has anybody ever done this? tim

[!--quoteo(post=366922:date=Apr 20 2006, 01:05 PM:name=utahcon)--][div class=\'quotetop\']QUOTE(utahcon @ Apr 20 2006, 01:05 PM) [snapback]366922[/snapback][/div][div class=\'quotemain\'][!--quotec--] Most hosts will provide a contained CRON or schedule task that you can hammer out. If that is 100% not an option you can create a scheduled task on your own machine to call a PHP script once a day and run your script. Other than doing one of those two there is nothing I know that will solve this problem for you. BTW - Which host is this so I can avoid them. [/quote] its streamline.net They have given me shh. access but apparently they don't allow cron jobs or the use of system command.

Hi My ISP doesn't allow me to use the system command or CRON jobs, I need a tutorial that will create a back up script for the past 7 days on a page load probably that will run once a day if a particular page is visited does anybody know of such a tutorial?

[!--quoteo(post=351911:date=Mar 5 2006, 05:46 PM:name=timtom3)--][div class=\'quotetop\']QUOTE(timtom3 @ Mar 5 2006, 05:46 PM) [snapback]351911[/snapback][/div][div class=\'quotemain\'][!--quotec--] hi doesn't give any errors just doesn't display the data [a href=\"http://members.lycos.co.uk/timtom1111/admin/profiletest.php?username=mkandola\" target=\"_blank\"]http://members.lycos.co.uk/timtom1111/admi...ername=mkandola[/a] [/quote] :( still not displaying anything

[!--quoteo(post=351905:date=Mar 5 2006, 05:30 PM:name=php_b34st)--][div class=\'quotetop\']QUOTE(php_b34st @ Mar 5 2006, 05:30 PM) [snapback]351905[/snapback][/div][div class=\'quotemain\'][!--quotec--] can you show us some code? I just looked at the link and it is the code, my error [/quote] hi doesn't give any errors just doesn't display the data [a href=\"http://members.lycos.co.uk/timtom1111/admin/profiletest.php?username=mkandola\" target=\"_blank\"]http://members.lycos.co.uk/timtom1111/admi...ername=mkandola[/a]

Hi on here [a href=\"http://members.lycos.co.uk/timtom1111/script.txt\" target=\"_blank\"]http://members.lycos.co.uk/timtom1111/script.txt[/a] my script isn't displaying the information, the SQL statement does work when carried out in the databse? I know i am doing something stupid as I have it working without the last bit on just displaying one record but I need to display it when username is present

Something wrong with this??? DELETE FROM product p, images i WHERE p.product_ID = '.$product_ID.' AND i.prod_id = '.$product_ID.' Product table Product_ID (primary key) Image table prod_id has to match product_id

Is it possible to delete information from two tables with one delete statement? For example DETELE * FROM product p, images i WHERE product_id.p = images_id.i ? Becuase when I try this it doesn't work?

bought excel to mysql program

Here is an example of the text file I have how do i convert this to MySQL? Link Here

I get an error every time i try to upload it

How do I import a CSV file into MySQL using phpMyAdmin my table is set out like this: CREATE TABLE zipcodes ( zipcode varchar(9) NOT NULL default '0', latitude decimal(13,12) NOT NULL default '0.000000000000', longitude decimal(13,12) NOT NULL default '0.000000000000', town varchar(25) NOT NULL default '0', address1 varchar(25) NOT NULL default '', address2 varchar(25) NOT NULL default '', county varchar(30) NOT NULL default '', PRIMARY KEY (zipcode), UNIQUE KEY zipcode_2 (zipcode), KEY zipcode (zipcode) ) TYPE=MyISAM; My data is set out like this: zipcode Latitude Longitude town address1 address2 county BB1 1BA 53.74564368 -2.4715445 Blackburn Bristol Close Lancashire

Hi ppl I have discovered a major flaw in my website, when I do a search on a post/zipcode it only picks up the zipcodes that are in the property table. I have another table called zipcodes which contains all the zipcodes of the area. What should happen is that a user should enter their own zipcode (this zipcode is already stored in zipcode table) and it can find properties around that the users zipcode. At the moment you have to enter a zipcode that is in the property table and it finds the properties from there, which is wrong. Its either SQL1 or SQL3 but I can't see where I should alter or add. I know I haven't entered zipcode table anywhere but not sure where to put it. Code Here case 'none': $sql_3 = "SELECT * FROM property p, cmstype t WHERE SQRT( (69.1 * (".$userLat." - p.latitude)) * (69.1 * (".$userLat." - p.latitude)) + (53.0 *(".$userLong." - p.longitude)) * (53.0 *(".$userLong." - p.longitude))) I think userlat and userlong need to be the ones from Zipcode table but it doesn't return any results when I change SQL 1 to Zipcodes