Jump to content

burnside

Members
  • Posts

    541
  • Joined

  • Last visited

Posts posted by burnside

  1. Then just sit there and click the stumble button and it will take you to VERY random sites. 

     

     

     

     

    Haha you'r not wrong.

     

    1st site: Why linux is better that windows.

    2nd site: how to bake a cake in 6 east steps - i keep that 1 for later ;) so if any 1 wants some cake lol.

  2. I WOULD DO SOME THING LIKE THIS:

     

    <?php
    
    $conn = mysql_connect("localhost", "mysql_user", "mysql_password");
    
    if (!$conn) {
        echo "Unable to connect to DB: " . mysql_error();
        exit;
    }
      
    if (!mysql_select_db("mydbname")) {
        echo "Unable to select mydbname: " . mysql_error();
        exit;
    }
    
    $sql = "SELECT id as userid, fullname, userstatus 
            FROM   sometable
            WHERE  userstatus = 1";
    
    $result = mysql_query($sql);
    
    if (!$result) {
        echo "Could not successfully run query ($sql) from DB: " . mysql_error();
        exit;
    }
    
    if (mysql_num_rows($result) == 0) {
        // NOTHING TO DELETE
        exit;
    }
    
    
    while ($row = mysql_fetch_assoc($result)) {
        // DELETE
    }
    
    mysql_free_result($result);
    
    ?> 
    

     

    Took of the php.net manual : http://uk.php.net/manual/en/function.mysql-fetch-assoc.php

     

    was to lazy to type it out.

  3. i like cookies & also i like cake.

     

    but about your question, is he not refering to your browser font and size?

     

     

    correct me if i am wrong though.

     

    edit: looking at the script :P

     

    it seems as though you can define your own font and size from this array:

     

    
    $type = array("arial", "helvetica", "sans-serif", "courier");
    $size = array("1","2","3","4","5","6","7");
    
    

  4. Hiya MYSQL freaks.

     

    im just curious is it possible to select only selected records from a database. IE:

     

    $select = mysql_query("SELECT * FROM `news` WHERE 'id'='1'")or die(mysql_error()); 
    	while($woot= mysql_fetch_array( $select )) 
    
    	{
    

     

    All i want to know is in the db table nes there is 15 records, is there away to select by id like. if i only want posts with id 1,4,5 & 9?

     

    rather that having several db query

     

×
×
  • 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.