gabs

no error showing, but wound the answer.. class sitefunctions extends table { function edit_publisher($db) { if (isset($error)){ $error.="Please fix the error(s) above";} else { if ($_POST['id'] <> "") { $update =& new table($db, 'publisher'); $update->find($_POST['id']); $update->name = $_POST['name']; $update->url = $_POST['url']; $update->contact = $_POST['contact']; $update->address = $_POST['address']; $update->phone = $_POST['phone']; $update->email = $_POST['email']; $update->save(); $error = "The Publisher has been edited"; } } } }

Hi I have a table class and functions I want to call in another function but can't get it working. Some help will be very welcome. It seesm that the new table class is not working in this function if I pass the values to it, I have tested the class, it does get the post values I post to it so $_POST['id'] are being received as well as all the other $_POST's but the table class and find function is not working, it works fine if I don't put it in a function.. function edit() { if (isset($error)){ $error.="Please fix the error(s) above";} else { if ($_POST['id'] <> "") { $update =& new table($db, 'publisher'); $update->find($_POST['id']); $update->name = $_POST['name']; $update->url = $_POST['url']; $update->contact = $_POST['contact']; $update->address = $_POST['address']; $update->phone = $_POST['phone']; $update->email = $_POST['email']; $update->save(); $error = "The Publisher has been edited"; } } }

Hi, I have designed this site www.kayakayak.co.uk. Questions: The first page is big, then on reload the image goes smaller, does this work well? 2: There is a stip off images under the main image, does this look bad?

Hi, ok. I will take those critics on board, I have done another website, called www.kayakayak.co.uk. I didn't try and make the site as prophesional as possilbe, but just a plain easy, e-commerce site. I was wondering what do you guys think of the first page as it opens, it has a big image, then as the page reloads, the image goes much smaller? Regards

Hi, ok. I will take those critics on board, I have done another website, called www.kayakayak.co.uk. I didn't try and make the site as prophesional as possilbe, but just a plain easy, e-commerce site. I was wondering what do you guys think of the first page as it opens, it has a big image, then as the page reloads, the image goes much smaller? Regards

Hi Every one, a while ago I wanted to sell some second hand domian names, I found that domain name companies ask alot for it and want you to jump through hoops that I could not be bothered to do. SO I started this website called www.letlay.com. Where I ask only a $1 per website for sell lising submission. Firstly I want to promote it (offcourse) but I really would want some advice on a few things. First general user journey, look and feel. 2. Content, I use articles and images as content on the website to hopefully bolster it a bit for the search engines. Also the general business idea. The ideas is to let your domain name lay untill it sells. Thus www.letlay.com!

Hi, I have a questions that pertains to 2 of my websites, I've had these website for more than 5 years - atleast one of them. The one is www.rightmove.co.za - my question with this one is: 1. the domain is a south african domain name, the hosting server is in the US will this descriminate against the site? 2. There is a very poplur site with same name in the uk, how can I over come this because they spend millions a year on seo so if someone puts in rightmove, they get mostly the uk site. Next domain is: www.buyorselldomainnames.net someone told me that if you have key words in your domain name it is good, is it? because this makes the domain really long..

Hi, I have a questions that pertains to 2 of my websites, I've had these website for more than 5 years - atleast one of them. The one is www.rightmove.co.za - my question with this one is: 1. the domain is a south african domain name, the hosting server is in the US will this descriminate against the site? 2. There is a very poplur site with same name in the uk, how can I over come this because they spend millions a year on seo so if someone puts in rightmove, they get mostly the uk site. Next domain is: www.buyorselldomainnames.net someone told me that if you have key words in your domain name it is good, is it? because this makes the domain really long..

It is a SQL server using an ODBC driver...but don't let that put you off it works exactly the same..

Hi, I would be grateful if somone can point me in the right direction here...I am querying a data base and want to get dates between a start date ($sdate) and end date ($edate).. then if there is more than 60 entries..i want to use every 30th entry ( so that I effectively use months) if it there is more than 730 entries (2 years) I want to use every 365th entry ( so that I  use years effectively) i can't get the code to use and are not even sure how it is suppose to look like, I would be grateful if someone can help me here... [code]$query = "SELECT date, CONVERT(varchar(12), date, 111) AS 'converted' FROM Enquiries  WHERE date BETWEEN '".$sdate."' AND '".$edate."'"; $result = odbc_exec($conn, $query) or die (odbc_error()); while ($row = odbc_fetch_object($result)){ array_push($day, $row->converted); $dates = array_unique($day); $amountdays = count($dates); if ($amountdays >= 730) { for( $i = 0 ; $i < $amountdays ; $i += 365 ){ array_push($array_y, $dates[$i]); } } else if (($amountdays < 730) && ($amountdays > 60)) { for( $i = 0 ; $i <  $amountdays  ; $i+= 30 array_push($array_y, $dates[$i]); } } else { $array_y = $dates; } }[/code]

Ok, I have found my own answer.... [quote] $papertype = "SELECT Quantity FROM Enquiries WHERE Depth = 297 AND Width = 210" } $query = $papertype; $result = odbc_exec($conn, $query) or die (odbc_error());[/quote]

Hi, I want to insert PHP in an SQL statement..how do I do this? This is what I want to do...           [code] $A4 = "Depth = 297 AND Width = 210 "; [color=red]*[/color]$query = "SELECT Quantity FROM Enquiries WHERE $A4"; $result = odbc_exec($conn, $query) or die (odbc_error());[/code] [quote]I get this error message... Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ''., SQL state 37000 in SQLExecDirect in C:\Program Files\xampp\htdocs\valuesx.php on line 93 37000[/quote] line[font=Verdana] [color=red]93 is *[/color][/font]