User Profile

Collapse

Profile Sidebar

Collapse
pinzasso
pinzasso
Last Activity: Aug 22 '07, 11:06 PM
Joined: Aug 2 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • pinzasso
    replied to Problem with displaying tables
    in PHP
    I am learning as I go here, but any recomendations on how to make it safer are appreciated (even though this is for a intranet).

    I get:
    Warning: mysql_fetch_arr ay(): supplied argument is not a valid MySQL result resource

    All other queries work unless I am searching this one field.
    See more | Go to post

    Leave a comment:


  • pinzasso
    started a topic Problem with displaying tables
    in PHP

    Problem with displaying tables

    This code works fine for most searchs and displays fine. But when a few fields are searched (only one comes to mind) it gives me a msql error on what would be line 11 here.

    [PHP]$result = mysql_query("SE LECT * " . "FROM $_POST[table] " ."WHERE $_POST[col_select] = $_POST[search_text]");
    echo "<table border='1'> <tr>";
    $dataQuery=mysq l_query("SELECT...
    See more | Go to post

  • pinzasso
    replied to Help with multiple queries
    in PHP
    actually it was simply as the = statement changeing the data to be entered..i wasn't sure if == was useable in php but it seems to be.
    See more | Go to post

    Leave a comment:


  • pinzasso
    started a topic Help with multiple queries
    in PHP

    Help with multiple queries

    The second query works fine by itself, so why doesn't it work when the first query is in front of it and the else is triggered?
    still spits out the print with no errors.

    [PHP]
    <? include("dbconn ect.php");
    $result = mysql_query("SE LECT CTRL_NUM "
    . "FROM inventory "
    ."WHERE CTRL_NUM = $_POST[ctrl_num] ");

    $res = mysql_fetch_arr ay($result);...
    See more | Go to post
No activity results to display
Show More
Working...