Jump to content

bashaclick

Members
  • Posts

    11
  • Joined

  • Last visited

Posts posted by bashaclick

  1. 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 

     

     

     

  2. Hello ,

    I am looking for some how can make search instead  modules and plugin for sobi2

     

    the idea :

    search -

    Select country - status - city

     

    ex. ( canada , Ontario , Toronto )

    I don't need to select all world

     

    THanks

     

    send me email if you can bashaclick@hotmail.com

     

     

  3. 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

     

  4. 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]

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.