[auto generating fields]

yes ALTER will allow you to do that

[Grabbing a ever changing list of people from a website! Is it possible?]

anything is possible really  , but first off i would ask the site if they have an API you can plug into or some kind of xml feed?

alternatively you will want to fetch the page, and parse it appropriately to get the data you need with get_file_contents()

[auto generating fields]

php and mysql = pretty much anything you want from a website 

[Client Login]

so where does this leave you? are you after assistance or not?

[foreach loop returning extra data.]

but didn't work because both parent.name and node.name are displaying the he same field name.

 

 

I would say you have answered this yourself, you need to seperate out these 2.

Look again what you are passing into the $iterator array, and make sure you only pass the parent to it?

 

without seeing that part of the code, I cannot be sure what is in that array.

 

Also in your SQL you are asking it to return parentname as  node,  and categories as parent, which only adds to confusing me more! and maybe you?

[please check my event code]

will mark is solved once I have heard back and been able to check

[please check my event code]

yeah it came up NULL, and dont have permission to change the global, will be contacting the hosts right now

 

thanks for your help

[Editing table from page - Struggles]

dont sweat it, we all start somewhere. as stated echo out the statement to see what it actually is is also a great debugging help

[Need help on connecting to mysql database from php.]

try localhost instead of the ip address, also use phpmyadmin to check the user accounts and privledges match up

[Editing table from page - Struggles]

also looking at your code and error it might well be that you have characters in your form inputs that might be breaking the SQL statement, such as ' or ` etc.

 

it is very bad practice to put form data directly into an sql statement, thats how sql injection is done. at very least put a mysql_real_escape_string() around every $_POST[]

[please check my event code]

hi all,

 

i wrote an event for a client's database that is supposed to run once a day, but having checked the database again, it doesnt seem to be occuring,

essentially what it does is clear out a row's info and reset it to a 'for sale status' from 'on hold' if its been on hold for more than 2 days.

what it does is working fine, its when it does it that doesn't seem to be working correctly

could anyone confirm for me if i have correctly structured the part that makes it run once a day every day.

 

many thanks

 

CREATE EVENT `checkonhold`
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY
  ON COMPLETION PRESERVE 
DO 

UPDATE `tbl_sales` 
SET 
`Sales_Status` = NULL, 
`Sales_Hold_Date` = NULL, 
`Sales_PrintRequired` = NULL, 
`Sales_Date` = NULL, 
`Sales_User_ID` = NULL, 
`Sales_GalleryDelivery_Date` = NULL, 
`Sales_RetailPrice` = NULL, 
`Sales_Currency` = NULL, 
`Sales_EuroRetailPrice` = NULL, 
`Sales_ArtistPercentage` = NULL,
`Sales_GalleryPercentage` = NULL, 
`Sales_CommissionOther` = NULL, 
`Sales_ClientName` = NULL, 
`Sales_GalleryDiscount` = NULL, 
`Sales_Billed` = NULL 
WHERE `Sales_Status` = 'Hold'
AND `Sales_Hold_Date` < date_sub( 
CURRENT_TIMESTAMP , INTERVAL 2 
DAY ) 
AND `Sales_User_ID` <> 2

 

also would there be any logs on mysql to show it is run daily, so i can further check this

[Different pages in 1 php file?]

php and mysql work very well together, practically every dynamic content website will use these 2 together, or if its asp it would be microsoft sql.

 

you dont need to learn very much sql to achieve what you want with a Q & A application.

 

[fade background image]

jquery can more than likely do it!

[$_FILE Error]

username is not part of the FILE variable, but seperate, perhaps you are looking for name? to get file name.

and because it doesnt exist the move file, becomes just a directory, as the file name isnt on the end location

 

replace all $_FILES['uploadedfile']['username'] with $_FILES['uploadedfile']['name'] might fix it

[Reading text file across network]

if the text file is on a webserver, it could be fetched and read in php using file_get_contents()

[Different pages in 1 php file?]

I just started out with php so I'm pretty much a noob.

How are answers stored normally without a database, in an asp file?

 

php is one language, and asp is another, the 2 really dont mix.

 

you could easy store in a text file, using a delimiter to seperate Q from A but then you lose handy functions that databases can easily be used to do, like sorting, filtering, paging and so on. I am sure you could recreate that with a text file, but why reinvent something when you dont have to.

[Different pages in 1 php file?]

assuming the Q&A are in a database,  using pageination (think thats the right term) and set record limit as 1 row per page.

the form could have hidden value for next page number and when form posts to itself, you know which page is next (i.e next question) and show that, as well as of course checking the current question and answer.

 

 

 

there might be alternative methods but thats what came to me when i read your post

 

 

[php code structure in seo]

I cant imagine how, since search engines never see the raw PHP script, only the finished pages when served from the web server.

[USER UPDATING A FORM WITH DROP DOWN MENUS IN IT]

thats how I would do if it was me, but don't take my method as gospel.

 

something along the lines of how you stated should be fine and in the processing code, if value == 0 then skip update.

[Implementing Paypal Payment into PHP Advert Listings]

paypals ipn info is here https://www.paypal.com/ipn

 

it allows a passback page, which means you can get info back from paypal in a posted form of hidden inputs, and in there should have the advert id passed back, and that should be enough to trigger a delete action on your site. you instruct paypal which page to passback to on successful payment.

[Getting string from looped array]

add the . concatenator to $message should do it, thus each loop will add to the message  string as events are looped

 

$message .="<p><span style=\"font-size:24px\">$event_title</span><br />$eventdate</p><p>$event_description</p>";

[What is the best way to protect your mysql login details?]

put the include file into its own folder and add an htaccess file that prevents users from calling the file via the browser, and makes them only able to be called by scripts on the server

[Difference btw these 2]

only dont go to w3schools as they are not at all associated with w3c and are often giving out incorrect information.

 

but thats a whole different story altogether

[Display data that has been written to the database on the same page load]

i think to get the new value after an UPDATE you will need to do a new SELECT. but i'm not 100% on that

[Difference btw these 2]

yes you would get the same thing at the end.

 

its a technique to prevent errors in your code with undefined variables.

its down to personal preference, but really its better to catch potential errors than not, even if you know that $_POST is going to be there.

 

you dont have to do it, just like you dont have to do many things in code, but in a professional environment, it would be expected to write code that is covering any possible errors that might be thrown.