[[SOLVED] Trying to get a random row from db, mysql error:]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #3, 1' at line 1

 

Here is my code atm:

 

<?php
mysql_connect("****","****","****") or die(mysql_error());
mysql_select_db("****");

$generated_number = mysql_query("SELECT COUNT(*) AS cnt FROM mailer") or DIE(mysql_error());

$myquery = mysql_query("SELECT * FROM mailer LIMIT $generated_number, 1") or DIE(mysql_error());

while($r=mysql_fetch_array($myquery))
{

$id=$r["id"];
$flyer=$r["flyer"];
$date=$r["date"];

}


echo "$flyer";
?>

[[SOLVED] array not working :/]

I put each email inside double quotation marks and now it echos "Array".

 

edit: I guess I need to run a loop to echo out each line from the array..

[[SOLVED] array not working :/]

I have a file with the following code:

<?php
$emails = array(email@email.com, email@email.com, email@email.com, email@email.com, email@email.com);
echo $emails;
?>

 

This is returning a white page, how come?

[how to make a task manager in php?]

Like a windows Task Manager?

[[SOLVED] Dropdown selection from variable]

<OPTION <?php if($var == adult){ echo selected="selected"; } ?>>Adult</OPTION>
<OPTION>Alcohol</OPTION>
<OPTION>Bar</OPTION>
<OPTION>Blonde</OPTION>
<OPTION>Brunette</OPTION>
<OPTION>Classic</OPTION>
<OPTION>Men</OPTION>
<OPTION>Sports</OPTION>
<OPTION>Women</OPTION>

 

Something like that going all the way down should do it, I believe. :]

 

[[SOLVED] how do I do this with arrays?]

Thank you

[[SOLVED] undefined index error when updating to php 5]

You said you had a lot of errors? What errors are you getting? Can you post them?

[[SOLVED] how do I do this with arrays?]

Fairly simple question I think, I've just never had to do it before. I'm going to have an array with like 300 items or more and need to be able to delete duplicate items. Is there a function or something I am looking for to do this? Don't want anyone to write it for me but show me which direction to go. Thanks.

 

Array example in case my description sucks:

 

0 - alpha

1 - beta

2 - charlie

3 - beta (gets deleted)

4 - delta

5 - alpha (gets deleted)

[Keeping checkboxes checked after post... ??]

Just check to see if $_POST['whatever'] is set, if it is then make your checkbox with 'checked' in it and if it isn't then make your normal checkbox.

[sort between two list to remove emails and create a third list]

Are they separated by anything? that would be the easiest way is to separate each email by like a comma or something and put each list in to an array and explode the array by your separator. Then compare the lists and remove anything that matches up.

[email list sort]

so now you have 3?

[sort between two list to remove emails and create a third list]

Do you have a database with the lists? If you do, how is it setup and if not, where are you getting/generating your lists from?

[mod_rewrite and form submitting?]

<form action=\"/examples/1/\" method=\"post\" name=\"contact\">

 

I mean I don't get why that isn't right?

[How to stop people from viewing my site.]

I know you hear the google deal all the time, but this happens to be a great time:

http://lonewolf-online.net/computers/kb/php/block-website-access-country/

That article should fix you up.

[[SOLVED] wont update database no error]

Have you tried to echo out $update   $_POST["MM_update"]  &  $_POST["MM_update"], to make sure they are set? You hay not even be running your query by the looks of it. I would try and echo those variables out at the top and make sure I am getting that far at least.

 

You also need a mysql_query like PFM said above 

[Radio and submit button]

Neither of these questions are php related. Radio buttons are basic html and the other would be something to do with javascript I am sure.

 

<input type="radio" name="group1" value="Milk"> Milk
<input type="radio" name="group1" value="Butter"> Butter

 

Name needs to be the same for items in the same group, meaning if you want only one selectable out of 10 options, the name has to be the same for all of them. This topic should probably get moved soon.

[Recurring Actions (Calendar Events)]

Cron jobs wouldn't even be for what you're trying to do. You just want to display information on a calendar, correct? When you set recurring to 0 or 1 in the db, lets say 1 = TRUE, then when you pull events for your db you need to have a special statement for when recurring == 1. Let's say it is an event that is once a week every monday, well just run a loop to display that information for as far as you want to go. If you're showing your calendar month by month, just make it generate the days/times that date is going to be displayed and echo it out. I may have made it sound more confusing than it should be. Hopefully it gives you an idea of where to go

[explode based on uppercase?]

If you do that make sure it isn't just looking for capital letters but capital letters with lower case after and before it, to make sure it is like your example. Also make sure it isn't suppose to be together for whatever reason (can't think of any atm, but im sure there are cases where you put a capital in the word like "McDonalds" or so)

[[SOLVED] Error - No Database Selected]

mysql_connect("localhost","username","password") or die(mysql_error());
mysql_select_db("database");

You have to have your username/password to log in to your database.

[[SOLVED] <br/> not being displayed in IE]

Or like I had stated 2 hours ago, post some code with a better description on your problem, cause so far there isn't really anything anyone will be able to do to help you with what you have given so far.

[[SOLVED] <br/> not being displayed in IE]

I don't see a <br /> tag anywhere.. unless I woke up completely blind of certain code today? You're leaving a lot of information/examples/code or something out here, I don't think you can get help unless you explain better, more code and possibly an example of the problem?

[JS is breaking my table]

^bump^

[PHP and HTML]

If you read from the top of that page to the bottom of it, it will explain what you need to know. I know it's a tough life, but you actually have to read it.

[PHP and HTML]

Read this article: http://alistapart.com/articles/phpcms

It should provide you with the help you need. If you need further help with the code once you get started, I'm sure someone can help

[MySQL broke]

The guy getting pissy.

You tested just before you transfered, and right after you were having database errors? It really depends on what went on around there and how things were done I guess. Just trying to connect to the database and/or grab information from it shouldn't screw it up. Have you looked at the database in anything like phpmyadmin to see that everything was in fact there?

 

Yeah, check logs like matt said.