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.
User Profile
Collapse
-
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... -
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.Leave a comment:
-
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);...
No activity results to display
Show More
Leave a comment: