Hello,
Do you check the how many rows return. You can display rows count
with following PHP code. If rows count is zero, you can see the blank page.
:)
$num_rows = mysql_num_rows($result);
echo ($num_rows);
--
Haydar TUNA
Republic Of Turkey - Ministry of National Education
Education
I think you don't need to break this into two queries... this is really a SQL
question,
not a PHP question...
Just do a join on the two tables:
* where table1.cal_id = table2.cal_id
and then have a where clause that does all your filtering:
* and table1.Date now() and
On Saturday, December 16, 2006, Jeffrey wrote;
Have you tried...
echo p $query /p;
...to unsure the variables have the values you expect them to have?
---
Another thing to try (particularly with SELECT statements) is to cut
and paste the echoed query from your browser to the DBMS prompt
Louie Miranda wrote:
I have this code below, it fetches data on a mysql database. I was hoping
you could give me a code hint on where could, my goal is to display this
data on a browser which i did already and be able to edit it via a form.
edit? - table1=value - table2=value
I dont know where
got round the problem like this
select distinct(to_days(date_file_created)), date_file_created from files
Pete M wrote:
why does this
select date(date_file_created) from files
create the error
error near near '(date_file_created) from files' at line 1
trying to extract the date part of the