Forum: MySQL  May 30th, 2009 |
| Replies: 4 Views: 654 Does it work if you only order by one of the terms by removing the + and the following statement? |
| Forum: MySQL May 29th, 2009 |
| Replies: 2 Views: 466 Not sure about VB but PHP5 should be like this:
$con = mysql_connect( "HOST ADDRESS" , "USERNAME" , "PASSWORD" );
// this is to select a database after connecting.
mysql_select_db( "DB_NAME" ,... |
| Forum: MySQL Apr 27th, 2009 |
| Replies: 14 Views: 1,512 You would just have to count the result of the rows for example when before you echo out the results (in the mysql_fetch_array) you would do this:
// count the number of entries retuned by the... |
| Forum: MySQL Apr 26th, 2009 |
| Replies: 1 Views: 417 What is the issue you are having exactly? |
| Forum: MySQL Apr 26th, 2009 |
| Replies: 1 Views: 369 Do you have a server side language? |
| Forum: MySQL Apr 26th, 2009 |
| Replies: 14 Views: 1,512 Great so you solved the issue by mysql_real_escape ing the string?
Just for others that may come across this post.
Also would you not consider adding a timestamp as apose to a formatted date? |
| Forum: MySQL Apr 25th, 2009 |
| Replies: 14 Views: 1,512 Try typing your query into phpMyAdmin and see if that returns any rows for the query.
It seems that the query will not return the rows due to the fact MySql will not use that format of time. It... |
| Forum: MySQL Apr 22nd, 2009 |
| Replies: 14 Views: 1,512 It would seem that you will need to run a mysql_num_rows check on your query, it seems that the query is returning no matches or start dates.
echo mysql_num_rows( $q );
// $q being whatever... |
| Forum: MySQL Apr 21st, 2009 |
| Replies: 14 Views: 1,512 Ok can you use a client like phpMyAdmin to view the tables themselves?
If so do the dates indeed look like that?
What is the field name in wich the dates come under?
Have you changed the... |
| Forum: MySQL Apr 19th, 2009 |
| Replies: 1 Views: 1,024 Ok the issue from what I can see is the way in wich you are connecting to the database.
Try this method:
$con = mysql_connect( "SERVER" , "USERNAME" , "PASSWORD" )
or die( "Could not... |
| Forum: MySQL Apr 19th, 2009 |
| Replies: 14 Views: 1,512 Ok so where the loop is (while( $row = mysql_ ) you need to change the array's to the names of each field on the rows of your table.
HTML FILE:
<html xmlns="http://www.w3.org/1999/xhtml">... |
| Forum: MySQL Apr 19th, 2009 |
| Replies: 14 Views: 1,512 You didn't seem to actually make the query in the PHP document.
Where you wrote you need to actually send the query. For example what you would do is
$date = $_POST[%D %M %Y];
$query =... |
| Forum: MySQL Apr 15th, 2009 |
| Replies: 1 Views: 603 I'm not 100% sure but it usually means one of the following
- The file does not exist
- The file does not have the correct permissions (chmod[linux/unix]/Read Only[windows/dos])
- MySql doesn't... |
