Search found 8 matches

by Smithers
Wed Apr 10, 2013 11:33 am
Forum: CSS / Styling
Topic: Change background color according to sql entry
Replies: 1
Views: 2144

Change background color according to sql entry

Hello, I was wondering if it's possible to change the background color of a page depending on the sql entry. For example if I have 3 sql entries: 1 is drinking, 2 is eating, 3 is sleeping; the user chooses drinking, he will see the page in blue, he chooses sleeping, it would be red. I would be very ...
by Smithers
Tue Aug 21, 2012 9:58 am
Forum: SQL
Topic: Checkbox filter
Replies: 3
Views: 3008

Re: Checkbox filter

Hi Temor, here's what I've got so far: $sql = "SELECT * FROM house"; $result = mysql_query($sql); if(!$result) { echo 'no houses are available yet.'; } else { if(mysql_num_rows($result) == 0) { echo 'no houses are available yet.'; } else { echo '<table border="1"> <tr> <th>state<...
by Smithers
Mon Aug 20, 2012 9:41 am
Forum: SQL
Topic: Checkbox filter
Replies: 3
Views: 3008

Checkbox filter

Hi Jacek,
I was searching through you site and was looking for a tutorial on sql checkbox filter.
I'd like to display certain results based on checkboxes:

Thanks,
by Smithers
Wed Mar 14, 2012 6:20 pm
Forum: PHP
Topic: displaying sql data on different pages
Replies: 3
Views: 837

Re: displaying sql data on different pages

Thanks a lot,
I start loving you ;-)
by Smithers
Wed Mar 14, 2012 9:02 am
Forum: PHP
Topic: displaying sql data on different pages
Replies: 3
Views: 837

displaying sql data on different pages

Hey there, I am not quite sure how to explain my plan but I just give it a try. Basically I want to display results from an sql query into a search engine kind of style. Lets say, I have 15 results in my query, currently these results are displayed in a simple table. However what I would like to hav...
by Smithers
Wed Feb 22, 2012 9:11 am
Forum: SQL
Topic: Join two MySQL tables into PHP
Replies: 4
Views: 4171

Re: Join two MySQL tables into PHP

Hi Jacek, another question regarding sql joins. I managed to show the results of two tables but I am not sure how to insert information from one table automatically to anothers. In this case I have a table of users and topics Users - id - username - email - topics Topics - id - title - content - use...
by Smithers
Wed Feb 08, 2012 5:23 am
Forum: SQL
Topic: Join two MySQL tables into PHP
Replies: 4
Views: 4171

Re: Join two MySQL tables into PHP

Hi there,
many Thanks, worgs great.
Cheers
by Smithers
Mon Feb 06, 2012 3:10 pm
Forum: SQL
Topic: Join two MySQL tables into PHP
Replies: 4
Views: 4171

Join two MySQL tables into PHP

Hello there, Currently I am learning PHP/MySQl and there is one issue that most likely is extremly simple but still I just don't get it into my head. Let's say I have two tables with this content: Company - company_name - company_location Game - game_name - game_rating Now I would like to combine th...