> From: Blaine D. Dinsmore [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 8:18 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Problem with retrieving Data with MySQL
>
>
> Can somone tell me what is wrong with my code here?
> My e-mail does not mail me
I was wrong, you can use DATE_FORMAT in the sql query. I usually format it
after I take it out, using php. I apologize.
Maureen <[EMAIL PROTECTED]> said:
> First of all, the function mysqlconn does not exist (unless you created it
in
> your script). There is mysql_connect, where you pass
First of all, the function mysqlconn does not exist (unless you created it in
your script). There is mysql_connect, where you pass the connection
parameters for the database, ie. hostname, username, password, etc. Then you
query the database with mysql_query($sql).
There is also just mysql($d
$sql = "SELECT probid,loggerid,DATE_FORMAT(logdate,'%m-%d-%Y') AS date," .
"priority,interface,screen,descript,notes " .
"FROM bugs WHERE probid='$issue'";
"Maureen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> It might help if you send the list an
It might help if you send the list an indication of what $sql (the query)
looks like. The only thing it appears to be returning is what was initially
sent to the function.
Maureen
"Blaine D. Dinsmore" <[EMAIL PROTECTED]> said:
> Can somone tell me what is wrong with my code here?
> My e-mai
Can somone tell me what is wrong with my code here?
My e-mail does not mail me the results from the the latest database entry:
//
// Mail Handler Routine
/
function mailer($issue,$host,$sql){