webmaster1

Please don't send this to the html forum. The post is in relation to mimicking a PHP function. PHP INCLUDE is a convenient way of editing universal sections of pages. It's much quicker to edit one file than several. Let's say a hosting account doesn't support server side. Is there a HTML or possibly a JAVASCRIPT workaround? Belated please and thank you in advanced!

Two fantastic refresher/starting points for anyone reading the thread: http://articles.erkan.se/a-very-basic-web-shop-tutorial/ http://www.oscommerce.com/

Alritey, I've finally made a clear distinction:

One final important question before I read through the suggested guide: Can I work with a merchant account in demo environment or is the only way to learn by actually setting one up? EDIT: One more: Is there a significant difference between an online store and shopping cart?

Thanks akitchin. Well, I'm presuming I have the job but nothings finalized yet. There seems to be plenty of open source / off the shelf solutions though I'm presuming I'd need to know how to build this from the ground up. Are paypal and a merchant account the only two ways of going about this in terms of third party integration? Should I be concerned with any other approach? Does anyone have any thoughts on shopscript free? http://www.php-shopping-cart-tutorial.com/

Hi All, I'm starting a new job and one of the requirements is that I can build an online store. What exactly should I be able to do in relation to this? A basic store using papal seems fairly straight forward though I'm not too familiar with going about it any other way i.e. merchant account. I'd really appreciate if someone could concisely outline what is I need to research to be competent in this area.

Hi All, I'm doing a quick site for a friend of mine but I've just discovered that GeoCities is no longer available. http://help.yahoo.com/l/us/yahoo/geocities/geocities-05.html Can anyone suggest a similar free host alternative? ??? The reason I'm posting here is because I was hoping someone could suggest an alternative that supports PHP. ??? Thanks in advance.

Hi All, A site I'm working on resides on a web hosting service. They said last night that phpMyAdmin was updated and since cPANEL is a third party software then they can't offer much support on it. Under the import tab I no longer have a radio button to upload CSV. I only have a SQL option. ??? ??? ??? ??? ??? ??? ??? ??? ??? Can anybody assist on this? I need to get some data uploaded promptly (its a crm for a call-centre).

Sorry about that Fenway. I'll use the search function going forward. @kickstart: Thank you so much for the query. I've ran it a few times and can't find any fault with it. I don't understand how the consecutive joins work (I didn't even know this could be done). I'm also unfamiliar (not that I'm familiar with much at all tbh) with the use of the nested query in the first join. The issue is solved but I'll leave this open for a few days to see if anyone can shine a little more light on the two points I've just outlined. Thanks again kickstart!

Hi All, I have a CRM that amends records with contact details in a primary table (masterdata) and logs the call results of outbound calls made for each of these records in a secondary table (resultsnotations). When the call result for a record is equal to "Schedule Call-Back" the end user is asked to enter a schedule date. This a means of reminding the end user of outbound call on the day in question (i.e. a To-Do List Reminder). I have a page named let's say schedule.php. I want this page to loop the output (the looping isn't a problem) for each record where its most recent call result (resultsnotations.callresult1) is equal to "Schedule Call-Back" and the schedule date (resultsnotations.scheduledate) is less than or equal to (>=) today's date. I'm having difficulty defining 'today' in my mySQL query. I mistakenly thought I had the correct query below : : SELECT masterdata.masterdataid, masterdata.companyname, masterdata.contactname, IFNULL( resultsnotations.prospectrating, 'Not Rated' ) AS prospectrating, max( resultsnotations.lastactivity ) AS lastactivity, resultsnotations.scheduledate FROM masterdata JOIN resultsnotations ON masterdata.masterdataid = resultsnotations.masterdataid WHERE resultsnotations.callresult1 = 'Schedule Call-Back' AND masterdata.stream='stream4' GROUP BY masterdata.masterdataid ORDER BY resultsnotations.scheduledate After hastily running this live it was pointed out to me that this was not querying the most recent date. Any help would be greatly appreciated. I've tried illustrating my issue a little simpler below:

Hi All, I want to output all records that match under todays date: select * from tablename where scheduledate <= 'today' My column is in datetime: 00-00-0000 00:00 Does anyone know how to go about this?

Yep, still not making any sense of this. All I need is to check if string blank as well as if null.

I've read through both links though I still don't understand. Could someone dumb this down for me a little more?

Thanks for the run-through. Any ideas on how I check for string length using the IFNULL as well?

I want to apply it here: IFNULL(resultsnotations.prospectrating, 'Not Rated') AS prospectratingch and not at the WHERE part. Example: If prospectrating is null or blank then its default value is 'not rated'.

That's exactly it. Any idea's how to work this into the IFNULL condition I'm using?

I think what I'm asking is what's the difference between '' and NULL and how should work this into the IFNULL.

Hi All, I'm using a basic select query puts in a default value if null is returned: SELECT masterdataid, IFNULL(resultsnotations.prospectrating, 'Not Rated') AS prospectratingch, IFNULL(resultsnotations.lastactivity, 'Loaded') AS lastactivity FROM resultsnotations WHERE masterdataid = '339' and prospectrating is null ORDER BY resultsnotations.lastactivity DESC For some reason when I output the row the default value doesn't show. Furthermore when I query for rows will null I can't find any. Am I confusing terminologies here? Is there a difference between NULL and BLANK?

Thanks mchl. That's a lot easier on the eye. I discvovered the issue while making those changes too (typos). Functioning code: SELECT * FROM ( SELECT masterdata.masterdataid, masterdata.companyname, masterdata.contactname, IFNULL( resultsnotations.prospectrating, 'Not Rated') AS prospectrating, IFNULL( resultsnotations.lastactivity, 'Loaded') AS lastactivity FROM masterdata LEFT JOIN resultsnotations ON masterdata.masterdataid = resultsnotations.masterdataid WHERE category = 'CIF' ORDER BY masterdata.masterdataid, resultsnotations.lastactivity DESC ) AS a GROUP BY masterdataid

Hi All, I'm using a basic select query in my php page on two tables at the same time. You'll notice I've used an if, then, else condition succesfully: IF( tablename1.column1 IS NULL , 'Value', tablename1.column1 ) AS columnname SELECT * FROM ( SELECT masterdata.masterdataid, masterdata.companyname, masterdata.contactname, IF( resultsnotations.prospectrating IS NULL , 'Not Rated', resultsnotations.prospectrating ) AS prospectrating, resultsnotations.lastactivity FROM masterdata LEFT JOIN resultsnotations ON masterdata.masterdataid = resultsnotations.masterdataid WHERE category = 'CIF' ORDER BY masterdata.masterdataid, resultsnotations.lastactivity DESC ) AS a GROUP BY masterdataid The problem occurs when I try to use a similar condition for the lastactivity column. I get the following error: MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF( resultsnotations.lastactivity IS NULL , 'Loaded', resultsnotations.lastactiv' at line 9 The only thing different this time around is the fact that I'm calling a value from the second table rather than the first. Can somebody please help me spot where I'm going wrong?

I don't think pspell is on my server. Do I need to install it?

Any takers?

I've gone to the output page and used CTRL+F for the word 'pspell' and it returns 'text not found'.

Is this what I'm looking for?

I used the following lines of code: <?php // Show all information, defaults to INFO_ALL phpinfo(); // Show just the module information. // phpinfo( yields identical results. phpinfo(INFO_MODULES); ?> What should I be looking for?