michellephp

Hi everyone, I am searching for an invoice template for excel (or better, openoffice spreadsheet as that's what I have - but excel docs should work fine). I thought this would be a sinple task - but i have been searching for a couple of hours now and all the templates I have come across either don't work or are just hopeless. Anyone know where I can find one (for free?). I just want it to add up my totals, work out tax etc. Thanks Michelle.

Hi, It's not just beads.html, it's all the other pages, too! Plus the other reasons I mentioned, I don't want to change them to .php.

Hi, Thanks for your reply. Because this would mean a crazy amount of work, and I would prefer them to stay in html for search engines etc. And for existing links to me on other websites (I have many links to my tutorials etc). Is there anything I can do? I thought: # Use PHP4 as default AddHandler application/x-httpd-php4 .php Was meant to fix it? But it doesn't. I do appreciate your help.

Hi, Yes changing it to .php fixed it, however this does not solve the problem because I cannot change all my pages to .php. And the table system is the same (actually copy and pasted) - I am not sure what you mean.

umm, can someone post a screenshot of beads.html? I mean the search and the "view your cart" just under the top menu, in the light purple bar, are missing! But only in all the .html pages - not in the .php pages.

I have just done one of those screenshot test things (that show your website in different browsers) and the php elements are not showing up. I have been reading and think it might be to do with register globals? Any thoughts?

Did you see the search box and the other php element? I have a screen shot, www.mybeads.com.au/images/html.JPG see the circled areas? Now look in www.mybeads.com.au/catalog.php - there are things there. Do they show up in beads.html for you? Please let me know, Thanks, Michelle.

do you see the "search" box at the top menu? Just under 'about us"?

Hi everyone, Suddenly my website has gone a little bonkers. I think it has something to do with my webhost and their php configuration. Firstly, the index.html page was coming up with this weird pop-up: File Download - Security Warning Do you want to save this file , or find a program online to open it? Name: mybeads_com_au Type: Unknown File type, 35.4kb From: Mybeads.com.au Find Save Cancel My webhost fixed that, however all the php elements in all .html pages are not working. Things such as: <?php include("inc/viewcontents.php"); ?></td><td bgcolor="#F7D6FE" height="35" align="right"><?php include("inc/search.php"); ?> They just don't work in the .html pages such as www.mybeads.com.au/beads.html But they do work in the .php pages, such as www.mybeads.com.au/catalog.php (see top menu bar, search and view contents). Not to mention that my shopping cart admin now doesn't work - I log in, but as soon as I try to change anything it tells me my password is incorrect. Please help. Thanks, Michelle.

I'm sorry for bumping, but I really need some help with this. I am willing to pay (see freelancing section). Surely someone out there has done heaps of paginations and knows what I am doing wrong? Even if I have to start over, seriously I need your help and it would mean so much to me to fix this. Thank-you, Michelle.

Hi Barand, I'm not sure I understand... what does that mean? [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]So you should be able to determine whether property is sold or not.[/quote] It is working so far as it updates the db... it's just when the button is clicked it updates the db to 'no' first (i want 'yes' first). I thought maybe this was happening because of this line is sold.php $update = "update items set sold = '".$sold."' where id = ".$_REQUEST['id']; See i thought there should be another " at the end.... but I get this error when I add one: Parse error: syntax error, unexpected '"' in /home/homebuy/public_html/sold.php on line 23 But when I take the " out (ie where id = .$_REQUEST) I get: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /public_html/sold.php on line 23 Do you think this could have something to do with it?

OK, I have found some code, which sort of makes it work, however it is not pulling the search results. This is the new code - how do I adapt my exisiting code to use this new stuff? $query_p = "SELECT * FROM items WHERE mid = ".$_SESSION['memberID'].".$sort"; [!--coloro:#33CC00--][span style=\"color:#33CC00\"][!--/coloro--]So query_p needs to be the results of the form, eg sql... right?[!--colorc--][/span][!--/colorc--] //echo $query_p; //debug output $query_limit_p = sprintf("%s LIMIT %d, %d", $query_p, $startRow_p, $maxRows_p); $p = mysql_query($query_limit_p, $myconn) or die(mysql_error()); if (isset($_GET['totalRows_p'])) { $totalRows_p = $_GET['totalRows_p']; } else { $all_p = mysql_query($query_p); $totalRows_p = mysql_num_rows($all_p); } $totalPages_p = ceil($totalRows_p/$maxRows_p)-1; $queryString_p = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_p") == false && stristr($param, "totalRows_p") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_p = "&" . htmlentities(implode("&", $newParams)); } } $queryString_p = sprintf("&totalRows_p=%d%s", $totalRows_p, $queryString_p); If you have any idea, I'd really appreciate ANY hints or ideas you have. Thank-you. [!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]By the way, if I take out WHERE mid = ".$_SESSION['memberID'].".$sort from the very first line (above), it says it has ALL properties, (ie showing 1 - 3 of 52 properties), but still shows the 16 that are in the search criteria only (on the first page, ie showing more than the limit of 3!!). But then if you click next, you get "showing 3 -6 of 52" but you see the same 16 properties as on the first page.[!--colorc--][/span][!--/colorc--] I think the code just above is similar to: [a href=\"http://www.phpfreaks.com/quickcode/Pagination/164.php\" target=\"_blank\"]http://www.phpfreaks.com/quickcode/Pagination/164.php[/a] someone must have an idea?

Thanks for your responses, I thought that would be the case but I was hopeful ;) I am just going crazy trying to figure out my pagination problems!!! :(

Just wondering if it's possible to veiw another sites php. view source doesn't work........... but I was really hoping to see this other sites code to try to fix mine ;) I'm guessing the answer is no. Thanks! Michelle.

hi again, I think it definitely has something to do with: $sql .= $sort . $limit; and //Add column sorting if($_REQUEST['sort'] != '') $sort = ' order by price asc '; else $sort = $_REQUEST['sort']; and $limit Please help!!! It's absolutely driving me crazy!!!!!!!!!!!!!!!!!!!!!!!! <EDIT> I forgot to mention, it's a search page that send the results to the page in which contains the code above. Eg search.php --- > properties.php Do I need to enter the limit stuff on the search page instead... maybe?