Yes indeed, it is skewed. There isn't anything I can do about it however because the other programmer already has his code sorting it out this way but with Perl.
Basicly I'm trying to return the field name if the data within that column ='s the variable I set.
What if I'm trying to retreive multiple field names by matching a column they own.
like:
*E404
Joe
*E403
Joe
*E402
Joe
*E401
Jim
If I did a search for Joe, I would get E404, E403, E402, E401..
Am I explaining this well enough?
Give or take 15 different dept numbers.
Perhaps it's the SQL statement? The loop looks flawless. Or maybe there should be a SQL statement within the loop.
I did, it returns:
Print("[$sent_superemail] controls [$query] with a total of [$count]");
[JMONTGOM] controls [SELECT * FROM employees WHERE dept IN ('E1433')] with a total of [1]
this is still only giving me back one entry.
$count = 0;
$result = mysql_query("SELECT dept FROM $dbtable WHERE superemail = '$sent_superemail' ");
$query = "SELECT * FROM $dbtable WHERE dept IN (";
if ($result)
{
while ($row = mysql_fetch_array($result))
{
if ($count > 0)...
$row = mysql_query("SELECT dept FROM $db_table WHERE superemail = '$sent_superemail' ");
$set_dept = $row[?];
$sql = "SELECT * FROM $dbtable WHERE dept = '$set_dept' "
Basicly I'm trying to get the dept based on the superemail, but I can't figure out how I would do it. I'm farely new to SQL...
This isn't getting put into the database, maybe it's because of a syntax error.. I'm not getting any error messages:
$creation = "INSERT INTO $uber_table ( `subject` , `comment` , `modif_sc` , `name` , `type`, `date` )
VALUES ('$subject', '$comment'...
Is there a way to bring up a "save as" dialog to save a certain set of variables? I also have a <textarea> that needs to be saved this way to.
Thanks ^_-
aye, got it =)
$query = "SELECT * FROM $uber_table";
$result = mysql_query($query);
Retrieve($result);
// Retrieve This Data and put into link form.
//
function Retrieve($array)
{
while ($rows = mysql_fetch_array($array))
{
printf("<a href='%s'>%s</a> <br>\n", $rows['ID']...
$query = "SELECT subject FROM $uber_table";
$result = mysql_fetch_array(mysql_query($query));
Retrieve($result);
// Retrieve This Data and put into link form.
//
function Retrieve($array)
{
foreach($array as $value)
Print("$value <br>");
}
Just trying to get this to print out all...
Would anyone know why I might not be getting an error message after trying to insert something into a database?
It doesn't actually insert, and it worked fine yesterday..
The only thing I did was add new fields in the database.
Help greatly appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.