Jump to content

johnnytz1

New Members
  • Posts

    8
  • Joined

  • Last visited

    Never

Posts posted by johnnytz1

  1. [!--quoteo(post=366805:date=Apr 20 2006, 08:18 AM:name=kenrbnsn)--][div class=\'quotetop\']QUOTE(kenrbnsn @ Apr 20 2006, 08:18 AM) [snapback]366805[/snapback][/div][div class=\'quotemain\'][!--quotec--]
    Take a look at the [a href=\"http://us2.php.net/image\" target=\"_blank\"]image functions[/a].

    Ken
    [/quote]


    ty ill check it out
  2. [!--quoteo(post=366738:date=Apr 20 2006, 03:49 AM:name=Tux User)--][div class=\'quotetop\']QUOTE(Tux User @ Apr 20 2006, 03:49 AM) [snapback]366738[/snapback][/div][div class=\'quotemain\'][!--quotec--]
    Images can be easily resized a uploaded using PHP.
    [/quote]

    is there any examples you can direct me to? Thanks
  3. [!--quoteo(post=363111:date=Apr 9 2006, 03:05 PM:name=johnnytz1)--][div class=\'quotetop\']QUOTE(johnnytz1 @ Apr 9 2006, 03:05 PM) [snapback]363111[/snapback][/div][div class=\'quotemain\'][!--quotec--]
    thanks so far.

    Here is what I want to do.

    My resCoords table and buyCoords table have opposite values.
    Im trying to use the select statement to select a match from either table.

    Is this possible with one select statement as we were trying to do? or would i have to concat the result from the queries? how would that go? thanks.. jtz1 lil bro
    [/quote]

    anyone?
  4. thanks so far.

    Here is what I want to do.

    My resCoords table and buyCoords table have opposite values.
    Im trying to use the select statement to select a match from either table.

    Is this possible with one select statement as we were trying to do? or would i have to concat the result from the queries? how would that go? thanks.. jtz1 lil bro
  5. Ok i been doing a little editing needs some help im a noob.

    [code]$link =mysql_connect($hostname,$username, $password) OR DIE ("Unable to connect to database! Please try again later.");
    mysql_select_db($dbname);

    $arr_b = array("x500y500","x510y500");
    $arr_r = array("x500y510","x500y520","x510y510","x510y520");




    for ($i=0; $i < count($arr_b); $i++){
        $coord_taken .= mysql_query("SELECT * FROM coordsTaken WHERE xyPOS = '$arr_b[$i]'");
        $coord_taken .= mysql_query("SELECT * FROM coordsReserved WHERE xyPOS = '$arr_b[$i]'");
        echo "Already bought";

    }


    for ($i=0; $i < count($arr_r); $i++){
        $coord_reserv .= mysql_query("SELECT * FROM coordsReserved WHERE xyPOS = '$arr_r[$i]'");
        $coord_reserv .= mysql_query("SELECT * FROM coordsReserved WHERE xyPOS = '$arr_r[$i]'");
        echo "Already reserved";
    }


    mysql_close($link);

    ?>[/code]

    Here is what im trying to do. I have created two arrays with identical values that are in the database. I want to step through the database and select the matching rows. If there is a matching row display a message. I know i need a if statement in there. But i am unsure if the select statements are correct.

    thanks again
  6. [!--quoteo(post=362502:date=Apr 7 2006, 07:58 AM:name=eric1235711)--][div class=\'quotetop\']QUOTE(eric1235711 @ Apr 7 2006, 07:58 AM) [snapback]362502[/snapback][/div][div class=\'quotemain\'][!--quotec--]
    that foreach will not work:

    it must be something like

    foreach($my_arr as $my_key => $my_value)

    or

    foreach($my_arr as $my_value)
    and inside the foreach loop, all the results will be overwriten and that final IF will check only the numrows of the last query.
    diy XP
    [/quote]


    ty
  7. Here is my php code but I am unsure that this will work. I am trying to create a array and pass it a variable that checks what is stored in a database. Is this the correct way to do this?

    [code]$my_arr = array();
    $my_arr = $_POST['arr'];

    $link = mysql_connect($hostname, $username, $password) OR DIE ("Unable to connect to database! Please try again later.");
    mysql_select_db($dbname);

    foreach ($my_arr) {
        $result = mysql_query("SELECT * FROM coordsTaken WHERE xyPOS = '$my_arr'");
        $result = mysql_query("SELECT * FROM coordsReserved WHERE xyPOS = '$my_arr'");
    }
    $good = "good";
    $bad = "duplicates";
    if (mysql_num_rows($result) > 0) {
        $rstring .="&message=".$bad."&";
    } else {
        $rstring .="&message=".$good."&";
    }

    echo $rstring."&";
    mysql_close($link);[/code]
×
×
  • 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.