RE: [PHP-DB] Problem with retrieving Data with MySQL

2002-07-19 Thread joakim . andersson
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 the results from the the latest

Re: [PHP-DB] Problem with retrieving Data with MySQL

2002-07-18 Thread Maureen
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-mail

Re: [PHP-DB] Problem with retrieving Data with MySQL

2002-07-18 Thread Blaine D. Dinsmore
$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

Re: [PHP-DB] Problem with retrieving Data with MySQL

2002-07-18 Thread Maureen
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

Re: [PHP-DB] Problem with retrieving Data with MySQL

2002-07-18 Thread Maureen
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