bashaclick

Hello, I want your help I have this code case "addads": // $qry = "INSERT INTO 4sale_categories SET catImage1 = '".mysql_real_escape_string(trim($_GET['catImage1']))."' , catImage2 = '".mysql_real_escape_string(trim($_GET['catImage2']))."' , catImage3 = '".mysql_real_escape_string(trim($_GET['catImage3']))."', catImage4 = '".mysql_real_escape_string(trim($_GET['catImage4']))."', catImage5 = '".mysql_real_escape_string(trim($_GET['catImage5']))."', admin_id = '0', phone = '".mysql_real_escape_string(trim($_GET['phone']))."', email = '".mysql_real_escape_string(trim($_GET['email']))."', subcategory = '".mysql_real_escape_string(trim($_GET['subcategoryid']))."', categoryName = '".mysql_real_escape_string(trim($_GET['categoryid']))."', description = '".mysql_real_escape_string(trim($_GET['description']))."', device_token = '".mysql_real_escape_string(trim($_GET['device_token']))."', created = NOW()"; $sql = mysql_query($qry); I want to make condition if catImage1 is null insert default value in catimage1 or keep same data Thank you

Thank you this my simple code mysql_connect("localhost", "root", "asdasd") or die("Could not connect: " . mysql_error()); mysql_select_db("attawy"); $extract = mysql_query("SELECT customer_id FROM orders ORDER BY customer_id DESC"); $extract_e = mysql_fetch_assoc($extract); mysql_query("INSERT INTO orders (customers_id,customers_name) values ('". $extract_e['customer_id'] + 1 ."','kossu')"); and show me error Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource !!! Any Idea Thank

HI All, I would like create query when I add some one is look what the last number in field and add one ? example : you can see the img in attach IDT is primary key + auto increment Customer_id is number field customer _name is name how can create this login IDT Customer_ID Customer_name 112 5 bbbb 113 6 ccccc 114 7 eeeee Also I need the inster function and is look the last field in customer_ID and Increase one ( +1) Any help PLZ/ THanks [attachment deleted by admin]

it's should be like $query = "SELECT * FROM table prayerwall order by id DESC "; try it

Thank you man .

No solution to make simple editor or if you know how can make bold in text email ?

Hi there, I have form to send newsletter and I use text encoding not HTML. Do you know the best editor to make BOLD or Space when i write email. I don't need HTML editor I need for text . Thanks